CreateWorksheet Method

Creates a new worksheet within the specified Google Spreadsheets feed.

Syntax

[VB.NET]
Public Sub CreateWorksheet()

[C#]
public void CreateWorksheet();

Remarks

The component will create a new worksheet within the spreadsheet specified by SpreadsheetIndex. The items contained within the following properties will be used to create the new worksheet:

• WorksheetTitle
• WorksheetRowCount
• WorksheetColumnCount

If the worksheet was successfully created, the new worksheet will appear as the last worksheet. It is not currently possible to set the order of worksheets via the Google Spreadsheets API (outside of using the GDocuments component to delete and recreate each worksheet).

Upon a successful creation, the response will be parsed and the below listed properties will be populated with the returned values. Thus all previous worksheets contained by the component, prior to the CreateWorksheet call, will be cleared and replaced with the response worksheet data. OtherHeaders will also be cleared and thus will need to be reset accordingly with each call made.

• WorksheetDateUpdated
• WorksheetETag
• WorksheetTitle
• WorksheetProperties