Ranorex cannot load Excel data source (Insufficient memory)

Ranorex Spy, Recorder, and Studio.
Swisside
Posts: 92
Joined: Thu Oct 10, 2013 10:40 am

Ranorex cannot load Excel data source (Insufficient memory)

Post by Swisside » Mon Dec 09, 2013 11:54 am

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
Attachments
FailedToLoadData_InsufficientMemory.png
Failed to load Excel data
FailedToLoadData_InsufficientMemory.png (37.64 KiB) Viewed 728 times
A simple thank you always does wonders !

User avatar
Support Team
Site Admin
Site Admin
Posts: 11709
Joined: Fri Jul 07, 2006 4:30 pm
Location: Graz, Austria

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

Post by Support Team » Tue Dec 10, 2013 1:21 pm

Hi,

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

Regards,
Markus
.
Image

Abigail111
Posts: 1
Joined: Mon Aug 26, 2013 7:48 am

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

Post by Abigail111 » Tue Jan 21, 2014 8:11 am

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

User avatar
Support Team
Site Admin
Site Admin
Posts: 11709
Joined: Fri Jul 07, 2006 4:30 pm
Location: Graz, Austria

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

Post by Support Team » Tue Feb 11, 2014 4:12 pm

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
.
Image