issue creating metadata of xlsx file.

[SachinD]

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

[Anonymous]

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

[SachinD]

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

[Anonymous · Accepted solution]

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

[SachinD]

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.