Registered StackHub users may elect to receive email notifications whenever a new package version is released or a comment is posted on the forum.
There are 0 watchers.
List all the sheet names found in the Excel document represented by the provided POIReader instance.
Examples:
poiReaderOpen("myFile.xlsx").poiListSheets
Side effects:
Read the content of a specific sheet, identified by index, returned as a Str which can be further parsed by the calling Axon function.
Examples:
poiReaderOpen("myFile.xlsx").poiReadSheetByIndexAsStr(0)
Side effects:
Read the content of a specific sheet, identified by name, returned as a Str which can be further parsed by the calling Axon function.
Examples:
poiReaderOpen("myFile.xlsx").poiReadSheetByNameAsStr("Sheet1")
Side effects:
Close the provided POIReader instance.
Examples:
poiReaderOpen("myFile.xlsx").poiReaderClose
Side effects:
Construct a POIReader for the provided file name
Examples:
poiReaderOpen("myFile.xlsx") poiReaderOpen("myFile.xlsx", ",")
Side effects:
Construct a POIReader for the provided binary byte buffer. The Buf instance should be the binary contents of any of the support Excel file versions.
Examples:
poiReaderOpen(smbReaderOpen("10.0.0.1").smbReaderConnect("shareName").smbReaderReadBinaryFile("dirName", "myFile.xlsx"))
Side effects: