Friday, March 1, 2013

QTP: Create New Excel File

Create New Excel File


Program to create a new Excel workBook

set xl=createobject("excel.application")
set wb=xl.workbooks.Add
Set ws=wb.worksheets(1)
ws.Name="New Name"
ws.cells(1,1).value="Completed creation of new excel file"
wb.saveas ("C:\1.xlsx")
wb.close
xl.quit

No comments:

Post a Comment