Problem to manage excel file

[lcupito]

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

[jlolling]

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.

[lcupito]

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