Name Property (Worksheet)

Visual Basic
C#

'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property Name As System.String

'Usage
 
Dim instance As Worksheet
Dim value As System.String
 
instance.Name = value
 
value = instance.Name

[System.ComponentModel.DefaultValue()]
public System.string Name {get; set;}

Property Value

The name of the sheet.

This example sets the Name property and uses it when printing to PDF.

C#

string fileName;
fileName = "c:\\zipfile\\test.pdf";
System.IO.Stream stream;
stream = System.IO.File.Create(fileName);

 gcSpreadSheet1.Workbook.Name = "WorkBook";
 gcSpreadSheet1.Sheets[0].Name = "Sheet 0";
GrapeCity.Windows.SpreadSheet.Data.PrintInfo printtest;
printtest = gcSpreadSheet1.Sheets[0].PrintInfo;
printtest.FooterCenter = "This is Page &P";
printtest.HeaderCenter = "&A of &F";
printtest.BestFitColumns = true;
printtest.UseMax = true;

GrapeCity.Windows.SpreadSheet.Data.PdfExportSettings test;
test = new GrapeCity.Windows.SpreadSheet.Data.PdfExportSettings();
test.Title = "Print PDF";
test.Author = "GrapeCity, Inc.";
test.DisplayDocTitle = true;
test.FitWindow = true;
gcSpreadSheet1.SavePDF(stream, test, 0);

VB.NET

Dim fileName As String
fileName = "c:\zipfile\test.pdf"
Dim stream As System.IO.Stream
stream = System.IO.File.Create(fileName)

GcSpreadSheet1.Workbook.Name = "WorkBook"
GcSpreadSheet1.Sheets(0).Name = "Sheet 0"
Dim printtest As GrapeCity.Windows.SpreadSheet.Data.PrintInfo
printtest = GcSpreadSheet1.Sheets(0).PrintInfo
printtest.FooterCenter = "This is Page &P"
printtest.HeaderCenter = "&A of &F"
printtest.BestFitColumns = True
printtest.UseMax = True


Dim test As GrapeCity.Windows.SpreadSheet.Data.PdfExportSettings
test = New GrapeCity.Windows.SpreadSheet.Data.PdfExportSettings()
test.Title = "Print PDF"
test.Author = "GrapeCity, Inc."
test.DisplayDocTitle = True
test.FitWindow = True
GcSpreadSheet1.SavePDF(stream, test, 0)

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

Reference

Worksheet Class
Worksheet Members