GooglespreadsheetphpclientAPI-php Tutorial

Google spreadsheetphpclientapi recently closed the ClientLogin authentication method. as a result, the zend gdata api that has been used for a long time cannot work normally.

The zend updated the api in December May 20, but did not convert the ClientLogin method used for OAuth 2.0 verification recommended by Google.

So at least search for the google spreadsheet API on the internet. the damn google actually only has the java and. net API library based on OAuth verification.

This is big. do you need to study the spreadsheet API documentation and write your own php API? but the company's business cannot wait.

So I went to the google Forum to search. Fortunately, a good foreign buddy gave an address http://stackoverflow.com/questions/21470405/google-api-how-to-connect-to-receive-values-from-spreadsheet

Github is omnipotent indeed. someone has put spreadsheet php library above. Project address: https://github.com/asimlqt/php-google-spreadsheet-client

Then google OAuth php library. php is used to operate google spreadsheet.

There is an episode in the middle. it takes two minutes for the server to connect to google in the United States. after checking the code for half a day, no problem was found. with O & M, I found that the original IPV6 network was used. google's IPV6 routing seems to be faulty. as a result, each link takes more than two minutes. it's just a pitfall.