Valid from List & Label 10
The Excel export module offers two modes: a full layout export and a pure data export from the table object. List & Label offers two ways to influence the export type:1. Using the Excel export's option dialog
You'll get into this dialog by choosing 'Microsoft Excel Format' in the print options dialog and then clicking on the button on the right hand side of the format combo box. On the 'Output' tab you can choose to export only table data. You can also choose to ignore header and footer lines as well as group lines.
2. Using the API
The parameter Export.OnlyTableData enables you to only export the data from the table object:
LlXSetParameter(LL_LLX_EXTENSIONTYPE_EXPORT,"XLS","Export.OnlyTableData","1")
Once this property has been set, you can set the group and header line behavior by setting XLS.IgnoreGroupLines and XLS.IgnoreHeaderFooterLines to the required values.
LlXSetParameter(LL_LLX_EXTENSIONTYPE_EXPORT,"XLS","XLS.IgnoreGroupLines","1")
LlXSetParameter(LL_LLX_EXTENSIONTYPE_EXPORT,"XLS","XLS.IgnoreHeaderFooterLines","1")
Both ways yield the same result - the Excel file usually will not contain empty cells, which helps very much if the result is to be postprocessed in Excel.
Related articles:
KBTE000656
IDKBTE000655 KBTE000655