Is this still an issue? I have a worksheet that returns the correct
worksheet title & column count but the rowcount is always 1.
Is this code wrong somehow?
System.out.println("title of ws is "+worksheet.getTitle().getPlainText()+"
row count = "+worksheet.getRowCount()+"colums = "+worksheet.getColCount());
On Thursday, March 17, 2011 6:49:13 AM UTC-6, David Bullock wrote:
>
> Sounds like filing a bug might be in order.
>
> On Mar 6, 2:17 am, Jason Cipriani <[email protected]> wrote:
> > API version 3.0, Java client library version 1.41.1 (according to
> javadocs
> > linked from current Google API reference page).
> >
> > The row and column count given in a worksheet entry generally seems to
> be
> > arbitrarily larger than the actual data bounds in the spreadsheet. For
> > example, I have a spreadsheet with 32 data columns and 23 data rows
> (none
> > blank, data starts at A1) but the reported column count is 68 and row
> count
> > is 122. Retrieving a cell list feed with empty cells enabled yields 36
> blank
> > columns on the right and 99 blank rows on the bottom. I have another
> test
> > spreadsheet with 5 columns and 8 rows (one blank row, data starts at A1)
> and
> > this reports 12 columns and 8 rows.
> >
> > Version 2.0 of the API has the same behavior (observed via PHP Zend
> client
> > library).
> >
> > Why is the row and column count incorrect and how do I retrieve the
> actual
> > data bounds without examining the data?
> >
> > Thanks,
> > Jason
