The export mechanism performs export to XLSX format by using a free OpenXML SDK library.
Currently, export to the XLSX format is set by default in the Silverlight Viewer.
The export icon in the viewer looks the following way:
If you need to enable export to earlier XLS format, you should add the following code line
After that an XLS export icon becomes available in the viewer:
You can perform export to XLSX format from code in the same way as with any other format by using the following code:
String wFileName = @
PerpetuumSoft.Reporting.DOM.Document doc = Document;
PerpetuumSoft.Reporting.Export.OpenXML.ExcelExportFilter filter =
An export options dialog in Silverlight.
An XLSX export dialog in SharpShooter Reports.Win.
In the Sheet Settings
section, you can select a way of splitting document on sheets
• Export to one sheet
– allows placing all report pages on one Excel document sheet
• Split sheets by pages
– places report pages on separate Excel sheets
• Split sheets by groups
- splits document on groups with help of group marks and then creates sheets for each groups ( For more information refer to http://helpcenter.perpetuumsoft.com/KB/a568/using-groups-to-manage-sheet-split-for-xlsx-export.aspx
Also it is possible to set quality settings such as Custom resolution and picture quality.
The preview of the exported document: