jacksboy的专栏

Create an Excel object using VBScript The function below will allow to you to extract data from an external Excel file (specifying the sheet) without importing the file to the QuickTest data tabl

This solution applies to external Excel files, not to the QuickTest Professional data table. You can use the Excel object model to automate setting the font and cell color in an Excel worksheet.

Example: The user would like to specify that the cell/column contents are general, a percentage, or currency. For information on setting the text formatting (for example color, bold, italic), refe

Example: ' create the Excel object Set ExcelObj = CreateObject("Excel.Application") ExcelObj.Visible = true ' add a new Workbooks and a new Sheet ExcelObj.Workbooks.Add Set NewSheet = ExcelO

Use the Excel Object Model Run command to execute the macro

Writing data to an Excel file without importing the data to the data table This function will allow you to set data in an external Excel file (specifying the sheet and the cell), without importing th

This solution applies to external Excel files, not to the QuickTest Professional data table. You can use the Excel object model to automate hiding or displaying rows and columns in an Excel workshe

Formatting Excel output from QuickTest Professional You can use the Excel object model to automate formatting the values in a cell in an Excel worksheet. Example: filename = "C:\temp\Book1.xls"