parseXlsx(data,firstLineIsHeader,tableName,classes)¶
Definition¶
Table parseXlsx(Binary data, Boolean firstLineIsHeader, String tableName, List classes)
Description¶
Given a valid Xlsx byte array data, will parse and return the specified table with the given types.
Parameter Definition¶
| Name | Type | Description |
|---|---|---|
| data | Binary | Excel byte array to parse |
| firstLineIsHeader | Boolean | Should the first row be considered the column titles, otherwise columns are automatically labeled: col1,col2,col3,... |
| tableName | String | Table/Sheet name to return |
| classes | List | List of expected column class types, use null to skip, speeds up parsing by removing type deduction (Supported: "String","Boolean","Integer","Long","Float","Double") |