ooxml

man-page
Login

Man-Page

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

BORDERLINESTYLE

dashDot | dashDotDot | dashed | dotted | double | hair | medium | mediumDashDot | mediumDashDotDot | mediumDashDotDot | none | slantDashDot | thick | thin

COLOR

0-65
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
RGB
aRGB

DEGREE

0-360

DIAGONALDIRECTION

up | down

HORIZONTAL

left | center | right

PATTERNTYPE

darkDown | darkGray | darkGrid | darkHorizontal | darkTrellis | darkUp | darkVertical | gray0625 | gray125 | lightDown | lightGray | lightGrid | lightHorizontal | lightTrellis | lightUp | lightVertical | mediumGray | none | solid

VERTICAL

top | center | bottom


::ooxml::Default name value
    name = path

::ooxml::RowColumnToString rowcol
    return name

::ooxml::StringToRowColumn name
    return rowcol

::ooxml::CalcColumnWidth numberOfCharacters {maximumDigitWidth 7} {pixelPadding 5}
    return width

::ooxml::xl_sheets file
    return sheetInformation

::ooxml::xl_read file
    -valuesonly -keylist -sheets PATTERN -sheetnames PATTERN -datefmt FORMAT
    return workbookData

::ooxml::xl_write
    constructor args
        -creator CREATOR
        return class
::ooxml::xl_write
    method numberformat args
      -format FORMAT -general -date -time -datetime -iso8601 -number -decimal -red -separator -fraction
      -scientific -percent -text -string
      return NUMFMTID
::ooxml::xl_write
    method defaultdatestyle STYLEID
::ooxml::xl_write
    method font args
      -list -name NAME -family FAMILY -size SIZE -color COLOR -scheme SCHEME -bold -italic -underline -color COLOR
      return FONTID
::ooxml::xl_write
    method fill args
      -list -patterntype PATTERNTYPE -fgcolor COLOR -bgcolor COLOR
      return FILLID
::ooxml::xl_write
    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
::ooxml::xl_write
    method style args
      -list -numfmt NUMFMTID -font FONTID -fill FILLID -border BORDERID -xf XFID
      -horizontal HORIZONTAL -vertical VERTICAL -rotate DEGREE
      return STYLEID
::ooxml::xl_write
    method worksheet name
      return sheet
::ooxml::xl_write
    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
::ooxml::xl_write
    method row sheet args
      -index INDEX -height HEIGHT
      (autoincrement of row if INDEX not applied)
      return row
::ooxml::xl_write
    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
::ooxml::xl_write
    method autofilter sheet indexFrom indexTo
::ooxml::xl_write
    method freeze sheet index
::ooxml::xl_write
    method presetstyles workbookData
::ooxml::xl_write
    method presetsheets workbookData
::ooxml::xl_write
    method write filename

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