I would like to directly import XL file and work on that XL file directly in Q

I would like to directly import XL file and work on that XL
file directly in QTp script in that XL sheet need to
allocate workbench,XL sheet and generate two bar graphs
automatically how to do that? plz let me know any answers?

Question Posted / guest

1 Answers
2150 Views
Wipro, I also Faced
E-Mail Answers

I would like to directly import XL file and work on that XL file directly in QTp script in that XL..

Answer / Ajay Kumar Kushwaha

To achieve this, you can use the QuickTest Professional (QTP) Excel Object Model to interact with your Excel file directly within your script. Here's a simplified step-by-step guide:
1. Load the Excel file using the `Excel.Application` and `Excel.Workbook` objects.
2. Create a new Worksheet object from the workbook.
3. Allocate the worksheet to the QTP workbench by setting the `TestObject` property of your Desktop or Window object to the worksheet object.
4. To generate bar graphs, you can use the `Chart` and `SeriesCollection` objects in Excel. First, add a chart to the active sheet using the appropriate chart type (e.g., `barChart`), then create a new Series object for each set of data you want to plot.
5. Finally, set the `Name`, `XValues`, and `Values` properties of your series objects accordingly.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer