从谷歌电子表格php api获取多张表格中的行

Question

I have a file with multiple sheets on google drive. When i tried to run this code:

$response = $service->spreadsheets_values->get($google_file, $range);

The result i get are only the rows from the first sheet. I can see the name s of the sheets by this code:

foreach($response->getSheets() as $s) {
                $sheet_name = $s['properties']['title'];
            }

But, how can i get the rows of all each one of them please? Thanks!

Answer 1

The solution:

$rows = array();
            foreach($response->getSheets() as $s) {
                $sheet_name = $s['properties']['title'];
                $range = "'".$sheet_name."'!A1:BL";
                $rows[$sheet_name] = $service->spreadsheets_values->get($google_file, $range)->getValues();
            }