Automating Reports in .XLS form by validating the data in it using QTP

mail2luck12 · #1 (**permalink**) 08-26-2008

Hi,

we are in a process of identifying a way to automate our application.it would be very feasible for us to automate reports which are in Excel format.

To give more context, we had a reporting module in our application which is prone to more changes.

we had an UI to generate reports, but the reports which are been generated would be in Excel(*.XLS) form.we should validate the data present in a report against the business rules whether it is correct or not.

Can we automate such kind of reports using QTP.If Yes, please provide us the approach which we would need to follow.

If not, Please suggest us an automation tool which would suffice to our requirements.

Thanks..

mgkganesh · #2 (**permalink**) 08-27-2008

You will be able to access excel data as below....

Set ExcelObj = CreateObject("Excel.Application")
ExcelObj.DisplayAlerts = False
ExcelObj.Visible = True
ExcelObj.Workbooks.Open destXLName
Set Excel_Wb = ExcelObj.Activeworkbook
Set destSheet = Excel_Wb.Sheets(1)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Exforsys.com SOA Web Services - Validating Interoperable WSDL	admin	Web Design	0	07-28-2008 04:00 PM
How to get the data of some fields from previous form to current form?	naname	QTP	4	04-29-2008 05:26 PM
How to use QTP for automating variable data	sangeetasingh268	QTP	2	03-26-2008 02:46 AM
Universes and reports using multiple Data Sources	sreya_1234	Data Warehousing	0	01-31-2008 06:01 AM
Binary form Forms and Reports in Unix	bhatia.harleen	Oracle	0	11-22-2007 03:18 AM

Automating Reports in .XLS form by validating the data in it using QTP

Automating Reports in .XLS form by validating the data in it using QTP

Similar Threads