Artifact
8c68f8320cf3a55cd2158e643e436b9d2b7f234e55633433ae211276ac532578:
Wiki page
[man-page] by
alex
2018-07-19 15:15:19.
D 2018-07-19T15:15:19.718
L man-page
U alex
W 4370
<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
</pre>
<hr>
<b>BORDERLINESTYLE</b>
<p>dashDot | dashDotDot | dashed | dotted | double | hair | medium | mediumDashDot | mediumDashDotDot | mediumDashDotDot | none | slantDashDot | thick | thin</p>
<b>COLOR</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>DEGREE</b>
<p>0-360</p>
<b>DIAGONALDIRECTION</b>
<p>up | down</p>
<b>HORIZONTAL</b>
<p>left | center | right</p>
<b>PATTERNTYPE</b>
<p>darkDown | darkGray | darkGrid | darkHorizontal | darkTrellis | darkUp | darkVertical | gray0625 | gray125 | lightDown | lightGray | lightGrid | lightHorizontal | lightTrellis | lightUp | lightVertical | mediumGray | none | solid</p>
<b>VERTICAL</b>
<p>top | center | bottom</p>
<hr>
<verbatim>
::ooxml::Default name value
name = path
</verbatim>
<hr>
<verbatim>
::ooxml::RowColumnToString rowcol
return name
</verbatim>
<hr>
<verbatim>
::ooxml::StringToRowColumn name
return rowcol
</verbatim>
<hr>
<verbatim>
::ooxml::CalcColumnWidth numberOfCharacters {maximumDigitWidth 7} {pixelPadding 5}
return width
</verbatim>
<hr>
<verbatim>
::ooxml::xl_sheets file
return sheetInformation
</verbatim>
<hr>
<verbatim>
::ooxml::xl_read file
-valuesonly -keylist -sheets PATTERN -sheetnames PATTERN -datefmt FORMAT
return workbookData
</verbatim>
<hr>
<verbatim>
::ooxml::xl_write
constructor args
-creator CREATOR
return class
method numberformat args
-format FORMAT -general -date -time -datetime -iso8601 -number -decimal -red -separator -fraction -scientific -percent -text -string
return NUMFMTID
method defaultdatestyle STYLEID
method font args
-list -name NAME -family FAMILY -size SIZE -color COLOR -scheme SCHEME -bold -italic -underline -color COLOR
return FONTID
method fill args
-list -patterntype PATTERNTYPE -fgcolor COLOR -bgcolor COLOR
return FILLID
method border args
-list -leftstyle BORDERLINESTYLE -leftcolor COLOR -rightstyle BORDERLINESTYLE -rightcolor COLOR -topstyle BORDERLINESTYLE -topcolor COLOR
-bottomstyle BORDERLINESTYLE -bottomcolor COLOR -diagonalstyle BORDERLINESTYLE -diagonalcolor COLOR -diagonaldirection DIAGONALDIRECTION
return BORDERID
method style args
-list -numfmt NUMFMTID -font FONTID -fill FILLID -border BORDERID -xf XFID -horizontal HORIZONTAL -vertical VERTICAL -rotate DEGREE
return STYLEID
method worksheet name
return SHEETID
method column sheet args
-index INDEX -to INDEX -width WIDTH -style STYLEID -bestfit -customwidth -string -nozero -calcfit
autoincrement of column if INDEX not applied
return column
method row sheet args
-index INDEX -height HEIGHT
autoincrement of row if INDEX not applied
return row
method cell sheet {data {}} args
-index INDEX -style STYLEID -formula FORMULA -string -nozero -globalstyle -height HEIGHT
autoincrement of column if INDEX not applied
return row,column
method autofilter sheet indexFrom indexTo
method freeze sheet index
method presetstyles
method presetsheets
method write filename
</verbatim>
<hr>
<verbatim>
::ooxml::tablelist_to_xl lb args
-callback CALLBACK -path PATH -file FILENAME -creator CREATOR -name NAME -rootonly -addtimestamp
Callback arguments
spreadsheet sheet maxcol column title width align sortmode hide
</verbatim>
<hr>
Z 171a9b5d1e7150100c5077958c54238f