ExcelSheet (open)

Constructor

• MACRO NEW(OBJECT exceldoc, OBJECT sheetfile)

Properties

• PROPERTY xlsx

Functions

• RECORD ARRAY FUNCTION ExportRows(RECORD options)
  

  Return the rows in an excel sheet

• MACRO ExportRowsToCallback(FUNCTION PTR callback, RECORD options)
  

  Send all rows to a callback function

• VARIANT ARRAY FUNCTION GetAllRows(RECORD options)
• STRING FUNCTION GetCellName(INTEGER row, INTEGER col)
• RECORD FUNCTION GetCellPosition(STRING cellname)
• VARIANT FUNCTION GetCellValue(INTEGER rownum, INTEGER colnum)
• VARIANT FUNCTION GetCellValueByCellName(STRING cellname)
• RECORD FUNCTION GetParseProgress()
• OBJECT FUNCTION MakeColumnReader(RECORD ARRAY cols)
• MACRO SetCell(INTEGER rownum, INTEGER colnum, RECORD cellcontents)
• MACRO SetCellValue(INTEGER rownum, INTEGER colnum, VARIANT newvalue)
• MACRO SetColumn(INTEGER colidx, RECORD colprops)
• MACRO SetColumnWidth(INTEGER colidx, FLOAT width)
  

  Set a column's width