How to Write to External Excel Datatable
I have written code to extract cell data from a webtable and have placed the extracted data into variables. I am wanting to place the cell contents into corresponding columns in a separate datatable, so I can then use the extracted cell data in another script. Can someone tell me the best way to do this? To get started I would:
1. Create a new excel file with the naming convention testmodule_TodaysDate_Time
2. Name worksheet#1
3. Name needed columns.
4. Save Excel File
What I don't know how to do is take the data that I have extracted and placed into a variable and then place it into the appropriate row/column of the external Excel Worksheet.
Then how do I call the data back in from a separate / different test script?
Any and all help is greatly appreciated!!!!
Re: How to Write to External Excel Datatable
Have you searched the forum to know "how to create the excel file" you will find lots of posts on that..
once you create the excel file to store the value:
objexcelworksheet.Cells(2,1).Value=<your value here>