Module Excel

Saves the workbook of the given sheet handle and releases the handle. Values written through the handle are only on disk after this.

The Excel connection of this process, creating it on the first call. Creating it extracts and loads the native library, and fails if that does not succeed.

getExcelDouble excel handle row column reads one cell of an open sheet as a number. Rows and columns are counted from zero, so 0 0 is cell A1.

An empty cell, a cell that does not hold a number, and a handle that is not an open sheet all read as 0.0, so this cannot tell a real zero from a missing value. NaN comes back only if the call itself failed.

getExcelString excel handle row column reads one cell of an open sheet as a string. Rows and columns are counted from zero, so 0 0 is cell A1. Returns a Java null if the handle is not an open sheet.

openExcelSheet excel fileName sheetName opens the named worksheet of the workbook file and returns a handle to it. The workbook is created if the file does not exist, and the worksheet is added if the workbook does not have it.

Returns -1 if the sheet could not be opened; the underlying error is printed rather than raised.

setExcelDouble excel handle row column value writes a number into one cell of an open sheet. Rows and columns are counted from zero, so 0 0 is cell A1.

Returns 0 on success and a negative number if the handle is not an open sheet.

setExcelString excel handle row column value writes a string into one cell of an open sheet. Rows and columns are counted from zero, so 0 0 is cell A1.

Returns 0 on success and a negative number if the handle is not an open sheet.