Excel with print area is not processed by tFileInputExcel

[WWi1675154076]

Hi all

A client processes Execel files with a job I developed in Talend Studio 8.0.1. Every now and then he gets the following error while processing his files:

.-------------------+-----------------------------+------+------+------------------------------------.

|                                            tLogRow_1                                             |

|=------------------+-----------------------------+------+------+-----------------------------------=|

|moment            |job                         |origin|status|description                        |

|=------------------+-----------------------------+------+------+-------|----------------------------=|

|2023-01-30 17:26:25|his_filename |null |Failed|Index |10 out of bounds for length 10|

'-------------------+-----------------------------+------+------+------------------------------------'

The solution is quite simple: Open the respective file in Excel, go to Page Layout tab and click Clear Print area.

Is there a way to tell talend to ignore print areas or any other thing we can do to make this processing more stable?

Thank you

[Anonymous]

Hi

Which file format? .xlsx or .xls? I have tried to set print area to some cells and read the .xlsx file, I can't reproduce the issue. Would you mind providing a simple example file for us to test？

Regards

Shong

[WWi1675154076]

Hi Shong

Thanks for your quick reply. It's .xls. I tryed to copy the excel for you because the original contains sensitive customer data. Unfortunately, I can't reproduce the issue this way anymore. Also, I found that there is an error in Excel when I try to display page breaks.

It seems the issue is related to the original excel only. Maybe also to the tool the data is exported from (a database reporting software).

I assume there is not much we can do on the Talend side, right?

Thank you anyway and best regards.

[Anonymous · Accepted solution]

I check the component settings and I think there is no an option that can ignore this error and continue to read the file, what Talend can do is to skip this problematic file and continue to process next file if there are multiple files.

[WWi1675154076]

Thank you Shong. I think that's what we can do on the Talend side.