sounds good, thanks Bill.
i would have thought there would be a more elegant way of identifying
empty cells in between cells with data. but then again....
Regards
Boaz
On Oct 3, 5:45 pm, Bill Hayes <bhaye...@gmail.com> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
