GrapeCity.SpreadBuilder.Workbook

Workbook Class

Represents a spreadsheet workbook containing spreadsheets. This object represents information that is relevant to all the spreadsheets in the workbook (e.g. author, BIFF/file version, etc...).

Inheritance

object

Workbook

Namespace: GrapeCity.SpreadBuilder

Assembly: MESCIUS.ActiveReports.SpreadBuilder.dll

Syntax

public class Workbook

Constructors

Name	Description
Workbook(Func<string, StringMeasurementParams, SizeF>)	The default constructor for the Workbook class.

Fields

Name	Description
DefaultFontName	Returns the name of the default font.
DefaultFontSizeInPoints	Returns the size of the default font in points.

Properties

Name	Description
FileFormat	Gets or sets the file format in which one the spreadsheet will be saved.
OpenXmlStandard	Gets or sets the level of Open XML document conformance when exporting to the Xlsx file format.
PixelsPerChar	The average width of "0123456789" ten characters. Recommended value is 7.4. Can be set to 7 for legacy sheets. For internal use only.
ProtectWorkBookStructure	Gets or sets the protection status for a sheet or workbook.
ProtectWorkbookPassword	Gets or sets the password to protect the items in the workbook.
ProtectWorkbookWindows	Gets or sets an option from the Protect Workbook dialog box.
Security	Gets a DDSecurity object for initializing document security.
SheetName	Gets or sets a value indicating the name of sheet. Sheet is default.
Sheets	Gets the collection of sheets as a DDSheets collection object.
UseCompression	Gets or sets the value indicating whether compression is used when exporting to the Xlsx file format.
UseDefaultPalette	Gets or sets whether the document is exported with the default Excel palette.

Methods

Name	Description
Clear()	Removes all sheets, creates a new instance of all member class variables, and initializes all member data variables to their default values.
Save(Stream)	Saves the current spreadsheet workbook to the specified Stream.
Save(string)	Saves the current spreadsheet data to the specified stream.