Download the PHP package holoolaz/sheets2api without Composer

On this page you can find all versions of the php package holoolaz/sheets2api. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Example code of holoolaz/sheets2api

Informations about the package sheets2api

sheets2api Library

Turn Google Sheets to JSON API and excel files

Fast Links

Introduction

sheets2api Library has been made by Holoola-z Company, please do not edit or abuse the usage of this Library.

sheets2api Library is mainly used to convert Google Sheets to JSON API so that it can be used in CMS, wordpress, custom websites and more..., You can simply display a Google Spreadsheet in a webpage as json file.

Installation

The best way to install this Library is through composer:

Usage

In your file inlude the file and use the namespace of the main class like this:

Let's use our api id '617989cb51352':

Get All Spreadsheet Data

Important: Each time you use this api when calling Spreadsheet() then you're actually selecting the first sheet like the example below:

Important: Now let's select a specific Sheet to get data from:

Optional Parameters

Or

Note: Same thing goes to all other api call class methods.

Get Spreadsheet Cells

Get Spreadsheet Rows Count

Get Spreadsheet Column Names (Keys)

Search Entire Spreadsheet by Values

Note

This method can take additional parameters:

Search Entire Spreadsheet by Condition

Note

This method can take additional parameters:

List Spreadsheet Sheets (Tabs)

Get Spreadsheet Name

List All Spreadsheets

Clear Spreadsheet Sheet (Tab)

Clear Spreadsheet Sheet (Tab)

Here we're copying data to this Spreadsheet id.

Delete Spreadsheet Row

Here we removed the row that has column name Id and value of 3.

Note: Calling this method can delete multiple rows at once, make sure that column name and value are unique.

Important: Do not use spaces in the condition parameter like this won't work.

Update Spreadsheet Row

Update Spreadsheet Multiple Rows

Create Spreadsheet Sheet (Tab)

Note: Here we created a new Sheet called NEW_SHEET.

Delete Spreadsheet Sheets (Tabs)

Note: Here we're deleting only Sheet23, but what if we wanted to delete 3 more sheets.

That's it, we deleted 3 Sheets instead of 1.

Import HTML Table into Sheet (TAB)

Import HTML List into Sheet (TAB)

Important: You can always use Our API Documentation for more step by step guide.

All versions of sheets2api with dependencies

PHP Build Version
Package Version
Requires php Version >=7.1.0
ext-curl Version *
ext-json Version *
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package holoolaz/sheets2api contains the following files

Loading the files please wait ....