How to create new excel row by row and add the whole row into new sheet

image

How to do this? i want to create the excel sheet and add those rows into that created excel sheet row by row.

Hi @NervousTuber

You Can Either try with Filter Datatable activity or Select method and write range!

Refer to the xaml below!

Main.xaml (9.2 KB)

Regards

1 Like

Hi @NervousTuber ,

Try below steps. thanks.

  1. Use work book read range and store the input excel data into Datatable InputDT.

  2. Use For each row and assign your InputDT and inside for each row loop.
    Use dtout = inputDT.clone so that you will get headers in the outDT.

  3. Use add data row activity in the Array row → {row(0).tostring,row(1).tostring, row(2).tostring} and datatable should be our out DT.

  4. use workbook write range activity assing outputexcel file path like “outputExcel”+InputDT.Rows.IndexOf(row).ToString+".xlsx" and assign your out DT to write the first row. so it will split input excel into multiple excel files. thanks.

Refer the attached updated work flow.

SplitExcelData2MuipleUpdated.xaml (7.0 KB)

1 Like

Thanks @pravin_calvin and @kirankumar.mahanthi1 for this solution

2 Likes

your welcome @NervousTuber

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.