Page 1 of 1

Accessing Google sheets in Ranorex with authentication

Posted: Tue Mar 28, 2017 1:48 am
by ssawale
Hi,

I want to read/ write data organized under multiple tabs from Google sheet in Ranorex.

Does anyone tried to use Google sheets to read and write through Ranorex? What APIs or code snippet required to do the same?

Highly appreciate your help!

Thanks!

Re: Accessing Google sheets in Ranorex with authentication

Posted: Thu Mar 30, 2017 1:34 pm
by jma
Hi ssawale,

I doubt that anybody is able to provide code snippets specific for automating a Google sheet. In order the community can help you, please describe your use case in detail. Which issues do you currently experience when automating your use case? Probably, it will also be helpful to upload a Ranorex Snapshot of the UI element in question.

Re: Accessing Google sheets in Ranorex with authentication

Posted: Thu Mar 30, 2017 6:23 pm
by ssawale
I just want to use google sheet as data source. It's not about UI automation of google sheet rather accessing google sheets through ranorex supported APIs.

Hope you understand the question now.

Thanks!

Re: Accessing Google sheets in Ranorex with authentication

Posted: Thu Mar 30, 2017 7:08 pm
by krstcs
Ranorex does not support Google Sheets as a data source. As stated in the User Guide, Ranorex only supports CSV, Excel, and SQL databases as connectors, as well has having an internal type called "Simple Data Table."

Re: Accessing Google sheets in Ranorex with authentication

Posted: Thu Mar 30, 2017 11:28 pm
by ssawale