Interfacing to google sheet

Discussions relating to the use of Extend and how it interfaces with other applications.
Post Reply
fBE
Posts:1
Joined:Wed Aug 09, 2017 11:20 am
First Name:Florent
Last Name:Bruyere
Interfacing to google sheet

Post by fBE » Wed Sep 26, 2018 12:47 am

Hi,

I wanted to know if there is a simple way to export database result to a google sheet (to do it directly without export to excel first) ?
If yes, how can we do that ? Use a custom block with google API ?

Thanks
Florent

davek
Posts:75
Joined:Thu Apr 27, 2000 12:00 am
First Name:Dave
Last Name:Krahl

Re: Interfacing to google sheet

Post by davek » Thu Sep 27, 2018 10:33 am

Florent,

This is quite feasible. Google sheets has an API that ExtendSim should be able to communicate to. I would be a little concerned about performance if you have a large amount of data that you are exporting. We here at Kromite have experience in programming ExtendSim and web-based applications. This is very similar to work that we have done as part of other projects where created a live connection between ExtendSim and a remote PostgreSQL database. We added significant enhancements to ExtenSim's built-in capability to communicate with an SQL database. We would be happy to do the same to provide you this capability. Please contact us for further discussion.

Dave Krahl
Kromite LLC
dkrahl@kromite.com

Post Reply