To export the table, the ITabSheetExporter interface is used.
The example of export to the XLSX format of regular report sheet with the REPORT_TAB identifier is given. The report contains analytical data area.
As a result of example executing, the regular report sheet is exported in the Table.xlsx file. The file is placed in the root of the C disc.
Executing the example requires to add links to the Metabase, Report, Tab assemblies.
Sub Export;
Var
mb: IMetabase;
Report: IPrxReport;
Table: ITabSheet;
Exp: ITabSheetExporter;
Begin
// Get current repository
mb := MetabaseClass.Active;
// Get regular report
Report := mb.ItemById("REPORT_TAB").Bind As IPrxReport;
// Get table
Table := (Report.ActiveSheet As IPrxTable).TabSheet;
// Create object for export
Exp := New TabSheetExporter.Create;
// Determine table being exported
Exp.TabSheet := Table;
// Determine that hidden rows and columns must be exported
Exp.ExportHiddenCells := True;
// Determine that formulas must be exported
Exp.ExportFormulas := True;
// Determine that objects are not exported
Exp.ExportObjects := False;
// Determine that sheet and cell protection parameters are exported
Exp.SheetAccess := True;
// Export
Exp.ExportToFile("C:\Table.xlsx", "XLSX");
End Sub Export;
See also: