Hi , I am having workbook which has sheet1, sheet2 and sheet3 viz. If i add a range01 inside sheet3 and shifts the sheet3 before sheet2 and try to read the data from range01 it doesnt work correctly. I am using AbortableHSSFListener to read the data from the range. Please find the attached code for reference. Urgent help will be highly helpful for us as its blocking issue for us.
Please attach the workbook and sample code to reproduce the problem. Yegor
Created attachment 25351 [details] The attached file contains the code snippet and input excel file We are trying to read the header row from the range "Range_01" which is part of "sheet2" . The expected output is header row of Range_01 while actual output is the same row from different sheet (i.e. sheet1). On debugging what we have obesrved is the sheetIndex associated with Range_01 is coming invalid. Please let us know how we can resolve this. Thanks, Amit
Use high-level usermodel API and you will be good. By using a low-level HSSFListener you are taking the burden of processing BIFF records, it requires a good knowledge of the Excel BIFF8 format and in cases like your it is not trivial. Spreadsheet usermodel API already does it for you, just try. Yegor