XLOpen

XLOpen>Filename,Visible,XLBookHandle

This function requires Microsoft Excel to be installed.

Opens an existing Excel workbook with the given filename.  Set Visible to 1 to make the workbook visible, or zero to hide it.  Returns a handle in XLBookHandle which should be used to reference the workbook in other XL commands.

Abbreviation: XLO

See also: XLAddSheet, XLCreate, XLDelCol, XLDelRow, XLDelSheet, XLGetCell, XLGetSheetDims, XLQuit, XLRun, XLSave, XLSetCell

Example

XLOpen>%USERDOCUMENTS_DIR%\mybook.xls,1,xlBook

XLAddSheet>xlBook,Customers

XLSetCell>xlBook,Customers,1,1,CustID