Ranorex cannot load Excel data source (Insufficient memory)

[Swisside]

EDIT : Okay I figured it out. Apparently Ranorex was loading all the lines up to the maximum even tho they were empty. It was solved by selecting all the empty lines and deleting them (awkward I know)


Hi all !

It appears that Ranorex cannot load my data source any more due to insufficient memory.

First I thought it was because I added some lines (5) to my data sheet but in fact it just doesn't load the file even if I only leave one line (1 iteration).

Is it because my Ranorex Project has grown too big ?


Any idea welcomed !


Regards

[Support Team]

Hi,

Thanks for informing us that you were able to solve the issue !

Regards,
Markus

[Abigail111]

HI there
I have encountered the similar questions with you.I tried to load excel files using this code which is from google:
///<summary>
/// Load ExcelDocument from native file format
///</summary>
///<param name="filePath"></param>
///<returns></returns>
public ExcelDocument LoadExcelDocumentFromFile(String filePath)
{

return new ExcelDocument(filePath);


But it can not work.What's wrong with my code?Is it possible for Ranorex to load excel files direclty?
Thanks a lot

[Support Team]

Hi Abigail,

I’m sorry for the late reply.

Why do you want to load an Excel file in code?
What do you need the file for, for data driven tests or do you want to perform some actions on it?

Regards,
Markus