LinkBase.ExportToXlsx(String, XlsxExportOptions) Method
Exports a report to the specified file path in XLSX format using the specified XLSX-specific options.
public void ExportToXlsx( string filePath, XlsxExportOptions options )
Public Sub ExportToXlsx( filePath As String, options As XlsxExportOptions )
A String value, specifying the file name (including the full path) for the created XLSX file.
A XlsxExportOptions object, specifying the XLSX export options to be applied when a report is exported.
This method overwrites any files present at the specified path that have the same file name without any warnings.
Once the document export has started, it will run until the resulting document is complete and cannot be interrupted or canceled in the process.
The following two modes of Excel export are available.
This export mode is optimized for subsequent data analysis within Microsoft Excel. Various data shaping options that are applied within the control are retained in the output XLS-XLSX documents (such as native Excel grouping, sorting and filtering settings, as well as improved support for Excel formulas).
With this export mode, the layout of a control’s cells is retained in the resulting Excel documents while specific data shaping options may not be retained.
This is the only export method that is supported by the LinkBase class.