VBScript Tutorial 8 (Excel Object Model in VBScript) Excel Application operations using Excel Application Object Excel Application Object: It is used to perform operations on Excel Application. Create Excel Application Object: Set Variable = CreateObject(“Excel.Application”) ———————- Excel Application Excel Workbook / File Excel Worksheet / Sheet Excel File Operations using VBScript Examples: 1) Create an … Read more
UFT Class 31 (VBScript Excel Application Operations Part-2) Excel Application Object (Main Object) Set Variable = CreateObject(“Excel.Application”) ———————————— Excel Workbook Object (Sub Object) Set Variable = ExcelApplicationObject.Workbooks.Add/Open(“File path”) ——————————————– Excel Work sheet object (Sub-sub Object) Set Variable = ExcelWorkBookObject.Worksheets(Sheet id) ——————————————————– Examples: ‘Read data from an excel file and perform data driven testing for login … Read more