ooxml

Artifact fe8165cd4c5eab6b8dc1524eb1cfaf123ca11b171c54b31299744326f7fdbbfd:

D 2018-08-27T11:20:54.588
L man-page
P 40340bca0631badfdffaa2b8fd0f8ded159e19024f61a7853c1a559826bc6613
U alex
W 5910
<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="#PATTERNTYPE">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">COLOR</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">COLOR</a> -vertical <a href="#VERTICAL">COLOR</a> -rotate <a href="#DEGREE">COLOR</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 db6d43a4114614ccc8e5c8932a6c3eb0