How to create new sheet in excel and store the scrapped data into it

Suppose we are take input from user like we are searching for different product from flipkart and use data scrapping every time we need to search different data and store that scrapped value into excel but in different different sheet,suppose i search for iphone so for iphone i need to store in sheet1 for another product like samsung we need to store in sheet2

Hello @Sandhya_Gajare

In Write Range for Sheet Name add the datetimevalue to make it unique each time:
Ex: SheetName =“Sheet_”+Now.ToString(“ddMMyyhhmmssff”)

This will generate new sheet for each time.

Hey @Sandhya_Gajare,

You can use write range activity pass the file name and sheet name and datatable object.
This way the sheet will be created and data would be written into the file.


can you provide me solution file

@Sandhya_Gajare ,

Please find the screenshots below for write range:

Hi @Sandhya_Gajare

You can also try with Excel application Scope activity


Note : Don’t forgot to enable the Add Headr in the properties



How to write data into newly created data data should be for different product in different sheet

Hi @Sandhya_Gajare

Check out this Workflow (355.1 KB)


1 Like

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