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
See also
clearExcelCacheParameters
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)