Page 1 of 1

Ranorex cannot load Excel data source (Insufficient memory)

Posted: Mon Dec 09, 2013 11:54 am
by 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

Re: Ranorex cannot load Excel data source (Insufficient memory)

Posted: Tue Dec 10, 2013 1:21 pm
by Support Team
Hi,

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

Regards,
Markus

Re: Ranorex cannot load Excel data source (Insufficient memory)

Posted: Tue Jan 21, 2014 8:11 am
by 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

Re: Ranorex cannot load Excel data source (Insufficient memory)

Posted: Tue Feb 11, 2014 4:12 pm
by 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