public function testCreateWorksheet()
{
// create new file type='sheet'
$file = $this->createTestFile();
$fileRes = $this->restApi->insertFile($file);
// this file now has one empty sheet
$sheets = $this->restApi->getWorksheets($fileRes['id']);
$sheet = array_shift($sheets);
$file->setGoogleId($fileRes['id']);
$file->setSheetId($sheet['wsid']);
// create second sheet in the same file
$file2 = new File(['id' => 1, 'title' => 'Test Sheet2', 'googleId' => $fileRes['id'], 'tableId' => 'empty', 'type' => 'sheet', 'pathname' => $this->test2CsvPath]);
// create new worksheet
$response = $this->restApi->createWorksheet($file2);
$this->assertEquals(201, $response->getStatusCode());
// cleanup
$this->restApi->deleteFile($file);
}
