topic Re: Problem to manage excel file in Talend Studio

Problem to manage excel file

lcupito — Fri, 15 Nov 2024 22:07:37 GMT

Hi,

i have a .xls with 2 sheets and 2 different schemas. How can i manage them and create two different entities?

i created 2 tfileinputexcel with 2 same routines. I'm searching for a dynamic solution because i will have to add other sheets when they will be available.

thank you

Re: Problem to manage excel file

jlolling — Thu, 09 Feb 2023 09:17:19 GMT

It is not quite clear for me what do you want?

You need a generic way to read the files and sheets? The enterprise edition contains Dynamic data type which means the components detects itself the fields.

Re: Problem to manage excel file

lcupito — Thu, 09 Feb 2023 10:40:39 GMT

i tried to do that but it doesn't work. i have a file xls with multiple sheets with different schemas. so i tried to handle them dinamically.

i thought i could handle in this way and in the end i would save in a csv file. where am i wrong?

the part below is still to be implemented: I filter the columns and rows and only get the distinct Files and Sheet names.

i receive this error:

tFileInputExcel_1 org.apache.poi.hssf.usermodel.HSSFWorkbook cannot be cast to org.apache.poi.xssf.usermodel.XSSFWorkbook