how to split multiple sheets in a excel file into different excel files using talend.

[Anonymous]

I have a task to split multiple sheets of excel in a single file  and transform each sheet into each excel file  and do schema checks on each excel file.

[Anonymous]

Need to name the spitted  files by sheet names.

[fdenis]

fisrts solution one job by sheet to copy with dynamics data type.
second solution is to reverse previous jod (copy java code) and add and modify it into tJavaflex
last one is to call x time first job with sheet name as context.
good luck

[Anonymous]

Hi SantoshReddy,

Please find the job design.

In tJavaRow : Code is :

output_row.distinctSheet = ((String)globalMap.get("tFileInputExcel_1_CURRENT_SHEET"));

in tFileInputExcel_2, in Sheet Name, use as : ((String)globalMap.get("row5.distinctSheet")), similarly in tFileOutputExcel_2 in File Name and Sheet name use the same.

in tFileInputExcel_1 check the box "All Sheets" to read.

Thanks and regards,

Subhadip

[Anonymous]

Also from the the input Excel component you can read data dynamically.