function __construct($key, $sheetidx = 0) { $gsheetreq = new HTTP\HTTPRequest('https://docs.google.com/spreadsheets/d/' . $key . '/pub?single=true&gid=' . $sheetidx . '&output=csv'); $gsheetreq->setFollowLocation(true); try { $gsheetresp = $gsheetreq->send(); $csvdata = $gsheetresp->getBody(); } catch (\Exception $e) { $csvdata = ''; } $filename = tempnam('/tmp', 'edgecsv'); file_put_contents($filename, $csvdata); parent::__construct($filename); $this->parse(); }
<?php // load require '../src/Coseva/CSV.php'; // read $csv = new Coseva\CSV('example1.csv'); // parse $csv->parse(); // disco echo $csv->toJSON();
<?php // load require '../src/Coseva/CSV.php'; // read $csv = new Coseva\CSV('example1.csv'); // parse $csv->parse(); // disco foreach ($csv as $row) { // persist row to datastore or something }