Artifact
1ff5dbb888837829fcaa55d1ca9306b26b79fa4441f9a866d1c87f5b28490a3e:
Wiki page
[examples] by
alex
2018-08-17 21:46:13.
D 2018-08-17T21:46:13.366
L examples
P 4edaf210db140b8e80faad3705c1b4253bb50ca32f7b7ac8955ba02199f5eb13
U alex
W 1013
<h3>Examples</h3>
<hr>
<p>sample1.tcl:</p>
<p>Write an Excel file method one: direct addressing with -index.<br>Output: export1.xlsx</p>
<hr>
<p>sample2.tcl:</p>
<p>Write an Excel file method two: with row auto increment.<br>Output: export2.xlsx</p>
<hr>
<p>sample3.tcl:</p>
<p>Exporting a Tablelist to an Excel file.<br>Output: export3.xlsx</p>
<hr>
<p>sample4.tcl:</p>
<p>Write an Excel file with a formula A1+B1.<br>Output: export4.xlsx</p>
<hr>
<p>sample5.tcl:</p>
<p>Write an Excel file with defaultdatestyle set.<br>Output: export5.xlsx</p>
<hr>
<p>sample6.tcl:</p>
<p>Write a complex Excel file with a lot of formats.<br>Output: export6.xlsx</p>
<hr>
<p>sample7.tcl:</p>
<p>Read a complex Excel file (generated by Excel) interpret all known formats and write it back.<br>Input: original_excel.xlsx<br>Output: export7.xlsx</p>
<hr>
<p>sample8.tcl:</p>
<p>Read in an Excel file search and replace some cells and write a new file.<br>Input: form8.xlsx<br>Output: export8.xlsx</p>
<hr>
Z 3a91ad59c703267ca7b185708f78e7f9