Skip to Content
0
Former Member
Nov 12, 2012 at 05:35 PM

Maintain formatting when exporting to Excel

313 Views

Hello,

We have a VS application which uses the Visual Studio SDK to automatically export reports to Excel. However, this causes the report to loose all formatting. The export behaves as if told to export data only. How can I maintain formatting options when exporting the report? When I try to export the report manually from CR XI-2, I am prompted with settings for column width, etc. How do I set values for the same settings in my code?

I would like the exported Excel to maintain column width and row height settings as well as maintain the font formatting (something it does not currently do).

I have tried changing ExcelFormatOptions so that the columns do not have a fixed width. However, this made no changes to the exported excel...I am using CRXI release 2 to create the reports and the CR13 SDK to export them.

- Kevat