One Star

Error while creating metadata for Excel file

Hi,
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?
1 REPLY
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.