Boaz,
Create a array and fill it with NULL values,
then instead of directly displaying values from the spreadsheet
put them into the array, then display that array.
Does that do what you want?
BTW, the list feed stops at the first entirely empty row, I assume
the cell feed does the same but I haven't tested this, so you have
to be careful to avoid blank rows.
Regards,
Bill
On Sat, Oct 3, 2009 at 6:56 AM, boaz <boaz.frank...@gmail.com> wrote:
>
> Hi, i have a spreadsheet that has some empty cells.
> i want to be able to get those cell as a NULL value.
> it seems the $cellFeed doesn't include them in the query result.
>
> for example, im running this code:
>
> $query = new Zend_Gdata_Spreadsheets_CellQuery();
> $query->setMinCol(5);
> $query->setMaxCol(6);
> $query->setMinRow(2);
> $query->setSpreadsheetKey($spreadsheetsKey); //
> spreadsheet id
> $query->setWorksheetId($worksheetId); //
> worksheet id
> $cellFeed = $spreadsheetService->getCellFeed($query);
>
>
> $cellFeed = $spreadsheetService->getCellFeed($query);
>
> // displays cells
> foreach($cellFeed as $cellEntery){
> $row=$cellEntery->cell->getRow();
> $col=$cellEntery->cell->getColumn();
> $val=$cellEntery->cell->getText();
> echo $row.",".$col."=".$val."\n";
> }
>
> this is the result:
>
> 7,5=user1
> 7,6=password1
> 8,5=user2
> 8,6=password2
> 9,5=user3
> 10,6=password4
>
> as you can see cells 9,6 and 10,5 are empty and they are not
> displayed. i would still like their value to be "" or NULL.
>
> thanks,
> Boaz
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google Docs Data APIs" group.
To post to this group, send email to Google-Docs-Data-APIs@googlegroups.com
To unsubscribe from this group, send email to
google-docs-data-apis+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Google-Docs-Data-APIs?hl=en
-~----------~----~----~----~------~----~------~--~---
