save web data to a separate Excel file

to write the table to an excel document which command should i use?

This is my bot, and it is currently functioning properly. However, it is saving the web output data in the input file. I want it to save this web output data in a separate Excel file. What action should I use for this, and where should I implement it?

You would add an Excel advanced: Create workbook with a different session name from your input file.  You can add it right after your Excel advanced: Open.

After the loop, add an Excel advanced: Write from data table. Be sure and use the new session name. This will write the entire table to the new Excel file.

Remember to save and close the files.

Thank you so much for helping me out. 

The output variables I assigned are of string type, but the Excel Advanced Write from DataTable action requires a Table variable. What could be a possible solution for this?

If you have string values, then use the “Set cell” actions. Don’t use Write to Table unless you already have your data in a table.

Take a look at this best practices guide. Even though it seems wordy, the Set cell and Go to cell actions used in conjunction are easy to use, easy to manipulate, and easy to debug.

@Aaron.Gleason thank you so much for the help 

My bot is writing data to both the input and output Excel files. Although I have used the read-only argument in the Excel advanced open command, data is still being written to the input file. I only want data to be written to the output Excel file.

Make sure you’re using the correct session name. Your input and output files, when you open or create them, have a name associated with them. If you’re using the wrong session name (e.g., the input session name when writing to the file), the output will go to the wrong file.