Error while reading excel file

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now