E2upms’;
$range = ‘Class Data!A2:E’;
$response = $service->spreadsheets_values->get($spreadsheetId, $range);
$values = $response->getValues();
if (count($values) == 0) {
print “No data found.n”;
} else {
print “Name, Major:n”;
foreach ($values as $row) {
// Print columns A and E, which correspond to indices 0 and 4.
printf(“%s, %sn”, $row[0], $row[4]);
Was this code snippet helpful?
YesNo