README

composer require merceslab/spreadsheet-client-bundle

配置

merces_lab_google_spreadsheet:
    credentials: '{}' # JSON string
    files: # optional, creates a GoogleFile service named 'merces_lab.spreadsheet_client.google.file.my_file'
        my_file:
            file: 'myFileId'
    sheets: # optional, creates a GoogleSheet service named 'merces_lab.spreadsheet_client.google.sheet.my_sheet'
        my_sheet:
            file: 'myFileId'
            sheetName: 'mySheet'
    tables: # optional, creates a GoogleTable service named 'merces_lab.spreadsheet_client.google.table.my_table'
        my_table:
            file: 'myFileId'
            sheetName: 'mySheet'
            tableRange: 'H1:AA1'

使用方法

将数据写入Google表格

<?php

use MercesLab\Component\SpreadsheetClient\ClientInterface;

class SomeService
{
    public function export(ClientInterface $client)
    {
        $client->write(['foor', 'bar',], 'myFile');
    }
}

从Google表格读取数据

<?php

use MercesLab\Component\SpreadsheetClient\ClientInterface;

class SomeService
{
    public function import(ClientInterface $client)
    {
        $data = $client->read('fileId');
    }
}

查看组件文档：https://github.com/MercesLyon/GoogleFixtures

merceslab / spreadsheet-client-bundle

维护者

详细信息

README

配置

使用方法