Skip to Content

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

Excel format options

We're using Crystal 11.5 & 12 .NET interface.

We want to set certain export formatting options for the Excel Data Only export format and have not been able to find the appropriate properties or methods in the documentation. We have used the following code with the COM interface which works properly. However we have been unable to make this work in .NET. The list of the properties are as follows:

ExportOptions.ExcelExportAllPages = True

ExportOptions.ExcelExportImagesInDataOnly = True

ExportOptions.ExcelUseWorksheetFunctions = True

ExportOptions.ExcelMaintainRelativeObjectPosition = True

ExportOptions.ExcelMaintainColumnAlignment = True

ExportOptions.ExcelExportPageAreaPair = True

Does anyone know what the appropriate .NET methods/properties are for Excel Data Only export?


You will have to use the RAS SDK. Download the Report Application Server 12 SDK help file from here:

and then search for export. Then see ExcelExportFormatOptionsClass properties.

For more info re. RAS see: [original link is broken]


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question