Search
Workbook Class
Remarks See Also
 






The main document class, contains a collection of worksheets, named ranges and other related objects.

Namespace: com.mindfusion.spreadsheet
Package: com.mindfusion.spreadsheet

 Syntax

Java  Copy Code

public class Workbook
     implements INotifyPropertyValueChanged, ISupportInitialize, Printable

 Remarks

The Workbook class is used to manage a collection of related Worksheet and NamedRange objects, provides undo/redo and formula calculations.

The worksheets of the workbook can be accessed and managed through the Worksheets collection of the Workbook class. Worksheets are added to the workbook indirectly, through the add method of this collection. Respectively, the NamedRange objects of the workbook are managed through the NamedRanges collection.

Undo and redo can be enabled and disabled through the UndoEnabled property. To undo or redo an action, use the undo and redo methods. To check if there is an action to be undone or redone, use the CanUndo and CanRedo properties. When an action is undone or redone, the actionUndone or actionRedone events are raised.

To specify the culture of the workbook and its associated worksheets, use the Locale property. This culture is used when parsing and formatting data in the worksheets. The default of this property is the culture of the current thread.

The workbook can be serialized to and deserialized from a stream or a file through the respective SaveTo* and LoadFrom* methods. For example, to save the workbook to an XML, use one of the saveToXml overloads.

To display a workbook on a form, use the library's WorkbookView control. To export or import a workbook, use the appropriate importer or exporter class - PdfExporter, ImageExporter, CsvExporter, CsvImporter, CalcImporter, and ExcelImporter.

 Inheritance Hierarchy

java.lang.Object
    com.mindfusion.spreadsheet.Workbook

 See Also