How to show data by getEntry(); in readable format

[jabedbd]

my code is $spreadsheetService = new Google\Spreadsheet\SpreadsheetService(); $spreadsheetFeed = $spreadsheetService->getSpreadsheetFeed(); $sps = $spreadsheetFeed->getEntries(); var_dump($sps); how to i format the data in a proper format(for example get all the ID , Get all the Name etc)

[moe3615]

Try this, it works great for me. Everything in caps must be replaced with your information.

$spreadsheetService = new Google\Spreadsheet\SpreadsheetService(); $spreadsheetFeed = $spreadsheetService->getSpreadsheetFeed(); $spreadsheet = $spreadsheetFeed->getByTitle('PUT HERE THE TITLE OF THE DOCUMENT'); $worksheetFeed = $spreadsheet->getWorksheetFeed(); $worksheet = $worksheetFeed->getByTitle('PUT HERE THE TITLE OF THE WORK SHEET USUALLY Sheet1'); $listFeed1 = $worksheet->getListFeed();

foreach ($listFeed1->getEntries() as $listEntry) { $data = $listEntry->getValues(); echo 'Column 1 ' . $data['PUT HERE THE TITLE FOR COLUMN 1 FROM YOUR SPREADSHEET'].'
'; echo 'Column 2 ' . $data['PUT HERE THE TITLE FOR COLUMN 2 FROM YOUR SPREADSHEET'].'
'; }