Index

API symbols

`$`:

• xlsxio: `$`(version: XlsxIOVersion): string

AllEmpty:

• XlsxIOSkip.AllEmpty

EmptyCells:

• XlsxIOSkip.EmptyCells

EmptyRows:

• XlsxIOSkip.EmptyRows

ExtraCells:

• XlsxIOSkip.ExtraCells

hasSheet:

• xlsxio: hasSheet(handle: XlsxioReader; name: string): bool

HiddenRows:

• XlsxIOSkip.HiddenRows

Integer:

• XlsxAddMode.Integer

len:

• xlsxio: len(handle: XlsxioReader): int

None:

• XlsxIOSkip.None

readClose:

• xlsxio: readClose(handle: XlsxioReader)

readGetVersion:

• xlsxio: readGetVersion(): XlsxIOVersion

readOpen:

• xlsxio: readOpen(filename: string): XlsxioReader

readOpenFilehandle:

• xlsxio: readOpenFilehandle(filehandle: File): XlsxioReader

readOpenMemory:

• xlsxio: readOpenMemory(data: ptr; datalen: int; freedata: bool = true): XlsxioReader

readSheetFlags:

• xlsxio: readSheetFlags(handle: XlsxioReaderSheet): XlsxIOSkip

readSheetIntoArray:

• xlsxio: readSheetIntoArray(handle: XlsxioReaderSheet): seq[seq[string]]

readSheetLastColumnIndex:

• xlsxio: readSheetLastColumnIndex(handle: XlsxioReaderSheet): int

readSheetLastRowIndex:

• xlsxio: readSheetLastRowIndex(handle: XlsxioReaderSheet): int

readSheetlistOpen:

• xlsxio: readSheetlistOpen(handle: XlsxioReader): XlsxioReaderSheetList

readSheetNextCell:

• xlsxio: readSheetNextCell(handle: XlsxioReaderSheet): XlsxCell

readSheetNextCellEpoch:

• xlsxio: readSheetNextCellEpoch(handle: XlsxioReaderSheet; cellint: var int64): int

readSheetNextCellFloat:

• xlsxio: readSheetNextCellFloat(handle: XlsxioReaderSheet; cellfloat: var float64): int

readSheetNextCellInt:

• xlsxio: readSheetNextCellInt(handle: XlsxioReaderSheet; cellint: var int64): int

readSheetNextCellString:

• xlsxio: readSheetNextCellString(handle: XlsxioReaderSheet; cellstring: var string): int

readSheetNextCellTime:

• xlsxio: readSheetNextCellTime(handle: XlsxioReaderSheet; celltime: var Time): int

readSheetNextRow:

• xlsxio: readSheetNextRow(handle: XlsxioReaderSheet): int

readSheetOpen:

• xlsxio: readSheetOpen(handle: XlsxioReader; sheetindex: int; skip: XlsxIOSkip = None): XlsxioReaderSheet
• xlsxio: readSheetOpen(handle: XlsxioReader; sheetname: string; skip: XlsxIOSkip = None): XlsxioReaderSheet

readSheetRows:

• xlsxio: readSheetRows(handle: XlsxioReaderSheet): seq[string]

readSheetRowsEpoch:

• xlsxio: readSheetRowsEpoch(handle: XlsxioReaderSheet): seq[float]

readSheetRowsFloat:

• xlsxio: readSheetRowsFloat(handle: XlsxioReaderSheet): seq[float]

readSheetRowsInt:

• xlsxio: readSheetRowsInt(handle: XlsxioReaderSheet): seq[int]

readSheetRowsTime:

• xlsxio: readSheetRowsTime(handle: XlsxioReaderSheet): seq[Time]

readSheets:

• xlsxio: readSheets(handle: XlsxioReader): string
• xlsxio: readSheets(handle: XlsxioReaderSheetList): string

sheets:

• xlsxio: sheets(handle: XlsxioReader): seq[string]

TimeInfo:

• XlsxAddMode.TimeInfo

writeAddCell:

• xlsxio: writeAddCell(handle: XlsxioWriter; value: float64)
• xlsxio: writeAddCell(handle: XlsxioWriter; value: int64; mode: XlsxAddMode = Integer)
• xlsxio: writeAddCell(handle: XlsxioWriter; value: string)
• xlsxio: writeAddCell(handle: XlsxioWriter; value: Time)

writeAddCellEpoch:

• xlsxio: writeAddCellEpoch(handle: XlsxioWriter; value: int64)

writeAddCellFloat:

• xlsxio: writeAddCellFloat(handle: XlsxioWriter; value: float64)

writeAddCellInt:

• xlsxio: writeAddCellInt(handle: XlsxioWriter; value: int64)

writeAddCellString:

• xlsxio: writeAddCellString(handle: XlsxioWriter; value: string)

writeAddCellTime:

• xlsxio: writeAddCellTime(handle: XlsxioWriter; value: Time)

writeAddColumn:

• xlsxio: writeAddColumn(handle: XlsxioWriter; name: string; width: int)

writeClose:

• xlsxio: writeClose(handle: XlsxioWriter)

writeGetVersion:

• xlsxio: writeGetVersion(): XlsxIOVersion

writeNextRow:

• xlsxio: writeNextRow(handle: XlsxioWriter)

writeOpen:

• xlsxio: writeOpen(filename: string; sheetname: string): XlsxioWriter

writeSetDetectionRows:

• xlsxio: writeSetDetectionRows(handle: XlsxioWriter; rows: int)

writeSetRowHeight:

• xlsxio: writeSetRowHeight(handle: XlsxioWriter; height: int)

XlsxAddMode:

• xlsxio: XlsxAddMode

XlsxCell:

• xlsxio: XlsxCell

xlsxioread_close:

• xlsxio_read_core: xlsxioread_close(handle: XlsxioReader)

XlsxioReader:

• xlsxio_read_core: XlsxioReader

XlsxioReaderSheet:

• xlsxio_read_core: XlsxioReaderSheet

XlsxioReaderSheetList:

• xlsxio_read_core: XlsxioReaderSheetList

xlsxioread_free:

• xlsxio_read_core: xlsxioread_free(data: cstring)

xlsxioread_get_version:

• xlsxio_read_core: xlsxioread_get_version(pmajor: ptr cint; pminor: ptr cint; pmicro: ptr cint)

xlsxioread_get_version_string:

• xlsxio_read_core: xlsxioread_get_version_string(): cstring

xlsxioread_list_sheets:

• xlsxio_read_core: xlsxioread_list_sheets(handle: XlsxioReader; callback: xlsxioread_list_sheets_callback_fn; callbackdata: pointer)

xlsxioread_list_sheets_callback_fn:

• xlsxio_read_core: xlsxioread_list_sheets_callback_fn

xlsxioread_open:

• xlsxio_read_core: xlsxioread_open(filename: cstring): XlsxioReader

xlsxioread_open_filehandle:

• xlsxio_read_core: xlsxioread_open_filehandle(filehandle: cint): XlsxioReader

xlsxioread_open_memory:

• xlsxio_read_core: xlsxioread_open_memory(data: pointer; datalen: uint64; freedata: cint): XlsxioReader

xlsxioread_process:

• xlsxio_read_core: xlsxioread_process(handle: XlsxioReader; sheetname: cstring; flags: cuint; cell_callback: xlsxioread_process_cell_callback_fn; row_callback: xlsxioread_process_row_callback_fn; callbackdata: pointer): cint

xlsxioread_process_cell_callback_fn:

• xlsxio_read_core: xlsxioread_process_cell_callback_fn

xlsxioread_process_row_callback_fn:

• xlsxio_read_core: xlsxioread_process_row_callback_fn

xlsxioread_sheet_close:

• xlsxio_read_core: xlsxioread_sheet_close(sheethandle: XlsxioReaderSheet)

xlsxioread_sheet_flags:

• xlsxio_read_core: xlsxioread_sheet_flags(sheethandle: XlsxioReaderSheet): cuint

xlsxioread_sheet_last_column_index:

• xlsxio_read_core: xlsxioread_sheet_last_column_index(sheethandle: XlsxioReaderSheet): csize_t

xlsxioread_sheet_last_row_index:

• xlsxio_read_core: xlsxioread_sheet_last_row_index(sheethandle: XlsxioReaderSheet): csize_t

xlsxioread_sheetlist_close:

• xlsxio_read_core: xlsxioread_sheetlist_close(sheetlisthandle: XlsxioReaderSheetList)

xlsxioread_sheetlist_next:

• xlsxio_read_core: xlsxioread_sheetlist_next(sheetlisthandle: XlsxioReaderSheetList): cstring

xlsxioread_sheetlist_open:

• xlsxio_read_core: xlsxioread_sheetlist_open(handle: XlsxioReader): XlsxioReaderSheetList

xlsxio_read_sheetlist_struct:

• xlsxio_read_core: xlsxio_read_sheetlist_struct

xlsxioread_sheet_next_cell:

• xlsxio_read_core: xlsxioread_sheet_next_cell(sheethandle: XlsxioReaderSheet): cstring

xlsxioread_sheet_next_cell_datetime:

• xlsxio_read_core: xlsxioread_sheet_next_cell_datetime(sheethandle: XlsxioReaderSheet; pvalue: ptr int64): cint

xlsxioread_sheet_next_cell_float:

• xlsxio_read_core: xlsxioread_sheet_next_cell_float(sheethandle: XlsxioReaderSheet; pvalue: ptr cdouble): cint

xlsxioread_sheet_next_cell_int:

• xlsxio_read_core: xlsxioread_sheet_next_cell_int(sheethandle: XlsxioReaderSheet; pvalue: ptr int64): cint

xlsxioread_sheet_next_cell_string:

• xlsxio_read_core: xlsxioread_sheet_next_cell_string(sheethandle: XlsxioReaderSheet; pvalue: ptr cstring): cint

xlsxioread_sheet_next_row:

• xlsxio_read_core: xlsxioread_sheet_next_row(sheethandle: XlsxioReaderSheet): cint

xlsxioread_sheet_open:

• xlsxio_read_core: xlsxioread_sheet_open(handle: XlsxioReader; sheetname: cstring; flags: cuint): XlsxioReaderSheet

xlsxio_read_sheet_struct:

• xlsxio_read_core: xlsxio_read_sheet_struct

XLSXIOREAD_SKIP_ALL_EMPTY:

• xlsxio_read_core: XLSXIOREAD_SKIP_ALL_EMPTY

XLSXIOREAD_SKIP_EMPTY_CELLS:

• xlsxio_read_core: XLSXIOREAD_SKIP_EMPTY_CELLS

XLSXIOREAD_SKIP_EMPTY_ROWS:

• xlsxio_read_core: XLSXIOREAD_SKIP_EMPTY_ROWS

XLSXIOREAD_SKIP_EXTRA_CELLS:

• xlsxio_read_core: XLSXIOREAD_SKIP_EXTRA_CELLS

XLSXIOREAD_SKIP_HIDDEN_ROWS:

• xlsxio_read_core: XLSXIOREAD_SKIP_HIDDEN_ROWS

XLSXIOREAD_SKIP_NONE:

• xlsxio_read_core: XLSXIOREAD_SKIP_NONE

xlsxio_read_struct:

• xlsxio_read_core: xlsxio_read_struct

XlsxIOSkip:

• xlsxio: XlsxIOSkip

XlsxIOVersion:

• xlsxio: XlsxIOVersion

xlsxiowrite_add_cell_datetime:

• xlsxio_write_core: xlsxiowrite_add_cell_datetime(handle: XlsxioWriter; value: int64)

xlsxiowrite_add_cell_float:

• xlsxio_write_core: xlsxiowrite_add_cell_float(handle: XlsxioWriter; value: cdouble)

xlsxiowrite_add_cell_int:

• xlsxio_write_core: xlsxiowrite_add_cell_int(handle: XlsxioWriter; value: int64)

xlsxiowrite_add_cell_string:

• xlsxio_write_core: xlsxiowrite_add_cell_string(handle: XlsxioWriter; value: cstring)

xlsxiowrite_add_column:

• xlsxio_write_core: xlsxiowrite_add_column(handle: XlsxioWriter; name: cstring; width: cint)

xlsxiowrite_close:

• xlsxio_write_core: xlsxiowrite_close(handle: XlsxioWriter): cint

xlsxiowrite_get_version:

• xlsxio_write_core: xlsxiowrite_get_version(pmajor: ptr cint; pminor: ptr cint; pmicro: ptr cint)

xlsxiowrite_get_version_string:

• xlsxio_write_core: xlsxiowrite_get_version_string(): cstring

xlsxiowrite_next_row:

• xlsxio_write_core: xlsxiowrite_next_row(handle: XlsxioWriter)

xlsxiowrite_open:

• xlsxio_write_core: xlsxiowrite_open(filename: cstring; sheetname: cstring): XlsxioWriter

XlsxioWriter:

• xlsxio_write_core: XlsxioWriter

xlsxiowrite_set_detection_rows:

• xlsxio_write_core: xlsxiowrite_set_detection_rows(handle: XlsxioWriter; rows: csize_t)

xlsxiowrite_set_row_height:

• xlsxio_write_core: xlsxiowrite_set_row_height(handle: XlsxioWriter; height: csize_t)

Xlsxio_write_struct:

• xlsxio_write_core: Xlsxio_write_struct