Can not read all data of Excel when using Dynamic Schema

[laughsmile]

Hello everyone

I am using Talend Data Integration Job to read the following Excel which has 3 rows and 88 columns:

But only part of data(2 rows and 17 columns) can be read, the first row and part of columns lost after read by using dynamic schema.

By the way, if I define 88 string column in the schema , I can read the all data.

Thanks in advance.

[Shicong_Hong]

Hi

The first row should be header, it always be treated as header if you use a Dynamic schema. There may not be enough space to display all columns with tLogRow component, you can output the data to a file to check if part of columns are missing. eg:

tFileInputExCel--main--tFileOutputDelimited.

Regards

Shicong

[laughsmile]

Hello @Shicong_Hong 

Thanks for your answer.

After changing tFileInputExCel's header from 0 to 2 , it can read all columns now.

Best regards.

[laughsmile]

Hello everyone.

I can read all columns by setting tFileInputExcel's header as 2.

But the first row is skipped after setting tFileInputExcel's header as 2.

How can I get the first row which contains one non-empty cell in the first column.

Thanks in advance.

[Shicong_Hong]

If you set the header as 2, the first row will be skipped, the second row will be treated as header columns when using Dynamic schema. To read the first row, I think you need to use another tFileInputExcel component to read it with general schema.