Six 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

 

 

 

Tags (1)
1 ACCEPTED SOLUTION

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