Accessing Google sheets in Ranorex with authentication

Class library usage, coding and language questions.
ssawale
Posts: 7
Joined: Fri Mar 03, 2017 7:52 pm

Accessing Google sheets in Ranorex with authentication

Post by ssawale » Tue Mar 28, 2017 1:48 am

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!

jma
Posts: 111
Joined: Fri Jul 03, 2015 9:18 am

Re: Accessing Google sheets in Ranorex with authentication

Post by jma » Thu Mar 30, 2017 1:34 pm

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.

ssawale
Posts: 7
Joined: Fri Mar 03, 2017 7:52 pm

Re: Accessing Google sheets in Ranorex with authentication

Post by ssawale » Thu Mar 30, 2017 6:23 pm

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!

krstcs
Ranorex Guru
Posts: 2683
Joined: Tue Feb 07, 2012 4:14 pm
Location: Austin, Texas, USA

Re: Accessing Google sheets in Ranorex with authentication

Post by krstcs » Thu Mar 30, 2017 7:08 pm

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."
Shortcuts usually aren't...

ssawale
Posts: 7
Joined: Fri Mar 03, 2017 7:52 pm

Re: Accessing Google sheets in Ranorex with authentication

Post by ssawale » Thu Mar 30, 2017 11:28 pm