public class

WorksheetEntry

extends BaseEntry<E extends BaseEntry>
java.lang.Object
   ↳ com.google.gdata.data.AbstractExtension
     ↳ com.google.gdata.data.ExtensionPoint
       ↳ com.google.gdata.data.BaseEntry<E extends com.google.gdata.data.BaseEntry>
         ↳ com.google.gdata.data.spreadsheet.WorksheetEntry

Class Overview

One worksheet, when listing all worksheets within a spreadsheet. For instance, this might list Sheet1, Sheet2, Sheet3, etc.

Summary

Constants
String KIND Kind category term used to label the entries that contains worksheet data.
Fields
public static final Category CATEGORY Category used to label entries that contain worksheet data.
[Expand]
Inherited Fields
From class com.google.gdata.data.BaseEntry
From class com.google.gdata.data.ExtensionPoint
From class com.google.gdata.data.AbstractExtension
Public Constructors
WorksheetEntry()
Constructs a new uninitialized entry to be populated by the GData parsers.
WorksheetEntry(int rowCount, int colCount)
Constructs a new entry with the given row count and column count
WorksheetEntry(BaseEntry sourceEntry)
Constructs a new entry by doing a shallow copy from another BaseEntry instance.
Public Methods
void declareExtensions(ExtensionProfile extProfile)
Declares any extensions.
URL getCellFeedUrl()
Gets the URL for this worksheet's cells feed.
int getColCount()
Gets the total number of columns.
URL getListFeedUrl()
Gets the URL for this worksheet's list feed.
int getRowCount()
Gets the total number of rows.
void setColCount(int count)
Sets the total number of columns.
void setRowCount(int count)
Sets the total number of rows.
[Expand]
Inherited Methods
From class com.google.gdata.data.BaseEntry
From class com.google.gdata.data.ExtensionPoint
From class com.google.gdata.data.AbstractExtension
From class java.lang.Object
From interface com.google.gdata.data.Extension
From interface com.google.gdata.data.IAtom
From interface com.google.gdata.data.IEntry
From interface com.google.gdata.data.Kind.Adaptable
From interface com.google.gdata.data.Kind.Adaptor

Constants

public static final String KIND

Kind category term used to label the entries that contains worksheet data.

Constant Value: "http://schemas.google.com/spreadsheets/2006#worksheet"

Fields

public static final Category CATEGORY

Category used to label entries that contain worksheet data.

Public Constructors

public WorksheetEntry ()

Constructs a new uninitialized entry to be populated by the GData parsers.

public WorksheetEntry (int rowCount, int colCount)

Constructs a new entry with the given row count and column count

Parameters
rowCount The number of rows in the worksheet
colCount The number of columns in a worksheet

public WorksheetEntry (BaseEntry sourceEntry)

Constructs a new entry by doing a shallow copy from another BaseEntry instance.

Parameters
sourceEntry

Public Methods

public void declareExtensions (ExtensionProfile extProfile)

Declares any extensions.

Parameters
extProfile The ExtensionProfile to initialize.

public URL getCellFeedUrl ()

Gets the URL for this worksheet's cells feed.

With this feed, you can query for arbitrary ranges of cells.

Returns
  • a URL to the cells feed

public int getColCount ()

Gets the total number of columns. This refers to the hard bound on columns. It is possible that your spreadsheet has many empty columns, all of which are counted in this count. Column positions 1 to getColCount() are valid.

public URL getListFeedUrl ()

Gets the URL for this worksheet's list feed.

You can then create a query using this URL to query this worksheet's rows, using the very powerful query model.

Returns
  • a URL to get a feed of worksheets

public int getRowCount ()

Gets the total number of rows. This refers to the hard bound on rows. It is possible that your spreadsheet has many, many empty rows, all of which are counted in this count. Column positions 1 to getRowCount() are valid.

public void setColCount (int count)

Sets the total number of columns. If the new number of columns is greater than the old, (new-old) blank columns will be appended to the end. If the new number of columns is less than the old, then (old-new) columns will be removed from the end which will DELETE ALL DATE IN DELETED COLUMNS.

Parameters
count The new column count.

public void setRowCount (int count)

Sets the total number of rows. If the new number of rows is greater than the old, (new-old) blank rows will be appended to the end. If the new number of rows is less than the old, then (old-new) rows will be removed from the end which will DELETE ALL DATE IN DELETED ROWS.

Parameters
count The new row count.