Overview
In a final step, save the tables in data formats needed, e.g. Excel, CSV, HTML, JSON and text files.
- table save() saves tables in text formats, CSV, HTML, JSON tables, etc.
- table save multiple() to save multiple tables in legacy Excel format (Excel XML 2003) into one file.
- variable save() saves a B4P variable tree in a JSON file.
- table save excel file() save one or multiple tables in contemporary Excel format (.xlsx, .xlsm).
Wikipedia Example (continued from step 7)
Save as Excel file
- Apply a theme "Zebra"
- Autowidth, but at least 12 Excel width units wide
- Set autofilter on header row and freeze it
Simple Example
All done.
Saved table(s) to EXCEL file 'Images/Countries.xlsx' containing 1 sheets.
Try it yourself: Open
GUI_Features_Save_and_Export.b4p in
B4P_Examples.zip. Decompress before use.
Viewing the Results:
Test Click on the file name open the file with Excel (.xlsx) : Countries.xlsx (Excel .xlsx format).