Skip to content
Reference > AmiScript API > Methods

parseXls(data,firstLineIsHeader,tableName,classes)

Definition

Table parseXls(Binary data, Boolean firstLineIsHeader, String tableName, List classes)

Description

Given a valid Xls byte array data, will parse and return the specified table.

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 look for
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")