D 2019-08-16T20:30:27.379 L examples P 84b0be497973b7dfd5415f99cd34f5598c8a1bc2fa6415044f9a7b571297529b U alex W 3314
Generating XLSX with direct addressing with -index:
You can use numeric index row,col (0,0) or alfanumeric index like Excel does rowcol (A1).
An other way is using autoincrement:
Rows and coulmns are auto incremented and can be skipped by -index like this:
The result will be Value1 in 0,0 (A1), Value2 in 0,4 (E1), Value3 in 0,5 (F1) and Value4 in 3,0 (A4).
There are two helper to convert row,col to string and the other way around.
Result = 0,0
Result = A1
An other helper can calculate the column width of a cell:
Result = 16.7109375
[/artifact/08100118488d4bf3|sample1.tcl]:
Write an Excel file method one: direct addressing with -index.
Output: export1.xlsx
[/artifact/b4c372acfe53d92a|sample2.tcl]:
Write an Excel file method two: with row auto increment.
Output: export2.xlsx
[/artifact/0e61229dc27a38ed|sample3.tcl]:
Exporting a Tablelist to an Excel file.
Output: export3.xlsx
[/artifact/186c1193f2c37296|sample4.tcl]:
Write an Excel file with a formula A1+B1.
Output: export4.xlsx
[/artifact/341a4cbd7d5bc92d|sample5.tcl]:
Write an Excel file with defaultdatestyle set.
Output: export5.xlsx
[/artifact/2e75521984e18f6c|sample6.tcl]:
Write a complex Excel file with a lot of formats.
Output: export6.xlsx
[/artifact/0f8f51f54f5079c8|sample7.tcl]:
Read a complex Excel file (generated by Excel) interpret all known formats and write it back.
Input: original_excel.xlsx
Output: export7.xlsx
[/artifact/a4549c1eb1159a39 |sample8.tcl]:
Read in an Excel file search and replace some cells and write a new file.
Input: form8.xlsx
Output: export8.xlsx
[/artifact/8dd801dcf6626a53 |sample9.tcl]:
Write an Excel file testing new options like wrap.
Output: export9.xlsx