Read Excel files from a Ranorextest without Microsoft Office installed
We want to start a Windows-Jenkins-Slave to start a Ranorex-Test in a Jenkins-pipeline. This scenario is only usefull if Ranorex could read Excell files without Microsoft Office installed (licensecost)
As mentioned you can use NPOI or, if you generate Excel 2007+ files (xlsx) then OpenSDK support is built in into .NET and there are plenty of code examples you can use.
Wilco Rakhorst commented
If you put a macro in your Excel file which saves it as a .csv file you can create a batch file which opens every Excel file in a folder and executes the macro and then saves the files as a .csv file. In this way you can edit your data in Excel en before you run your tests, you update your data source(s).
If interested I can post the macro and the batch file.
AdminRanorex (Admin, Ranorex) commented
I would like to better understand your use cases. Therefore I need to know if your Excel files do contain macros and formulars or if the are just static?
For static Excel files I recommend to use CSV, like Kelly suggested.
Ranorex Product Management Team
Use CSV files instead. They can be read/written by any text application (and Excel) and do not need Excel installed.
NPOI is the .net version of the POI Java project at http://poi.apache.org/. This tool reads and writes Excel workbooks without Microsoft Office suite being installed on your test machine
Andreas Kuttruff commented
Excel Viewer doesn't work, beacause it seems that Ranorex uses the Excel COM interface.
But Ronorex should support open source file formats ou of the box.
We wannt ti execute our tests in the cloud. This scenario is only usefull if Ranorex could read Excell files without Microsoft Office installed - Licenseproblems
We don't want to use csv because many collegues are familiar with excel
Just copy the dll's you need to the server.
Pavel Kudrys commented
I think it would be perfectly acceptable to install at least MS Excel viewer, which is free ;)