ExcelDoc (open)

Constructor

• MACRO NEW(BLOB infile)

Functions

• MACRO Close()
  

  Release resources

• INTEGER FUNCTION CreateXLSXStyle(STRING numberformat)
• FLOAT FUNCTION ExcelFloatFromDatetime(DATETIME inval)
  

  Convert a HareScript datetime to an excel floating point value.

• DATETIME FUNCTION ExcelFloatToDateTime(FLOAT val)
  

  Convert an excel float representing a date and/or time to a HareScript datetime

• STRING FUNCTION GetFromStringTable(INTEGER idx)
• RECORD ARRAY FUNCTION GetSheets()
  

  List the sheets in the opened XLSX file

• RECORD ARRAY FUNCTION GetStyles()
• OBJECT FUNCTION OpenSheet(INTEGER seqnum)
  

  Open an individual sheet

• OBJECT FUNCTION OpenSheetByName(STRING sheetname)
  

  Open an individul sheet by name

• BLOB FUNCTION SaveExcelDoc(RECORD options)
  

  Save the excel document