Return to previous page Explore Spreadsheet SDK

Workbook Class

Free Trial Web API version Licensing Request A Quote

HAVE QUESTIONS OR NEED HELP?SUBMIT THE SUPPORT REQUEST FORM or write email toSUPPORT@BYTESCOUT.COM

Workbook class

Inheritance Hierarchy

SystemObject
Bytescout.SpreadsheetWorkbook

Namespace:Bytescout.Spreadsheet
Assembly: Bytescout.Spreadsheet (in Bytescout.Spreadsheet.dll) Version: 4.7.0.2045-master

Syntax

C++

Copy

[TypeConverterAttribute(typeof(ExpandableObjectConverter))]
public class Workbook : IWorkbook

<TypeConverterAttribute(GetType(ExpandableObjectConverter))>
Public Class Workbook
	Implements IWorkbook

[TypeConverterAttribute(typeof(ExpandableObjectConverter))]
public ref class Workbook : IWorkbook

[<TypeConverterAttribute(typeof(ExpandableObjectConverter))>]
type Workbook =  
    class
        interface IWorkbook
    end

The Workbook type exposes the following members.

Properties

	Name	Description
	AddInFunctionsNamesLocale	Gets or sets the add in functions names locale.
	AutoCalculation	Gets or sets a value indicating if formula should be re-calculated automatically on change of cells value.
	Charts	Gets the charts.
	Colors	Gets the colors in the user-defined palette. The palette has 56 entries.
	DefaultFont	Gets or sets the workbook default font.
	DocumentProperties	Document Properties
	EncryptionKeyLength	Gets or sets value that specifies the number of bits in the encryption key. Must be a multiple of 8.
	EncryptionType	Gets or sets the type of the encryption.
	ExternalReferenceUpdate	Gets or sets a value indicating whether external reference should be updated or not.
	Locale	Gets or sets the CultureInfo using in Workbook. This property should be used to set the locale (regional) settings for use in the new workbook (number, currency, time, date formatting). When you load existing spreadsheet then the SDK tries to use the saved locale settings for this file disregarding current Windows regional and language settings. When new workbook is created then the current Windows locale is used by default.
	Names	Gets collection of the DefinedName objects.
	Password	Sets the password to use for encryption file.
	PictureList
	Properties	Workbook properties
	ProtectStructure	Gets or sets a value indicating whether the order of the sheets in the workbook is protected.
	ProtectWindows	Gets or sets a value indicating whether the windows of the workbook are protected.
	RangeSelectionMethod	Gets or sets the range selection method.
	ReadOnlyRecommended	Gets or sets a value indicating whether the workbook is read only recommended.
	WorkbookView
	Worksheets	Gets the worksheets.

Top

Methods

	Name	Description
	Calculate	Calculates the all formulas in the Workbook.
	Equals	Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
	Finalize	Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
	GetHashCode	Serves as a hash function for a particular type. (Inherited from Object.)
	GetType	Gets the type of the current instance. (Inherited from Object.)
	MemberwiseClone	Creates a shallow copy of the current Object. (Inherited from Object.)
	Protect	Protects the workbook.
	ProtectFromModifications	Protects the workbook from modifications (read only recommended).
	RemovePassword	Removes the password.
	ToString	Returns a string that represents the current object. (Inherited from Object.)
	UnProtect	Removes protection from the workbook.

Top

Reference

Bytescout.Spreadsheet Namespace