Page 1 of 1

'Failed to get rows from data source' - Excel data binding

Posted: Wed Jan 30, 2013 11:25 pm
by hporter
My test case uses Excel data binding for several variables (BTW, MSOffice IS installed on the client). I've created a Task Scheduler task that runs my test exe. I've configured this task to run with the setting 'Run whether user is logged on or not' in Task Scheduler. When I try to run my test (having first logged off the VM), I get the following message:

Failed to get rows from data source: Microsoft Excel cannot access the file 'C:\My File\My_File.xlsx'. There are several possible reasons: • The file name or path does not exist. • The file is being used by another program. • The workbook you are trying to save has the same name as a currently open workbook.

If I am logged on and have the task configured to 'Run only when user is logged in,' it works fine. Any ideas as to what's going on here? Thanks in advance for any assistance.

Re: 'Failed to get rows from data source' - Excel data binding

Posted: Fri Feb 01, 2013 5:19 pm
by Support Team
Hello,

We could reproduce this issue and will analyze it as soon as possible.

Regards,
Markus (T)

Re: 'Failed to get rows from data source' - Excel data binding

Posted: Mon Feb 04, 2013 6:16 pm
by hporter
Thank you for the update. It's not a huge deal right now, but eventually it will need to be addressed. Do you have any idea of time frame for when this might be fixed? Since it's evidently a bug, is there a formal way of notifying me when it's resolved?

Re: 'Failed to get rows from data source' - Excel data binding

Posted: Tue Feb 05, 2013 12:33 pm
by Support Team
Hello,

It seems to be an issue of automating office products without UI as described at Microsoft.

You could solve it if you create a new folder in:
C:\Windows\SysWOW64\config\systemprofile\Desktop

If you are using a 32-bit Windows, please create a folder in:
C:\Windows\System32\config\systemprofile\Desktop (x86)

Please let me know if it works.

Regards,
Markus (T)

Re: 'Failed to get rows from data source' - Excel data binding

Posted: Wed Feb 06, 2013 7:40 pm
by hporter
Much appreciated, Markus - creating that folder seems to have gotten me past the original issue. Now, the test fails in the same fashion as a test running in a minimized RDP (which is well-documented elsewhere on this site). So it appears it may not work ultimately.

Out of curiosity, has anyone else been able to successfully run a Ranorex test from task scheduler, when the machine itself has been logged off entirely?

Re: 'Failed to get rows from data source' - Excel data binding

Posted: Wed Feb 06, 2013 8:23 pm
by Ciege
hporter wrote:Out of curiosity, has anyone else been able to successfully run a Ranorex test from task scheduler, when the machine itself has been logged off entirely?
Nope... No Desktop = No UI. No UI = No Automation...

Re: 'Failed to get rows from data source' - Excel data binding

Posted: Wed Feb 06, 2013 9:02 pm
by hporter
That's what I figured...thanks, Ciege!