save web data to a separate Excel file

Write from datatable if web data is in table format 

Set cell action if your data is string/number format 

In the given scenario, I possess an input Excel file containing various CNIC numbers. Corresponding to these CNIC numbers, I intend to extract data from a NECTA website where the required information is presented in a web data table format. I have implemented the 'set cell' command to organize the extracted data, intending to save the ID in Column B, Name in Column C, and Father's name in Column D. However, upon successful execution of the bot, the extracted data associated with CNICs is currently being saved directly into my input Excel file. My objective is to have this output web data saved in a separate Excel sheet. To achieve this, what action or approach should I employ?

Use Swift to sheet action by mentioning the name of the sheet 

Then countinue your adding details process on that sheet

thank you for helping me out but i want to save my output in a separate workbook/Excel File, not a separate worksheet, which action should i use ?

Use file action 

File -> create action 

Then give path example:- c/user/ exfile.xlsx

You can also use create workbook action in excel package

Note:- make different session names while using two excel workbooks in excel actions

its not working. Is there any Excel Advanced Action for this purpose?

yes i used this but it was not working ‘the create Workbook’ Action

which action should i use if my output is stored in a record variable and i want to save it in a different Excel sheet

You can create a Data Table variable and use the Insert row action to add a record to the table. Once in the table, you can write the table to an Excel document.

You mentioned the “Create workbook” action was not working for you. What was the error? Do you have Excel installed (that is a requirement)?

By the way: Do not use File: Create file to create an Excel file. A “blank” Excel file actually contains 7kB of data.