Easy-to-use Free PHP Library for Google Spreadsheets Data API v3.0, latest and updated
- Step-1) Download zip file and extract contents (2 files) to the same folder Click here to Download Files
- Step-2) Modify the "sodso-google-spreadsheets-api-test.php" file and execute it to view results
- This API library supports the following Spreadsheet functions:
- 1) Backend Login to Google with ClientLogin Authentication with Emailid / Password
- 2) Retrieving a list of Spreadsheets which have matching title / exact matching title / matching author / updated during certain timeline / with starting index / max number of results per page
- 3) Retrieving a list of Worksheets within a Spreadsheet which have matching title / exact matching title
- 4) Adding a new Worksheet to a Spreadsheet with Title / Rows / Columns
- 5) Modifying a Worksheet with new Title / Rows / Columns
- 6) Deleting a Worksheet within a Spreadsheet
- 7) Retrieving a list of Rows with structured query on specific columns on specific values / full text search query / ordered by row position / ordered by specific column / with ordering in ascending or descending order / with starting index / max number of results per page
- 8) Adding a new Row with column data
- 9) Updating a Row with new column data
- 10) Deleting a Specific Row
- 11) Retrieving a list of Cells with full text search query / with or without empty cells / within range of cells / search within subset of cells / with starting index / max number of results per page
- 12) Updating the contents of a Cell
- 13) Updating multiple cells with a batch request
|