topic Re: Error while reading excel file in Talend Studio

Error while reading excel file

Anonymous — Sat, 16 Nov 2024 10:47:44 GMT

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

Re: Error while reading excel file

Anonymous — Wed, 17 Feb 2016 19:56:49 GMT

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.

Re: Error while reading excel file

Anonymous — Thu, 18 Feb 2016 19:51:05 GMT

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.

Re: Error while reading excel file

Anonymous — Tue, 23 Feb 2016 07:58:34 GMT

Hi,
Have you tried to entralize File Excel metadata to parse your excle file to see if it works?
Best regards
Sabrina