readExcel - Grimport function

readExcel ( string path , boolean isXLSXformat , int row , int column , int _sheet ) : object

Read a file on your disk.

Sometimes you need the isXLSXformat=true with xls !

Debug

If you have this error :
org.apache.poi.hssf.usermodel.HSSFWorkbook cannot be cast to org.apache.poi.xssf.usermodel.XSSFWorkbook
Set another value to isXLSXformat

Example

cellValue = readExcel(path("desktop")+"file.xls", false, 2, 3);

Parameters

path

Path for Excel file.

isXLSXformat

XLSX or XLS? (if wrong generate an error HSSFWorkbook/XSSFWorkbook Exception)

row

Row in sheet. Row 1 = index 0

column

Column in sheet. Column A = index 0

_sheet (optional)

default:0 (first sheet)