yeh, you are probably right.
thanks again for your help.
Boaz
On Sun, Oct 4, 2009 at 2:19 AM, Bill Hayes <bhaye...@gmail.com> wrote:
> 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
>>
>>
>
> >
>
--
Boaz Franklin
hubeza - web dev & design
http://www.hubeza.com
mobile: 0546522812
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
