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]);
}
