getting error while reading data from xls file

The excel file might be corrupted.

I thought same so tried to use new excel but still error persist.

update the poi api.

Hi,

I also faced the same issue and tried from below details and it works fine

http://stackoverflow.com/questions/26009662/org-apache-poi-openxml4j-exceptions-invalidoperationexception-cant-open-the-sp


Note:

1) For .xls we need to use HSSF instead XSSF


Regards
Ruma

Hi Ruma ,
I have double checked it has HSSF in code everywhere .

Hi Ashish
POI API is updated but still issue is there .

Please advise

thanks,
Dhananjay

send me the file and code you're using.

Hi
PFA Xls reader file.

Please note
1.I have replace XSSF with HSSF but then getting error on below line.
HSSFCreationHelper createHelper = workbook.getCreationHelper();

2.i have removed first line from code as mentioned

Here is code

public static void main(String[] args) {
Xls_Reader datatable=new Xls_Reader("C:\\Module20\\read.xls");
int r = datatable.getRowCount("Record");
System.out.println(r);

xls_reader.java can only work with xlsx files.

try this file it might work.

Thank you ..it works