public function createWorksheet(File $file) { $csvFile = new CsvFile($file->getPathname()); $colCount = $csvFile->getColumnsCount(); $rowCount = $this->countLines($csvFile); $entryXml = $this->templating->render('KeboolaGoogleDriveWriterBundle:Feed:Worksheet/entry.xml.twig', ['title' => $file->getTitle(), 'cols' => $colCount, 'rows' => $rowCount]); return $this->api->request(sprintf(self::SPREADSHEET_WORKSHEETS . '/%s/private/full', $file->getGoogleId()), 'POST', ['Accept' => 'application/atom+xml', 'Content-Type' => 'application/atom+xml', 'GData-Version' => '3.0'], ['body' => $entryXml]); }