<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>