ooxml

Artifact d30e755fec173e8cc37c7f4404cfae24bc22f96af3783b7829d52baff1efde1c:

D 2018-08-25T20:41:21.498
L man-page
P a06cfebfdcba074cb9b4d2f33ead6418cfe232e5268af91ce64f7fdc96e85fca
U alex
W 4454
<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>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 <array variable>
 
    method presetsheets <array variable>
 
    method write filename
</verbatim>

<hr>
 
<verbatim>
::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
</verbatim>

<hr>
Z 56bdc58eac2502e486e178031790cce1