InteractiveFeatures demo

The InteractiveFeatures demos are form-driven Delphi and C++Builder samples for advanced workbook workflows. They are located under Demo/Delphi/InteractiveFeatures and Demo/CBuilder/InteractiveFeatures

Tabs and workflows

• Pivot creates a classic XLS pivot workbook from source data, lets the user choose row, column, page, data, aggregation, subtotal, and number-format settings, and can reopen an existing pivot workbook to summarise saved pivot tables
• TextBox creates standalone classic XLS drawing text boxes with editable text, text runs, line and fill formatting, delete-in-range cleanup, and reopen inspection
• Macro loads, exports, inspects, and clears XLSM vbaProject.bin payloads through the XLSX facade

Primary APIs

TXLSWorkbook.Open
TXLSWorksheet.AddPivotTable
TXLSWorksheet.PivotSetDataFieldFormat
TXLSPivotTable
TXLSPivotField
TXLSPivotDataField
TXLSShapes.AddTextBox
TXLSTextBox
TXLSShapes.DeleteInRange
TXLSXWorkbook.LoadVbaProjectFromFile
TXLSXWorkbook.VbaProject
TXLSXWorkbook.HasVbaProject
TXLSXWorkbook.ParsedVBAProject
TXLSXWorkbook.ClearVbaProject
      

Generated outputs

• InteractiveFeatures.xls for classic XLS pivot and text box workflows
• InteractiveMacro.xlsm for macro payload workflows
• Optional exported vbaProject.bin when the macro tab exports a payload

Related topics

• Classic XLS pivot table API
• TXLSShapes.AddTextBox method
• TXLSTextBox class
• TXLSXWorkbook class
• Examples