issue creating metadata of xlsx file.

Highlighted
Seven Stars

issue creating metadata of xlsx file.

Hi,

 

I am facing issue while creating metadata of xlsx file.

ERROR : - Type mismatch: cannot convert from element type Sheet to XSSFSheet

 

same error is populated even if I dont use excel  metadata and define schema manually in tFileInputExcel -row--> tLogRow

 

My Version :

"Jaspersoft ETL"

Version: 5.6.2
Build id: V5.6.2_20150508_1414


Thanks,

Sachin

 

 

 


Accepted Solutions
Moderator

Re: issue creating metadata of xlsx file.

Hi,

Could you please try to use the latest released version V 6.4 to see if this issue has been fixed?

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.

All Replies
Moderator

Re: issue creating metadata of xlsx file.

Hello,

What does your xlsx file look like? Could you please show us some content for a testing? Does this issue repro when you use other excel files?

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

Re: issue creating metadata of xlsx file.

Yes, issue is with any xlsx file,

even i am trying with very simple xlsx file wth 2 columns. 

 

interestingly when i use xls file , and unccheck check box  in tFileInputExcel (Read excel2007 file format(xlsx)), i dont get any error.

i.e. issue is just with xlsx format.

 

I tired using another machine which as same Talend version, and faced exactly same issue. (do this version has some bug for tFileInputExcel) xlsx format

 

"Jaspersoft ETL"

Version: 5.6.2
Build id: V5.6.2_20150508_1414

 

 

 

Moderator

Re: issue creating metadata of xlsx file.

Hi,

Could you please try to use the latest released version V 6.4 to see if this issue has been fixed?

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

Re: issue creating metadata of xlsx file.

Thanks Sabrina,

 

I was facing this issue on Version: 5.6.2 Enterprise edition.

But same works perfectly fine on V6.3 Enterprise edition.

 

Sorry for late reply.

 

Thanks,

Sachin.

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