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
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.
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.
