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

No comments:

Related Posts Plugin for WordPress, Blogger...