you never doubt youself,I belive!
QTP中创建外部的Excel (VBScript)
上一篇 /
下一篇 2009-10-13 18:58:43
/ 个人分类:QTP
QTP中创建外部的Excel,并对其操作(蓝色部分为自定义部分)
Set ExcelObj = CreateObject("Excel.Application")
ExcelObj.Workbooks.Add
Set NewSheet = ExcelObj.Sheets.Item(1)
NewSheet.Name = "Nameofthesheet"
NewSheet.Cells(row,col) =variable or string
ExcelObj.ActiveWorkbook.SaveAs "filenamewithpath"
ExcelObj.Quit
收藏
举报
TAG: