This technique is called 'sparse matrix'.
Where most of the cells are empty it saves
memory and bandwidth and processing by not
having to handle 99% of the the total cells which
are empty.
Bill H.
On Sat, Oct 3, 2009 at 11:07 AM, boaz <boaz.frank...@gmail.com> wrote:
>
> 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
-~----------~----~----~----~------~----~------~--~---
