Worksheet.Name Property

Specifies a worksheet name.

Namespace: SpreadsheetCloudAPI.SpreadsheetSDK
Assembly: SpreadsheetSDK.dll

Syntax

C#
VB
public string Name { get; set; }

Property value

Type: String
A string value specifying a worksheet name.

Remarks

You can access a worksheet either by name or by index. To get the worksheet index, use the Index property.

Example

This example demonstrates how to add a new worksheet to a document. To do this, use the Document.CreateWorksheet method.

To create a new worksheet and specify where it should be inserted, call the Document.CreateWorksheet method with the zero-based worksheet index passed as a parameter.

To specify a worksheet name, use the Name property, or pass the worksheet name to the Document.CreateWorksheet method as a parameter.

C#
using System;
using System.Collections.Generic;
using SpreadsheetSDK;

namespace SpreadsheetExample {
    class Program {
        static void Main() {

            // SDK initialization
            SpreadsheetSDK.Initialize("SPECIFY_YOUR_API_KEY_HERE");

            // Access the document that has been uploaded to the server
            Document doc = Document.Load("MyApplicationFile", "xlsx");

            // Add a new worksheet to the document
            // The worksheet will be inserted into the end of the document
            // Worksheet name is "SheetN", where N is a number following the largest number used in existing worksheet names of the same type
            doc.CreateWorksheet();

            // Add a new worksheet under the specified name
            doc.CreateWorksheet().Name = "TestSheet1";
            doc.CreateWorksheet("TestSheet2");

            // Add a new worksheet at the specified position in the collection of worksheets
            doc.CreateWorksheet("TestSheet3", 1);
            doc.CreateWorksheet(3);

            // Terminate the session and save changes
            doc.Close(true);
        }
    }
}

See Also