Hi,
We are using Python as project scripting language.
Have copied content from application using Sys.Keys('^c') and Sys.Keys('^a')
Now, requirement is to create a new excel sheet and copy this content in first row and first column.
Please suggest.
Regards
Dhirendra.
Hi dhirendranaga,
There are several ways to do this.
Two examples would be to create an ADO connection to the excel sheet and insert a record, or use TestComplete to paste the data into the first column. To access the clipboard contents use Sys.Clipboard.
Hi,
Can you please provide some sample code as how to paste code from Sys.ClipBoard to excel first sheet first cell.
Would be of great help please.
Dhirendra.
Hey dhirendranaga!
This should work:
function InsertTextExcel()
{
var excel = Sys.OleObject("Excel.Application"); excel.DisplayAlerts = false; //No messages
var book = app.Workbooks.Open("C:\\TC\\ArquivoEXCEL"); //Path to your excel file
var sheet = book.Sheets("Plan1"); //Name of the sheet
sheet.Cells(1, 1) = Sys.Clipboard;
book.Save();
app.Quit();
}