Is OpenOffice Supports QTP Automation?

Talk about anything at all....
Post Reply
Savulagi
Posts: 1
Joined: Fri Aug 22, 2014 9:35 am

Is OpenOffice Supports QTP Automation?

Post by Savulagi »

I am getting error while reading data from Open Office Excel sheet for QTP automation. I am getting error on my QTP editor as "ActiveX Component can't create object excel.application'.Please can anyone tell me how we can sort out this issue?..Or is Open office does not supports QTP?.if we do change some configurations in machine please help me on this...Thanks in advance
 Edit: Moderator's note: QTP =HP Unified Functional Testing (UFT) software, formerly known as HP QuickTest Professional (QTP) 
OpenOffice 3.2.1 on Windows 7
B Marcelly
Volunteer
Posts: 1160
Joined: Mon Oct 08, 2007 1:26 am
Location: France, Paris area

Re: Is Open Office Supports QTP Automation?

Post by B Marcelly »

Hi,
Savulagi wrote:ActiveX Component can't create object excel.application
That's right. You are using OpenOffice, not Excel. Even if it opens a spreadsheet stored as .xls it does not use Excel components.
OpenOffice can be used through COM Automation, but the programming is different than with Excel.
Bernard

OpenOffice.org 1.1.5 / Apache OpenOffice 4.1.1 / LibreOffice 5.0.5
MS-Windows 7 Home SP1
Post Reply