topic Re: Excel with print area is not processed by tFileInputExcel in Talend Studio

Excel with print area is not processed by tFileInputExcel

WWi1675154076 — Tue, 31 Jan 2023 08:48:22 GMT

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 |

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

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

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

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

Re: Excel with print area is not processed by tFileInputExcel

Anonymous — Tue, 31 Jan 2023 09:58:25 GMT

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

Re: Excel with print area is not processed by tFileInputExcel

WWi1675154076 — Tue, 31 Jan 2023 11:55:31 GMT

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.

Re: Excel with print area is not processed by tFileInputExcel

Anonymous — Tue, 31 Jan 2023 13:54:12 GMT

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.

Re: Excel with print area is not processed by tFileInputExcel

WWi1675154076 — Tue, 31 Jan 2023 14:47:10 GMT

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