QTP Script to Add Formatted Data to a Spreadsheet-QTP Script to change first cells font size,font name of an excel sheet

QTP Script to change first cells font size,font name of an excel sheet or QTP Script to Add Formatted Data to a Spreadsheet



dim a,b,c

set a=createobject("Excel.Application")

a.visible=true

set b=a.workbooks.open("C:\QTP.xls")

set c=b.worksheets(1)

c.Cells(1,1).Value="QTP"

c.Cells(1,1).Font.Size=16

C.Cells(1,1).Font.Name="Times New Roman"

b.save