Method | Since |
---|
Code Block |
---|
office->getNoOfSheets(wb as workbook) as int |
| 1.0 |
Code Block |
---|
office->getNoOfRows(wb as workbook, sheetNo as int) as int |
| |
Code Block |
---|
office->getCellDecimal(wb as workbook, sheetNo as int, rowNo as int, cellNo as int) as decimal |
| |
Code Block |
---|
office->getCellDate(wb as workbook, sheetNo as int, rowNo as int, cellNo as int) as datetime |
| |
Code Block |
---|
office->getCellString(wb as workbook, sheetNo as int, rowNo as int, cellNo as int) as string |
| |
Code Block |
---|
office->getCellBoolean(wb as workbook, sheetNo as int, rowNo as int, cellNo as int) as boolean |
| 1.4 |
Code Block |
---|
office->getCellFormula(wb as workbook, sheetNo as int, rowNo as int, cellNo as int) as string |
| 1.4 |
Code Block |
---|
office->getCellType(wb as workbook, sheetNo as int, rowNo as int, cellNo as int) as int |
| 1.4 |
Code Block |
---|
office->evaluateCell(wb as workbook, sheetNo as int, rowNo as int, cellNo as int) as string |
| 1.4 |
Code Block |
---|
office->setCellDecimal(wb as workbook, sheetNo as int, rowNo as int, cellNo as int, value as decimal) |
| |
Code Block |
---|
office->setCellDate(wb as workbook, sheetNo as int, rowNo as int, cellNo as int, value as datetime) |
| |
Code Block |
---|
office->setCellString(wb as workbook, sheetNo as int, rowNo as int, cellNo as int, value as string) |
| |
Code Block |
---|
office->setCellFormula(wb as workbook, sheetNo as int, long rowNo, long colNo, value as string) |
| |
Code Block |
---|
office->toColumnName(colNo as int) as string |
| |
Code Block |
---|
office->toCellName(rowNo as int, colNo as int) as string |
| |
Code Block |
---|
office->save(wb as workbook, fileName as string) as int |
| |
Code Block |
---|
office->update(wb as workbook, fileName as string, key as int) as int |
| |
Code Block |
---|
office->open(key as int) as int |
| 1.4 |