Error while creating metadata for Excel file

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?
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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now