Skip to Content
Former Member
Sep 19, 2008 at 04:18 PM

How do I programmatically specify Excel Data Only as my export type?


When I use the CRViewer to view a report and press the Export button, there are options for exporting to Microsoft Excel 97-2000 (XLS) and Microsoft Excel 97-2000 - Data Only (XLS).

How do these map to the ExportOptions? I'm using ExportOptions to programmatically specify the type of export for a report. I can see that there is a formatType setting with values for things like crEFTExactRichText and crEFTPortableDocFormat and crEFTExcel97, etc. Which value do I use for exporting to Microsoft Excel 97-2000 - Data Only? The documentation doesn't list a constant for a 'data only' formatType.