Created attachment 29216 [details] excel file I am going through very strange issue. To generate issue please follow below steps: 1) create a cell with hyper link in excel. file format is .xls 2) copy that cell by dragging it vertically for few cells. Now all cells will be having same URL value. 3) When importing this excel in java using POI api, URL doesn't get preserved. This can be clearly seen by calling cell.getHyperlink() which returns null. please note that cell is object of HSSFCell. excel file Thanks in advance. Regards Parag Patel
Can you upload a unit test that demonstrates what's wrong?
Created attachment 29217 [details] sample java file this is sample file which i use to read data from excel
(In reply to comment #1) > Can you upload a unit test that demonstrates what's wrong? sir, i have one java file which read data from excel . which i have already attached with this bug and also attached a excel file with this bug
i think your code to read the excel file is invalid. not every cell in the file has a hyperlink, so getHyperlink() return null. when ignoring those nulls, you get 7 Hyperlink-adresses , which is expected
(In reply to comment #4) > i think your code to read the excel file is invalid. > not every cell in the file has a hyperlink, so getHyperlink() return null. > when ignoring those nulls, you get 7 Hyperlink-adresses , which is expected hi bodo , will you pls tell me where can i put wrong code because i cant under stand how to solve this issue .. still i am geting this issue .
Parag, Fursly, please do not abuse the POI issue tracker. You will get nothing by setting prioriry of a bug to blocker. POi is a volunteer project, if a problem is important for you then do work on it and contribute! Secondly, re-read what Bodo wrote: the sheet contains one hyperlinks that spans across multiple cells. the Hyperlink object has methods getFirstRow() and getLastRow() , in your case they return different values, i.e. getFirstRow() ! getLastRow() which means that the hyperlink spans across several cells. Yegor (In reply to comment #5) > (In reply to comment #4) > > i think your code to read the excel file is invalid. > > not every cell in the file has a hyperlink, so getHyperlink() return null. > > when ignoring those nulls, you get 7 Hyperlink-adresses , which is expected > > > hi bodo , > > will you pls tell me where can i put wrong code because i cant under stand > how to solve this issue .. still i am geting this issue .