How to load test parameters from Excel?

Jon C.
Tewksbury, MA

Jun 2, 2014
6 Posts

0 ✔  |  ✗ 0  

Re: How to load test parameters from Excel?

I would like to be able to load test parameters from an Excel file at initilization.
Knowledge base article #Q200233 provides an example, but requires Excel.drv which is not part of the zip file.
I was unable to locate the driver on my system.
I do have Excel 2007 installed.
Any help would be appreciated.
Thank you.

Martin S.
EVREUX,

Jun 2, 2014
6 Posts

0 ✔  |  ✗ 0  

Re: How to load test parameters from Excel?

Excel.drv is provided in the examples folder.

Jon C.
Tewksbury, MA

Jun 26, 2014
6 Posts

0 ✔  |  ✗ 0  

Re: How to load test parameters from Excel?

Thanks.  I added Excel.drv and was still not able to get the #Q200233 example to work.  I had Excel 2007 installed, but the ActiveX Object library was not included in the install and was not available.  I was able to upgrade to Excel 2013 which included Microsoft Excel 15.0 Object Library.  Still no luck. I get "Compiler error #650: Type 'Excel.Application' is undefined, found in 'EXCEL.Initialize' in line 1".  

I then tried both the early and late binding examples on pages 161-166 of "Getting Started with ATEasy".
The early binding example had a run-time error (see attached):
Run-time error #430: 'Unable to call the method or property. Object does not support the IDispatch interface.' found in 'Using_Early_Binding' in line 17

The late binding example worked.


File Attachment:
 EarlyBindingRTE.PNG

Orr K.
Irvine, CA

Jul 7, 2014
21 Posts

0 ✔  |  ✗ 0  

Re: How to load test parameters from Excel?

Jon,

I have tried to replicate the problem with the early binding example and I could not. I have tried running the same Tests with object libraries 12.0(2007) and 15.0(2013). They have all worked for me with the information that you have provided.

If you have any more questions please post again and I will be happy to try and resolve the issue.



Please Note
You need to have a M@GIC account to participate in the Forums.
Not yet registered on our website? Click here to register today!

All content, information and opinions presented on the Marvin Test Solutions User Forums are those of the authors of the posts and messages and not Marvin Test Solutions'. All attachments and files are downloaded at your own risk. [Read More]