How to write data i excel from application? : Automation API

[pripari]

We are trying to send variable data in excel from Ranorex while execution. Please suggest the way to do this. We checked exceldataconnector but could'nt get proper code for the same. any help would be appreciated.

thanks

[Support Team]

Hi,

Just to clarify this, you want to send variables from Ranorex Studio to your Excel sheet during the execution of your solution?
What do you want to accomplish whit this, or what is the sense of it?

Regards,
Markus
Ranorex Support Team

[pripari]

We want to send variable names captured from application to external excel sheet which will be used for reprorting purpose. We are not able to get code for connecting to external excel sheet or creating new excel sheet within the code.

[Ciege]

Have a look here for my implementation of using Microsoft.Office.Interop.Excel.
http://www.ranorex.com/forum/my-excel-framework-methods-t3265.html

[pripari]

"Microsoft.Office.Interop.Excel" does not exists in Project->add Reference->COM
How to add "Microsoft.Office.Interop.Excel" reference in ranorex studio?

[Ciege]

It's under .NET not COM.

From VS: References -> Add Reference -> .NET -> Microsoft.Office.Interop.Excel

[Support Team]

Hi,

How to add "Microsoft.Office.Interop.Excel" reference in ranorex studio?

If you have installed Excel on the machine you should find the Microsoft.Office.Interop.Excel assembly in the GAC folder of the Add Reference Dialog.

Regards,
Peter
Ranorex Team

[pripari]

We have excel installed on that machine, but still we could not see Micorsoft.Office.Interop.Excel under GAC folder.

[Support Team]

Hi,

We have excel installed on that machine, but still we could not see Micorsoft.Office.Interop.Excel under GAC folder.

If you want to interact with Excelobjects, you don't have to explicit add the Interop assembly, because Ranorex already has a reference to this assembly. Just use

Excel.Workbooks workBook = new Excel.WorkbookClass();

for example.

To check if you have access to this, check your reference folder and look if the office plugin is referenced to your project.

Regards,
Peter
Ranorex Team