Save multiple sheets data into multiple excel file

Hi,
i have an .xlsx file which having 3 sheets(sheet1,sheet2,sheet3) i want each sheet data to be store in a different excel file. like sheet1 data to be store in excel.xlsx, sheet2 data to be store into excel1.xlsx and sheet3 data to be store into excel3.xlsx.

I am new to RPA ,please share the .xaml file for this problem if possible.

Get Workbook Sheets, try this activity

can you share .xaml file for this

Hi @sanjib39

Scenario
1.Use Excel application scope activity
2. Use Read Range and set the sheet that you want to read
3.Create a variable type of DataTable
4.Pass the DataTable variable to the properties of readrange activities
5.Use write range and write the range to the excel.

cheers :smiley:

Happy learning :smiley:

2 Likes

Hi @sanjib39,
Use “Get Worksheets” activity- it will return a list f sheet names - sheetList.

for each item in sheetList
read range - with sheet name as item.tostring
you’ll get a datatable here.

use another excel scope, write range and pass the datatable.
here try to add the sheet name (here item.tostring) as file name in excel scope. so that you’ll get sheetname.xlsx like name for the output excel

1 Like


is that what you are saying???


Check this please @sanjib39

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