Excel Automation Object Model
文章平均质量分 69
jacksboy
这个作者很懒,什么都没留下…
展开
-
Add cells, rows, or columns to an Excel document
Example:' create the Excel objectSet ExcelObj = CreateObject("Excel.Application")ExcelObj.Visible = true' add a new Workbooks and a new SheetExcelObj.Workbooks.AddSet NewSheet = ExcelO原创 2014-04-07 18:44:28 · 738 阅读 · 0 评论 -
Set the number format of cells in an Excel file
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原创 2014-04-07 19:10:35 · 961 阅读 · 0 评论 -
Add formatting to the cell in an Excel document
Formatting Excel output from QuickTest ProfessionalYou can use the Excel object model to automate formatting the values in a cell in an Excel worksheet.Example:filename = "C:\temp\Book1.xls"原创 2014-04-07 19:16:52 · 425 阅读 · 0 评论 -
Run an Excel macro from QuickTest Professional
Use the Excel Object Model Run command to execute the macro原创 2014-04-07 18:56:47 · 537 阅读 · 0 评论 -
Change the font and cell color in an Excel document
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.原创 2014-04-07 19:15:18 · 507 阅读 · 0 评论 -
Write data to an Excel file without importing the data to the data table
Writing data to an Excel file without importing the data to the data tableThis function will allow you to set data in an external Excel file (specifying the sheet and the cell), without importing th原创 2014-04-07 19:06:39 · 491 阅读 · 0 评论 -
Hide/display columns or rows in an Excel document
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原创 2014-04-07 19:12:43 · 760 阅读 · 0 评论 -
Get data from an Excel file without importing the data to the data table
Create an Excel object using VBScriptThe 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原创 2014-04-07 18:53:22 · 505 阅读 · 0 评论