topic Re: how to split multiple sheets in a excel file into different excel files using talend. in Talend Studio

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

Anonymous — Tue, 04 Jun 2019 23:46:03 GMT

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.

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

Anonymous — Wed, 05 Jun 2019 02:58:44 GMT

Need to name the spitted files by sheet names.

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

fdenis — Wed, 05 Jun 2019 10:49:37 GMT

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

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

Anonymous — Thu, 06 Jun 2019 19:37:18 GMT

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

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

Anonymous — Thu, 06 Jun 2019 19:42:39 GMT

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