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?

Former Member
replied

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

http://help.sap.com/businessobject/product_guides/boexir31/en/rassdk_net_apiRef_12_en.chm

and then search for export. Then see ExcelExportFormatOptionsClass properties.

For more info re. RAS see:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/10b840c0-623f-2b10-03b5-9d1913866b32

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b050afe0-2fa5-2b10-658d-98f214ba6a4a

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f006a5e6-7e64-2b10-8a84-8b15ca5cacfc

https://www.sdn.sap.com/irj/boc/businessobjects-samples?rid=/webcontent/uuid/b02c1cac-ad86-2b10-88ae-cb36551bab06 [original link is broken]

Ludek

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