Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Former Member
Not what you were looking for? View more on this topic or Ask a question