Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Artifact ID: | 434c1c1276754c2b698bfa5dcc11828524e53c1a4cbff8dcfeb7ecdedad548f1 |
---|---|
Page Name: | man-page |
Date: | 2018-07-19 15:15:52 |
Original User: | alex |
Parent: | 8c68f8320cf3a55cd2158e643e436b9d2b7f234e55633433ae211276ac532578 (diff) |
Next | a06cfebfdcba074cb9b4d2f33ead6418cfe232e5268af91ce64f7fdc96e85fca |
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 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
::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