public function testAddWorksheet() { $this->setServiceRequest('worksheet.xml'); $xml = file_get_contents(__DIR__ . '/xml/spreadsheet.xml'); $spreadsheet = new Spreadsheet(new SimpleXMLElement($xml)); $this->assertTrue($spreadsheet->addWorksheet('Sheet 3') instanceof Worksheet); }
public function testAddWorksheet() { $this->setServiceRequest("worksheet.xml"); $spreadsheet = new Spreadsheet($this->getSimpleXMLElement("spreadsheet")); $this->assertTrue($spreadsheet->addWorksheet("Sheet 3") instanceof Worksheet); }
protected function _get_new_worksheet($title, \Google\Spreadsheet\Spreadsheet &$spreadsheet, \Google\Spreadsheet\WorksheetFeed &$worksheet_feed) { $spreadsheet->addWorksheet($title); $worksheet_feed = $spreadsheet->getWorksheets(); # delete auto generated worksheets $_auto_worksheet_names = ['Sheet1', 'Sheet2', 'Sheet3', 'Sheet4']; $auto_worksheet_names = []; foreach ($_auto_worksheet_names as $_auto_worksheet_name) { if ($title != $_auto_worksheet_name) { $auto_worksheet_names[] = $_auto_worksheet_name; } } foreach ($auto_worksheet_names as $auto_worksheet_name) { $temp_worksheet = $worksheet_feed->getByTitle($auto_worksheet_name); if ($temp_worksheet) { $temp_worksheet->delete(); } } $worksheet = $worksheet_feed->getByTitle($title); if (!$worksheet) { throw new HelperException('error creating worksheet'); } return $worksheet; }