File System Object (FSO) - Working with Excel Files

By
'Create an excel file, add data to it, and save it at specified location
Dim Objexcel
Set Objexcel = CreateObject("Excel.Application")
Objexcel.Visible  = True
Set Objworkbook = Objexcel.Workbooks.Add
Set Obssheet = Objworkbook.Worksheets (1)
Obssheet.cells(1,1).value = "This is some text"
Objworkbook.Saveas "C:\Amol"
Objworkbook.Close
Objexcel.Quit
Set Objexcel = Nothing
Set Objworkbook = Nothing
Set Obssheet = Nothing

'Read and wite data from and in excel file
Dim Objexcel
Set Objexcel = CreateObject("Excel.Application")
Objexcel.Visible  = True
Set Objworkbook = Objexcel.Workbooks.Open("D:\gcr1.xlsx")
Set Obssheet = Objworkbook.Worksheets (1)
Var = Obssheet.cells(1,1).value
Msgbox Var
Obssheet.cells(1,2).value = "Amol"
Objworkbook.Save
Objworkbook.Close
Objexcel.Quit
Set Objexcel = Nothing
Set Objworkbook = Nothing
Set Obssheet = Nothing

'Create an excel sheet and enter a value into first cell
Dim objexcel
Set objExcel = createobject("Excel.application")
objexcel.Visible = True
objexcel.Workbooks.add
objexcel.Cells(1, 1).Value = "Testing"
objexcel.ActiveWorkbook.SaveAs("D:\gcreddy1.xls")
objexcel.Quit

'Compare two excel files
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set objWorkbook1= objExcel.Workbooks.Open("D:\gcr1.xlsx")
Set objWorkbook2= objExcel.Workbooks.Open("D:\gcr2.xlsx")

Set objWorksheet1= objWorkbook1.Worksheets(1)
Set objWorksheet2= objWorkbook2.Worksheets(1)

   For Each cell In objWorksheet1.UsedRange
       If cell.Value <> objWorksheet2.Range(cell.Address).Value Then
           msgbox cell.Address &" Value is different"
       Else
           msgbox cell.Address &" Value is same"
       End If
   Next

objWorkbook1.close
objWorkbook2.close
objExcel.quit
set objExcel=nothing

'Excel Paramaterization - Use excel sheet as input parameters in your script
Dim Objexcel
Set Objexcel = CreateObject("Excel.Application")
Objexcel.Visible  = True
Set Objworkbook = Objexcel.Workbooks.Open("C:\Test.xlsx")
Set Obssheet = Objworkbook.Worksheets (1)
Row_Count = Obssheet.UsedRange.Rows.Count
Msgbox Row_Count
For i =2 to Row_Count
VendorID = Obssheet.cells(i,1).value
Browser("name:=Expert Database - Search Experts").page("title:=Expert Database - Search Experts").WebEdit("html id:=ctl00_CB_tbVendorID","html tag:=INPUT").Set VendorID
Next
Objworkbook.Close
Objexcel.Quit
Set Objexcel = Nothing
Set Objworkbook = Nothing
Set Obssheet = Nothing

Comments

Post a Comment

Popular Posts

Demystifying Automation Frameworks: A Comprehensive Guide to Building Scalable Solutions

By
Image
In today's fast-paced software development landscape, automation is no longer a luxury but a necessity. To truly harness its power, organizations need more than just automated scripts; they need robust automation frameworks . But what exactly is an automation framework, and how do you go about building one that stands the test of time? This guide will demystify the process, offering insights from foundational concepts to advanced techniques. What is an Automation Framework? At its core, an automation framework is a structured combination of tools, processes, and best practices that helps automate testing efforts efficiently . It acts as the foundational structure upon which you build scalable and maintainable test automation solutions . Think of it as a blueprint and a set of standardized building blocks that ensure consistency, reusability, and ease of management for your automated tests. Without a framework, test automation can quickly become a collection of disparate scripts th...
Read more

Mastering Java Collections: Your Secret Weapon for Robust Automation Frameworks

By
Image
In the world of software automation, managing data efficiently is paramount. Whether you are wrangling WebElements in Selenium or crafting complex JSON payloads for API tests, Java Collections Framework (JCF) provides the essential tools to organize, store, and manipulate data effectively. Understanding and leveraging collections can significantly enhance the power, flexibility, and maintainability of your automation frameworks. What are Java Collections? The Java Collections Framework is a set of interfaces and classes that enable developers to store and manipulate groups of objects. It offers a unified architecture for representing and manipulating collections, promoting reusability and efficiency. The core interfaces in the Java Collections Framework are: List : An ordered collection (also known as a sequence) that allows duplicate elements. Set : A collection that does not allow duplicate elements and is generally unordered, unless specific implementat...
Read more

The Singleton Pattern in Test Automation: Ensuring Consistency and Efficient Resource Management

By
Image
In the realm of test automation, ensuring consistency and managing resources efficiently are paramount for building reliable and maintainable frameworks. One design pattern that often proves invaluable in achieving these goals is the Singleton pattern . This pattern ensures that a class has only one instance and provides a global point of access to it. But how does this apply to test automation? Below examples highlight several key areas where the Singleton pattern can be a powerful tool: 1. Managing WebDriver Instances (Selenium) In Selenium-based test automation, the WebDriver instance is crucial for interacting with the browser. Creating multiple WebDriver instances can lead to resource wastage, conflicts, and inconsistencies. The Singleton pattern offers an elegant solution by ensuring that only one WebDriver instance exists throughout the test execution. Consider the following C# implementation. public class WebDriverManager {     private static WebDriver instanc...
Read more

Design Patterns in Test Automation Framework

By
Image
Developing scalable and maintainable test automation frameworks can be challenging. As test suites grow, poorly structured code becomes difficult to manage, update, and debug. This is where design patterns come into play. Design patterns provide standard solutions to common software design problems. By applying these proven patterns in test automation, you can create frameworks that are more scalable, maintainable, and reusable . They offer a blueprint for structuring your code effectively, improving collaboration among team members, and reducing technical debt. In one of the previous blogs, we discussed the  Singleton Pattern  in detail. In this blog, we will explore other important design patterns used in test automation. 1. Creational Design Patterns These patterns focus on object creation . They provide ways to create objects in a manner suitable for the situation, hiding the complexity of object creation. Singleton Pattern Purpose: Ensures that a cla...
Read more

Object-Oriented Programming Concepts (OOP)

By
Image
Object-Oriented Programming (OOP) is a fundamental paradigm in software development, offering powerful ways to structure code, manage complexity, and build scalable applications. Understanding its core principles is crucial for any aspiring or experienced developer. This post will explore the key concepts of OOP, focusing on the "Four Pillars" and related principles. The Four Pillars of OOP: APIE The essence of OOP can be summarized by four main pillars, often remembered by the acronym APIE : Abstraction, Polymorphism, Inheritance, and Encapsulation. Abstraction: At its heart, abstraction is about showing only the necessary details while hiding the complex underlying implementation. It focuses on what an object does, presenting an essential interface to the outside world. Think of driving a car: you interact with the steering wheel, accelerator, and brakes – the abstract interface – without needing to understand the intricate mechanics of ...
Read more