mojibakeo/friendly-spreadsheet

friendly spreadsheets

This package's canonical repository appears to be gone and the package has been frozen as a result. Email us for help if needed.

dev-master / 1.0.x-dev 2016-03-23 10:39 UTC

Requires

• google/apiclient: ~1.1@dev
• mojibakeo/php-google-spreadsheet-client: 2.3.5@dev

MIT

• mojibakeo

README

simple google spreadsheet client

develop env

• mac os x yosemite
• php55

usage

examples

• install

composer require mojibakeo/friendly-spreadsheet dev-master

• fetch rows

<?php

require_once __DIR__ . '/../vendor/autoload.php';

use FriendlySpreadSheet\FriendlySpreadSheet;

$config = require __DIR__ . '/config.php';

$monsters = FriendlySpreadSheet::auth($config)->createReaderClient()
    ->select(['*'])
    ->from('test', 'モンスター一覧')
    ->where('cost > 20')
    ->orderBy('rare', 'ASC')
    ->setMaxResults(2)
    ->exec()
    ->fetchAll();

var_dump($monsters);