GOOGLE spreadsheet PHP Client API

Recently because Google closed the Clientlogin authentication method. The Zend Gdata API that has been used previously has not worked properly.

Damn it, Zend. May 20 updated API but did not convert the Google recommended OAuth 2.0 authentication still use the Clientlogin way.

So at least search the internet for Google Spreadsheet API. Damn Google just out of Java and. NET based on OAuth Authentication API library.

It's a big drop. Do you want to study spreadsheet's API documentation and then write your own PHP API. But the company's business cannot wait.

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

GitHub is everything. The spreadsheet PHP Library was released earlier. Project Address: Https://github.com/asimlqt/php-google-spreadsheet-client

Then combine the Google OAuth PHP library. PHP Operation Google Spreadsheet is completely OK.

There's an episode in the middle. It always takes 2 minutes for the server to connect to Google's servers in the United States. Check for a half-day code did not find the problem, with the operation of a check to know that the original walk is IPV6 network. and Google's IPV6 's routing seems to be out of the question. It will take more than 2 minutes for each link. It's a pit-daddy.

GOOGLE spreadsheet PHP Client API