Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us.

Post New Thread Reply

Register GFY Rules Calendar
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >
Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed.

 
Thread Tools
Old 07-15-2017, 02:55 PM   #1
NickBaer
Nick Baer
 
NickBaer's Avatar
 
Industry Role:
Join Date: Jun 2005
Location: In Europe. Using high speed Internet to update my studios.
Posts: 1,338
Google Sheets and PHP

Has anyone been successful getting PHP to read (and maybe write/edit) Google Sheets?

4-5 hours later, I have found the worst awful collection of "how to's" and user experiences.

Most are about v3, but it's been v4 for a long time.

I think I have the Sharing done right, and Credentials.
__________________
Made my first porno in 1986. Sold my first VHS in 1993. Did my first live Cam in 1994. Coach-Karl.com NickBaerGallery.com I host with MojoHost.com and To Buy or Sell Sites Imagine AI Content
NickBaer is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 07-15-2017, 02:59 PM   #2
NickBaer
Nick Baer
 
NickBaer's Avatar
 
Industry Role:
Join Date: Jun 2005
Location: In Europe. Using high speed Internet to update my studios.
Posts: 1,338
I've been using PHPExcel with .xls files for a few years now. Learned tonight that Google Sheets downloads as .xlsx... but was able to find the fix for PHPExcel 1.8 to do .xlsx. Which is backwards compatible with .xls.

So I at least have a workaround. Since I like to travel, I like using Sheets with the Chrome Excel extension, rather than .xls files and OO (which is a dead-end project, and LibreOffice is of no interest to me with the Excel Chrome Extension). I would like to take the next step beyond downloading/FTP'ing a .xlsx file to my webserver, to being realtime read (at least) of that spreadsheet data by my PHP script for the webpage in question..
__________________
Made my first porno in 1986. Sold my first VHS in 1993. Did my first live Cam in 1994. Coach-Karl.com NickBaerGallery.com I host with MojoHost.com and To Buy or Sell Sites Imagine AI Content
NickBaer is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 07-16-2017, 11:48 AM   #3
magneto664
God Bless You
 
magneto664's Avatar
 
Industry Role:
Join Date: Aug 2014
Location: Glasgow, $cotland
Posts: 1,467
check https://zapier.com/ and https://ifttt.com maybe you find working solution
__________________
magneto664 📧 gmail.com
Adult Backlinks 💘Best Website Stats 💘 Best CDN for Adult Content
My Fav: 👍Chaturbate 👍 Stripchat 👍 Dateprofits 👍 AdultFriendFinder
magneto664 is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 07-18-2017, 01:03 PM   #4
NickBaer
Nick Baer
 
NickBaer's Avatar
 
Industry Role:
Join Date: Jun 2005
Location: In Europe. Using high speed Internet to update my studios.
Posts: 1,338
Got it to work. Used a very simple method, because all I want to do is "read" a Google Sheets spreadsheet.

When I get to the point that I want to "edit" or "write," then I will use Plan B, which is harder.
__________________
Made my first porno in 1986. Sold my first VHS in 1993. Did my first live Cam in 1994. Coach-Karl.com NickBaerGallery.com I host with MojoHost.com and To Buy or Sell Sites Imagine AI Content
NickBaer is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 08-12-2017, 02:12 PM   #5
robber
Web Developer
 
Industry Role:
Join Date: Jan 2011
Location: UK
Posts: 264
Have you considered using a csv file as it can be read with google sheets and you can easily read it directly into your web server. It also would allow for you to push amendments back by recreating the file which should be pretty simple with PHP

It would save any messing on both sides 😊
robber is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 08-13-2017, 07:52 AM   #6
Barry-xlovecam
It's 42
 
Industry Role:
Join Date: Jun 2010
Location: Global
Posts: 18,083
^^^I like your thinking
Barry-xlovecam is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Post New Thread Reply
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >

Bookmarks

Tags
google, sheets, php, experiences, sharing, credentials, time, user, awful, read, successful, write/edit, 4-5, collection, worst, found, hours, tos



Advertising inquiries - marketing at gfy dot com

Contact Admin - Advertise - GFY Rules - Top

©2000-, AI Media Network Inc



Powered by vBulletin
Copyright © 2000- Jelsoft Enterprises Limited.