Author: Asim Liaquat (asimlqt22@gmail.com)
 public function testGetWorksheetsFeedUrl()
 {
     $xml = file_get_contents(__DIR__ . '/xml/spreadsheet.xml');
     $spreadsheet = new Spreadsheet(new SimpleXMLElement($xml));
     $this->assertEquals('https://spreadsheets.google.com/feeds/worksheets/tFEgU8ywJkkjcZjG/private/full', $spreadsheet->getWorksheetsFeedUrl());
 }
 public function testGetWorksheetsFeedUrl()
 {
     $spreadsheet = new Spreadsheet($this->getSimpleXMLElement("spreadsheet"));
     $this->assertEquals("https://spreadsheets.google.com/feeds/worksheets/tFEgU8ywJkkjcZjG/private/full", $spreadsheet->getWorksheetsFeedUrl());
 }
Ejemplo n.º 3
0
 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;
 }