料斗/工作表

谷歌工作表API工具

维护者

详情

github.com/pengan95/g_sheet

源代码

问题

安装: 3

依赖项: 0

建议者: 0

安全性: 0

星标: 0

关注者: 1

分支: 0

开放问题: 0

v1.0 2021-06-21 02:22 UTC

Requires

MIT 31900d3fd2d7a2bdb24656a6f967129b1c815a6b

  • hopperhuang <hopperhuang.woop@meikaitech.com>

This package is auto-updated.

Last update: 2024-09-06 16:32:37 UTC

README

为明快提供的谷歌工作表API

示例

include_once "./vendor/autoload.php";

use MeiKaiGsuit\GSheet\GClient;

$client = (new GClient(GClient::SHEET_WRITE_SCOPE_GROUP))->getClient();

$data = [
    '2021-06',
    '=AB`BR1`',
    [
        'value' => 0.1,
        'number_format' => [
            'type' => \MeiKaiGsuit\GSheet\GSheetCell::FIELDS_NUMBER_FORMAT_TYPE_PERCENT,
//            'pattern' => '',
        ]
    ],
    '123.11',
    '=SUM(`BC3``CR`:`BC1``CR`)',
];

$gfile = new \MeiKaiGsuit\GSheet\GSheet($client, '1jYiRxggd3T2iBDpkin97p5p9q5SX7172ReH_aS9VsKg');

$sheets = $gfile->getSheets();

foreach ($sheets as $sheet) {
    if (!preg_match('/^[A-Z]{3}$/', $sheet->getProperties()->getTitle())) {
        continue;
    }
    $row_index = $gfile->getSheetLastRow($sheet);
    $gfile->addCurrencyNumberRow($sheet->getProperties()->getSheetId(), $sheet->getProperties()->getTitle(), $row_index, $data);
}