Export to XLS - ImpactV7

Help & Support

Durkin Computing, act! CRM by Swiftypage

Contents

Display Legacy Contents

Search:

Home > Report Designer > Printing > Exporting > Export to XLS

Export to XLS

Home > Report Designer > Printing > Exporting > Export to XLS

Export to XLS

This document details the exporting of a document to an XLS format (Microsoft Excel® 2000-2003).

When exporting a document, you can define XLS-specific export options using the following dialog.

Export mode
Choose one of the available modes to export a document.

- The Single file mode allows export of a document to a single file, without dividing it into pages.

- The Different files mode allows export of a document to multiple files, one for each document page.
Page range
Define the pages which will be included in the result. Separate page numbers with commas; set page ranges using hyphens.
Sheet name
Define the sheet name.
Text export mode
Choose whether value formatting should be converted to the native XLS format string (if it is possible), or embedded into cell values as plain text.
Show grid lines
Check if it's required to show grid lines in the resulting XLS file.
Export hyperlinks
Check if it's required to export hyperlinks.

Unfortunately, not all .NET format strings have their equivalents in an XLS format. If exact conversion is impossible, the XtraPrinting Library tries to find a string that best resembles the original. For example, the .NET "n4" format, representing a numerical value with 4 decimal places, will be converted to "n2" to represent this numerical value with 2 decimal places, since the XLS format does not have a built-in numerical format with 3 or 4 decimal places.

To make sure that your report layout will be preserved in your desired format check to ensure there are no exclamation marks shown for intersecting controls

If you are using the RichText control in your report during export to XLS, all the control's formatting will be lost and its content will be exported as plain text.

Because the XLS format accepts only the Double type for values with a floating point, we recommend that you set this data type instead of Float.

Note
Limitation: A control's Text should be no longer than 4096 characters, otherwise it will be impossible to correctly export it to an XLS format. Thus, if you have, for example, a label with text longer than 4096 characters, we recommend that either this text be split into several parts or you export the document to the similar XLSX format.