Online Documentation for Advanced Data Export .NET



public SqlManager.QExport.XLS.XlsSheets Sheets {get; set;}



Use property Sheets to export data to several Excel worksheets with possibility to set a specific format and a separate data source for each of them. Sheets is a collection of XlsSheet objects, properties of which totally correspond to the properties of QExportXLS component, including properties Command, DataTable and ListView, which allow you to set data source for each sheet; Options property to set all the sheet options; FieldFormats to set format for each field separately; and more. Also XlsSheet class has a boolean property Exported, which allows you to define, if current sheet is exported or not.


Note, that if you keep the Sheets collection empty, the result file consists of only one sheet, which uses options, set in the component properties, but if you add at least one sheet to the collection, the sheet options are used, and component properties are not taken into consideration.