Artifact
ef0ff69329e6d013e16df7166b89b1c673daa761c9ab6c6d90305f7e483858b4:
Wiki page
[man-page] by
alex
2018-08-27 11:25:01.
D 2018-08-27T11:25:01.685
L man-page
P fe8165cd4c5eab6b8dc1524eb1cfaf123ca11b171c54b31299744326f7fdbbfd
U alex
W 5925
<h2>Man-Page</h2>
<pre>
::ooxml::Default name value
::ooxml::RowColumnToString rowcol
::ooxml::StringToRowColumn name
::ooxml::CalcColumnWidth numberOfCharacters ?maximumDigitWidth? ?pixelPadding?
::ooxml::xl_sheets file
::ooxml::xl_read file args
::ooxml::xl_write args
::ooxml::tablelist_to_xl lb args
</pre>
<hr>
<b><a id="BORDERLINESTYLE">BORDERLINESTYLE</a></b>
<p>dashDot | dashDotDot | dashed | dotted | double | hair | medium | mediumDashDot | mediumDashDotDot | mediumDashDotDot | none | slantDashDot | thick | thin</p>
<b><a id="COLOR">COLOR</a></b>
<p>0-65<br>Aqua | Black | Blue | BlueRomance | Canary | CarnationPink | Citrus | Cream | DarkSlateBlue | DeepSkyBlue | Eucalyptus | Fuchsia | Gray | Green | Karaka | LavenderBlue | LightCoral | LightCyan | LightSkyBlue | Lime | Lipstick | Maroon | Mauve | MediumTurquoise | Myrtle | Navy | NavyBlue | NightRider | Nobel | Olive | OrangePeel | PeachOrange | Portage | PrussianBlue | Purple | Red | RoyalBlue | SaddleBrown | SafetyOrange | Scampi | Silver | TangerineYellow | Teal | White | Yellow | SystemBackground | SystemForeground<br>RGB<br>aRGB</p>
<b><a id="DEGREE">DEGREE</a></b>
<p>0-360</p>
<b><a id="DIAGONALDIRECTION">DIAGONALDIRECTION</a></b>
<p>up | down</p>
<b><a id="HORIZONTAL">HORIZONTAL</a></b>
<p>left | center | right</p>
<b><a id="PATTERNTYPE">PATTERNTYPE</a></b>
<p>darkDown | darkGray | darkGrid | darkHorizontal | darkTrellis | darkUp | darkVertical | gray0625 | gray125 | lightDown | lightGray | lightGrid | lightHorizontal | lightTrellis | lightUp | lightVertical | mediumGray | none | solid</p>
<b><a id="VERTICAL">VERTICAL</a></b>
<p>top | center | bottom</p>
<hr>
<pre>
::ooxml::Default name value
name = path
</pre>
<hr>
<pre>
::ooxml::RowColumnToString rowcol
return name
</pre>
<hr>
<pre>
::ooxml::StringToRowColumn name
return rowcol
</pre>
<hr>
<pre>
::ooxml::CalcColumnWidth numberOfCharacters {maximumDigitWidth 7} {pixelPadding 5}
return width
</pre>
<hr>
<pre>
::ooxml::xl_sheets file
return sheetInformation
</pre>
<hr>
<pre>
::ooxml::xl_read file
-valuesonly -keylist -sheets PATTERN -sheetnames PATTERN -datefmt FORMAT
return <a id="workbookData">workbookData</a>
</pre>
<hr>
<pre>
::ooxml::xl_write
constructor args
-creator CREATOR
return class
</pre>
<pre>
::ooxml::xl_write
method numberformat args
-format FORMAT -general -date -time -datetime -iso8601 -number -decimal -red -separator -fraction
-scientific -percent -text -string
return <a id="NUMFMTID">NUMFMTID</a>
</pre>
<pre>
::ooxml::xl_write
method defaultdatestyle <a href="#STYLEID">STYLEID</a>
</pre>
<pre>
::ooxml::xl_write
method font args
-list -name NAME -family FAMILY -size SIZE -color <a href="#COLOR">COLOR</a> -scheme SCHEME -bold -italic -underline -color <a href="#COLOR">COLOR</a>
return <a id="FONTID">FONTID</a>
</pre>
<pre>
::ooxml::xl_write
method fill args
-list -patterntype <a href="#COLOR">COLOR</a> -fgcolor <a href="#COLOR">COLOR</a> -bgcolor <a href="#COLOR">COLOR</a>
return <a id="FILLID">FILLID</a>
</pre>
<pre>
::ooxml::xl_write
method border args
-list -leftstyle <a href="#BORDERLINESTYLE">BORDERLINESTYLE</a> -leftcolor <a href="#COLOR">COLOR</a> -rightstyle <a href="#BORDERLINESTYLE">BORDERLINESTYLE</a> -rightcolor <a href="#COLOR">COLOR</a>
-topstyle <a href="#BORDERLINESTYLE">BORDERLINESTYLE</a> -topcolor <a href="#COLOR">COLOR</a> -bottomstyle <a href="#BORDERLINESTYLE">BORDERLINESTYLE</a> -bottomcolor <a href="#COLOR">COLOR</a>
-diagonalstyle <a href="#BORDERLINESTYLE">BORDERLINESTYLE</a> -diagonalcolor <a href="#COLOR">COLOR</a> -diagonaldirection <a href="#DIAGONALDIRECTION">DIAGONALDIRECTION</a>
return <a id="BORDERID">BORDERID</a>
</pre>
<pre>
::ooxml::xl_write
method style args
-list -numfmt NUMFMTID -font <a href="#FONTID">FONTID</a> -fill <a href="#FILLID">FILLID</a> -border <a href="#BORDERID">BORDERID</a> -xf XFID
-horizontal <a href="#HORIZONTAL">HORIZONTAL</a> -vertical <a href="#VERTICAL">VERTICAL</a> -rotate <a href="#DEGREE">DEGREE</a>
return <a id="STYLEID">STYLEID</a>
</pre>
<pre>
::ooxml::xl_write
method worksheet name
return <a id="sheet">sheet</a>
</pre>
<pre>
::ooxml::xl_write
method column <a href="#sheet">sheet</a> args
-index INDEX -to INDEX -width WIDTH -style <a href="#STYLEID">STYLEID</a> -bestfit -customwidth -string -nozero -calcfit
(autoincrement of column if INDEX not applied)
return column
</pre>
<pre>
::ooxml::xl_write
method row <a href="#sheet">sheet</a> args
-index INDEX -height HEIGHT
(autoincrement of row if INDEX not applied)
return row
</pre>
<pre>
::ooxml::xl_write
method cell <a href="#sheet">sheet</a> {data {}} args
-index INDEX -style <a href="#STYLEID">STYLEID</a> -formula FORMULA -string -nozero -globalstyle -height HEIGHT
(autoincrement of column if INDEX not applied)
return row,column
</pre>
<pre>
::ooxml::xl_write
method autofilter <a href="#sheet">sheet</a> indexFrom indexTo
</pre>
<pre>
::ooxml::xl_write
method freeze <a href="#sheet">sheet</a> index
</pre>
<pre>
::ooxml::xl_write
method presetstyles <a href="#workbookData">workbookData</a>
</pre>
<pre>
::ooxml::xl_write
method presetsheets <a href="#workbookData">workbookData</a>
</pre>
<pre>
::ooxml::xl_write
method write filename
</pre>
<hr>
<pre>
::ooxml::tablelist_to_xl lb args
-callback CALLBACK -path PATH -file FILENAME -creator CREATOR -name NAME -rootonly -addtimestamp -globalstyle
Callback arguments
spreadsheet sheet maxcol column title width align sortmode hide
</pre>
<hr>
Z 9b28f788b52fb524d20095829d5588f2