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

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads