<?php require_once __DIR__ . '/../vendor/autoload.php'; use FriendlySpreadSheet\FriendlySpreadSheet; $config = (require __DIR__ . '/config.php'); $worksheets = FriendlySpreadSheet::auth($config)->listWorksheet('test'); var_dump($worksheets);
<?php require_once __DIR__ . '/../vendor/autoload.php'; use FriendlySpreadSheet\FriendlySpreadSheet; $config = (require __DIR__ . '/config.php'); FriendlySpreadSheet::auth($config)->createWriterClient()->to('test', 'monsters')->update(['name' => 'だんみつ'], ['id' => 9]);
<?php require_once __DIR__ . '/../vendor/autoload.php'; use FriendlySpreadSheet\FriendlySpreadSheet; $config = (require __DIR__ . '/config.php'); $monsters = FriendlySpreadSheet::auth($config)->createReaderClient()->select(['*'])->from('test', 'monsters')->orderBy('cost', 'ASC')->setMaxResults(2)->exec()->fetchAll(); var_dump($monsters); exit;
<?php require_once __DIR__ . '/../vendor/autoload.php'; use FriendlySpreadSheet\FriendlySpreadSheet; $config = (require __DIR__ . '/config.php'); FriendlySpreadSheet::auth($config)->createWriterClient()->to('test', 'monsters')->insert(['id' => 10, 'name' => 'foo', 'cost' => 400, 'rare' => 340, 'exp' => 23100]);
<?php require_once __DIR__ . '/../vendor/autoload.php'; use FriendlySpreadSheet\FriendlySpreadSheet; $config = (require __DIR__ . '/config.php'); $client = FriendlySpreadSheet::auth($config)->createReaderClient(); var_dump($client->getLastUpdatedAt('test', 'monsters')); exit;