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
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.
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
Please find the screenshots below for write range:
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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.