Error while creating metadata for Excel file

One Star

Error while creating metadata for Excel file

I need to read data from an Excel file using Talend 5.2.1. It is in .xlsx format. I have to load data starting from row 16  and columns from column 2 till column 522 of first sheet in the excel file. When I am trying to create Metadata for this file, it errors out with error "Last column parameter error. Bigger than schmea columns size". I have not defined any schema yet. 
Can someone please help me to fix this error?
Seventeen Stars

Re: Error while creating metadata for Excel file

I guess there is an well known error in the Excel wizard. You do not need the wizard, you can define the schema for your self and in this case the component should work with this schema.

Cloud Free Trial

Try Talend Cloud free for 30 days.


Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

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