SheetName Property

---

See Also    DLL    Example

Applies To

fpSpread control

Description

Sets or returns a string as the sheet name for the specified sheet.

Syntax

CString CSpreadSheet::GetSheetName( );
void CSpreadSheet::SetSheetName(LPCTSTR value);

[form.]fpSpread.SheetName[ = text$]

Remarks

Set the Sheet property to specify the sheet for which you are setting the name before you set the SheetName property. Sheet numbers are one-based.

To set the number of sheets, set the SheetCount property. To specify the active sheet, set the ActiveSheet property.

The SheetName will only display the first 30 characters. Use unique names to avoid issues with formulas and exporting.

Spread Designer

Choose the Sheet menu, then the Sheets menu, and then type a number in the Name edit box in the Sheet Settings dialog box.

Data Type

String

See Also

Setting Sheet Names

ActiveSheet, Sheet, SheetCount properties

DLL Correspondence

SSGetSheetName, SSSetSheetName functions