Index
Modules:
excelin
.
API symbols
`$`:
excelin: `$`(e: Excel): string
excelin: `$`(r: Range): string
`[]=`:
excelin: `[]=`(row: Row; col: string; d: DateTime | Time)
excelin: `[]=`(row: Row; col: string; b: bool)
excelin: `[]=`(row: Row; col: string; f: Formula)
excelin: `[]=`(row: Row; col: string; h: Hyperlink)
excelin: `[]=`(row: Row; col: string; n: SomeNumber)
excelin: `[]=`(row: Row; col: string; s: string)
`[]`:
excelin: `[]`(r: Row; col: string; ret: typedesc): ret:type
addSheet:
excelin: addSheet(e: Excel; name = ""): Sheet
autoFilter:
excelin: autoFilter(sheet: Sheet): Range
autoFilter=:
excelin: autoFilter=(sheet: Sheet; range: Range)
bestFitCol:
excelin: bestFitCol(sheet: Sheet; col: string; yes: bool)
Border:
excelin: Border
border:
excelin: border(start, end, top, bottom, vertical, horizontal = BorderProp(); diagonalUp, diagonalDown = false): Border
BorderProp:
excelin: BorderProp
borderProp:
excelin: borderProp(style = bsNone; color = ""): BorderProp
borderPropStyle:
excelin: borderPropStyle(style = bsNone; color = ""): BorderProp
BorderStyle:
excelin: BorderStyle
borderStyle:
excelin: borderStyle(start, end, top, bottom, vertical, horizontal = BorderProp(); diagonalUp, diagonalDown = false): Border
bsDashDot:
BorderStyle.bsDashDot
bsDashDotDot:
BorderStyle.bsDashDotDot
bsDashed:
BorderStyle.bsDashed
bsDotted:
BorderStyle.bsDotted
bsDouble:
BorderStyle.bsDouble
bsHair:
BorderStyle.bsHair
bsMedium:
BorderStyle.bsMedium
bsMediumDashDot:
BorderStyle.bsMediumDashDot
bsMediumDashDotDot:
BorderStyle.bsMediumDashDotDot
bsMediumDashed:
BorderStyle.bsMediumDashed
bsNone:
BorderStyle.bsNone
bsSlantDashDot:
BorderStyle.bsSlantDashDot
bsThick:
BorderStyle.bsThick
bsThin:
BorderStyle.bsThin
CellFill:
excelin: CellFill
cfFilled:
CellFill.cfFilled
cflAnd:
CustomFilterLogic.cflAnd
cflOr:
CustomFilterLogic.cflOr
cflXor:
CustomFilterLogic.cflXor
cfSparse:
CellFill.cfSparse
clear:
excelin: clear(row: Row)
collapsed=:
excelin: collapsed=(row: Row; yes: bool)
collapsedCol:
excelin: collapsedCol(sheet: Sheet; col: string; collapsed: bool)
cols:
excelin: cols(r: Row): string
copyStyle:
excelin: copyStyle(row: Row; col: string; targets: varargs[string])
excelin: copyStyle(sheet: Sheet; source: string; targets: varargs[string])
createdAt:
excelin: createdAt(excel: Excel; at: DateTime | Time = now())
CustomFilterLogic:
excelin: CustomFilterLogic
deleteSheet:
excelin: deleteSheet(e: Excel; name = "")
empty:
excelin: empty(row: Row): bool
Excel:
excelin: Excel
ExcelError:
excelin: ExcelError
excelinVersion:
excelin: excelinVersion
Fill:
excelin: Fill
fillStyle:
excelin: fillStyle(pattern = PatternFill(); gradient = GradientFill()): Fill
Filter:
excelin: Filter
filterCol:
excelin: filterCol(sheet: Sheet; colId: Natural; filter: Filter)
FilterOperator:
excelin: FilterOperator
FilterType:
excelin: FilterType
foEq:
FilterOperator.foEq
foGt:
FilterOperator.foGt
foGte:
FilterOperator.foGte
foLt:
FilterOperator.foLt
foLte:
FilterOperator.foLte
foNeq:
FilterOperator.foNeq
Font:
excelin: Font
fontStyle:
excelin: fontStyle(name: string; size = 10; family, charset = -1; bold, italic, strike, outline, shadow, condense, extend = false; color = ""; underline = uNone; verticalAlign = vaBaseline): Font
Formula:
excelin: Formula
ftCustom:
FilterType.ftCustom
ftFilter:
FilterType.ftFilter
getCell:
excelin: getCell[R](row: Row; col: string; conv: string -> R = nil): R
getCellIt:
excelin: getCellIt[R](r: Row; col: string; body: untyped): untyped
getSheet:
excelin: getSheet(e: Excel; name: string): Sheet
GradientFill:
excelin: GradientFill
gradientFill:
excelin: gradientFill(stop = GradientStop(); type = gtLinear; degree, left, right, top, bottom = 0.0): GradientFill
gradientFillStyle:
excelin: gradientFillStyle(stop = GradientStop(); type = gtLinear; degree, left, right, top, bottom = 0.0): GradientFill
GradientStop:
excelin: GradientStop
GradientType:
excelin: GradientType
gtLinear:
GradientType.gtLinear
gtPath:
GradientType.gtPath
height:
excelin: height(row: Row): Natural
height=:
excelin: height=(row: Row; height: Natural)
hidden:
excelin: hidden(row: Row): bool
excelin: hidden(sheet: Sheet): bool
hide=:
excelin: hide=(row: Row; yes: bool)
excelin: hide=(sheet: Sheet; hide: bool)
hideCol:
excelin: hideCol(sheet: Sheet; col: string; hide: bool)
Hyperlink:
excelin: Hyperlink
isCollapsedCol:
excelin: isCollapsedCol(sheet: Sheet; col: string): bool
lastCol:
excelin: lastCol(r: Row): string
lastRow:
excelin: lastRow(sheet: Sheet): Row
mergeCells=:
excelin: mergeCells=(sheet: Sheet; range: Range)
modifiedAt:
excelin: modifiedAt[T: DateTime | Time](e: Excel; t: T = now())
excelin: modifiedAt[Node: Workbook | Sheet; T: DateTime | Time](w: Node; t: T = now())
name:
excelin: name(s: Sheet): string
name=:
excelin: name=(s: Sheet; newname: string)
newExcel:
excelin: newExcel(appName = "Excelin"): (Excel, Sheet)
outlineLevel:
excelin: outlineLevel(row: Row): Natural
outlineLevel=:
excelin: outlineLevel=(row: Row; level: Natural)
outlineLevelCol:
excelin: outlineLevelCol(sheet: Sheet; col: string; level: Natural)
pageBreak:
excelin: pageBreak(row: Row; maxCol, minCol = 0; manual = true)
pageBreakCol:
excelin: pageBreakCol(sheet: Sheet; col: string; maxRow, minRow = 0; manual = true)
PatternFill:
excelin: PatternFill
patternFill:
excelin: patternFill(fgColor = $16777215; patternType = ptNone): PatternFill
patternFillStyle:
excelin: patternFillStyle(fgColor = $16777215; patternType = ptNone): PatternFill
PatternType:
excelin: PatternType
prop=:
excelin: prop=(e: Excel; prop: varargs[(string, string)])
ptDarkDown:
PatternType.ptDarkDown
ptDarkGray:
PatternType.ptDarkGray
ptDarkGrid:
PatternType.ptDarkGrid
ptDarkHorizontal:
PatternType.ptDarkHorizontal
ptDarkTrellis:
PatternType.ptDarkTrellis
ptDarkUp:
PatternType.ptDarkUp
ptDarkVertical:
PatternType.ptDarkVertical
ptGray0625:
PatternType.ptGray0625
ptGray125:
PatternType.ptGray125
ptLightDown:
PatternType.ptLightDown
ptLightGray:
PatternType.ptLightGray
ptLightGrid:
PatternType.ptLightGrid
ptLightHorizontal:
PatternType.ptLightHorizontal
ptLightTrellis:
PatternType.ptLightTrellis
ptLightUp:
PatternType.ptLightUp
ptLightVertical:
PatternType.ptLightVertical
ptMediumGray:
PatternType.ptMediumGray
ptNone:
PatternType.ptNone
ptSolid:
PatternType.ptSolid
Range:
excelin: Range
ranges=:
excelin: ranges=(sheet: Sheet; range: Range)
readExcel:
excelin: readExcel(path: string): Excel
resetMerge:
excelin: resetMerge(sheet: Sheet; range: Range)
resetStyle:
excelin: resetStyle(row: Row; targets: varargs[string])
excelin: resetStyle(sheet: Sheet; targets: varargs[string])
Row:
excelin: Row
row:
excelin: row(s: Sheet; rowNum: Positive; fill = cfSparse): Row
rowNum:
excelin: rowNum(r: Row): Positive
rows:
excelin: rows(sheet: Sheet): Row
shareStyle:
excelin: shareStyle(row: Row; col: string; targets: varargs[string])
excelin: shareStyle(sheet: Sheet; source: string; targets: varargs[string])
Sheet:
excelin: Sheet
sheetNames:
excelin: sheetNames(e: Excel): seq[string]
style:
excelin: style(row: Row; col: string; font = Font(size: 1); border = Border(); fill = Fill(); alignment: openArray[(string, string)] = [])
styleBorder:
excelin: styleBorder(row: Row; col: string): Border
excelin: styleBorder(sheet: Sheet; colrow: string): Border
styleFill:
excelin: styleFill(row: Row; col: string): Fill
excelin: styleFill(sheet: Sheet; colrow: string): Fill
styleFont:
excelin: styleFont(row: Row; col: string): Font
excelin: styleFont(sheet: Sheet; colrow: string): Font
toCol:
excelin: toCol(n: Natural): string
toNum:
excelin: toNum(col: string): int
uDouble:
Underline.uDouble
uDoubleAccounting:
Underline.uDoubleAccounting
Underline:
excelin: Underline
uNone:
Underline.uNone
uSingle:
Underline.uSingle
uSingleAccounting:
Underline.uSingleAccounting
vaBaseline:
VerticalAlign.vaBaseline
vaSubscript:
VerticalAlign.vaSubscript
vaSuperscript:
VerticalAlign.vaSuperscript
VerticalAlign:
excelin: VerticalAlign
widthCol:
excelin: widthCol(sheet: Sheet; col: string; width: float)
Workbook:
excelin: Workbook
writeFile:
excelin: writeFile(e: Excel; targetpath: string)