One Star

Error while reading excel file

Hi Team,
I am facing the below warning while reading excel file ,which eventually results into a null pointer exception

Warning:  Cannot read name ranges for OLE_LINK1 - setting to empty

Warning:  Cannot read name ranges for OLE_LINK3 - setting to empty
Warning:  Cannot read name ranges for Z_543C1318_0956_49B3_9396_209B85525876_.wvu.FilterData - setting to empty
Warning:  Cannot read name ranges for Z_A1879562_2BA7_40BF_B10F_CAC6F5301BF0_.wvu.FilterData - setting to empty
 
Exception in component tMap_1
java.lang.NullPointerException
 
 

Exception in component tFileInputExcel_1

jxl.read.biff.BiffException: Unable to recognize OLE stream
                at jxl.read.biff.CompoundFile.<init>(CompoundFile.java:116)
                at jxl.read.biff.File.<init>(File.java:127)
                at jxl.Workbook.getWorkbook(Workbook.java:268)
So as per the other subjects in the forum I removed the entries from Name Manager,once the entries are removed I get the below error :


Warning:  Cannot read name ranges for Z_543C1318_0956_49B3_9396_209B85525876_.wvu.FilterData - setting to empty

Warning:  Cannot read name ranges for Z_A1879562_2BA7_40BF_B10F_CAC6F5301BF0_.wvu.FilterData - setting to empty

So I tried to create anew excel file with the same contents and now its giving me the below error :

Exception in component tFileInputExcel_1

jxl.read.biff.BiffException: Unable to recognize OLE stream
                at jxl.read.biff.CompoundFile.<init>(CompoundFile.java:116)
                at jxl.read.biff.File.<init>(File.java:127)
                at jxl.Workbook.getWorkbook(Workbook.java:268)
Below is my job :
tfilelist --> texcelread--> tMap--> tOracleload
3 REPLIES
One Star

Re: Error while reading excel file

I have checked the box for Ignore warning.
This way all the above warnings are gone but now I receive the below error :


connected
Exception in component tMap_1
java.lang.NullPointerException
 at job_nam.tFileList_1Process(job_nam.java:11837)
 at job_nam.runJobInTOS(job_nam.java:15594)
 at job_nam.main(job_nam.java:15359)
: job_nam - tMap_1 null
disconnected
Job job_nam ended at 05:41 18/02/2016.
One Star

Re: Error while reading excel file

Hi Team,
So after some research I found that the file which I am loading has some rows which I am not able to see with naked eyes.I do not even after unhiding.
Do not know where are these records residing but then when I created a new file with the data which is correct the file loaded correctly.So until I do not see these faulty records I wont be able to conclude on how to tell Talend to read only visible rows.Any help will be appreciated though.
Moderator

Re: Error while reading excel file

Hi,
Have you tried to entralize File Excel metadata to parse your excle file to see if it works?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.