ExpertXls Excel Library for .NET
ExcelWorkbook Class
Namespaces ► ExpertXls.ExcelLib ► ExcelWorkbook
ExpertXls Excel Library for .NET
The Excel Workbook
Declaration Syntax

C# | Visual Basic | Visual C++

    public class ExcelWorkbook

    Public Class ExcelWorkbook

    public ref class ExcelWorkbook

Members

All Members | Constructors | Methods | Properties
Public Protected | Instance Static | Declared Inherited

Icon | Member | Description
--- | --- | ---
| ExcelWorkbook()()() | Creates a workbook with a single worksheet. The default workbook format is Excel 2003. To create a workbook for a different Excel format, like Excel 2007, you can use the constructor with the Format parameter.
| ExcelWorkbook(ExcelWorkbookFormat) | Creates a workbook with a single worksheet. The format of the workbook is specified by the workbookFormat parameter. The currently supported formats are Excel 97-2003 format and Excel 2007 format.
| ExcelWorkbook(ExcelWorkbookFormat, ExcelWorkbookDefaultSettings) | Creates a workbook with a single worksheet. The format of the workbook is specified by the workbookFormat parameter. The currently supported formats are Excel 97-2003 format and Excel 2007 format.
| ExcelWorkbook(String) | Opens a workbook from the specified Excel file
| ExcelWorkbook(String, String) | Opens a workbook from the specified Excel file with the specified password
| ExcelWorkbook(String, String, ExcelWorkbookDefaultSettings) | Opens a workbook from the specified Excel file with the specified password
| ExcelWorkbook(Stream) | Opens a workbook from the specified Excel stream
| ExcelWorkbook(Stream, String) | Opens a workbook from the specified Excel stream with the specified password
| ExcelWorkbook(Stream, String, ExcelWorkbookDefaultSettings) | Opens a workbook from the specified Excel stream with the specified password
| ActiveSheetIndex | Gets or sets the active sheet index. The index is zero based. The property can be set with a non-negative value. Returns a negative value when no sheet is active in the workbook.
| ChartWorksheets | Gets the collection of chart worksheets of this workbook.
| Close()()() | Closes the workbook and releases all the resources.
| DefaultColumnWidthChars | Gets default column width in characters for the newly created worksheets.
| DefaultFontName | Gets or sets default font name for the newly created worksheets.
| DefaultFontSizePoints | Gets or sets default font size in points for the newly created worksheets.
| DefaultRowHeightPoints | Gets the default row height in points for the newly created worksheets.
| DocumentProperties | Gets the object encpsulating the document properties like author, title, subject, etc.
| DocumentSecurity | Gets an object used to manage the document security like workbook structure and windows protection, workbook open/write password protection. Works only for Excel 2003 .xls format.
| Equals(Object) | Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
| Finalize()()() | Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (Inherited from Object.)
| Format | Gets or sets the Excel workbook format (Excel 97-2003 .xls or Excel 2007 .xlsx). This property gives the output format when the workbook is saved and controls the features allowed when the workbook is updated by the library. When creating an empty workbook the format is Excel 97-2003. When the workbook is created from an existing excel file or stream, the format is the format of the opened excel document.
| FormulaNumberFormat | Gets or sets the number format in formula used when parsing formulas. Set this propery before assigning a formula expression to a cell. The default value is the number format for the current culture.
| FormulaParamsSeparator | Gets or sets the separator between formula parameters used when parsing formulas. Set this propery before assigning a formula expression to a cell. The default value is ','.
| FormulaRowsSeparator | Gets or sets the rows separator used when parsing arrays in formulas. Set this propery before assigning a formula expression to a cell. The default value is ';'
| GetHashCode()()() | Serves as a hash function for a particular type. (Inherited from Object.)
| GetType()()() | Gets the Type of the current instance. (Inherited from Object.)
| LicenseKey | Gets or sets the license key for the library. When this property is set to null value the library works in demo mode.
| LoadFromCsv(String, String, ExcelWorkbookFormat) | Loads a CSV file into a worksheet. The default encoding of the text in CSV is assumed to be UTF-8. The values from CSV will be imported in the top left corner of the worksheet.
| LoadFromCsv(String, Encoding, String, Int32, Int32, ExcelWorkbookFormat, ExcelWorkbookDefaultSettings) | Loads a CSV file into a worksheet.
| LoadFromCsv(Stream, String, ExcelWorkbookFormat) | Loads a CSV stream into a worksheet. The default encoding of the text in CSV is assumed to be UTF-8. The values from CSV will be imported in the top left corner of the worksheet.
| LoadFromCsv(Stream, Encoding, String, Int32, Int32, ExcelWorkbookFormat, ExcelWorkbookDefaultSettings) | Loads a CSV stream into a worksheet.
| MemberwiseClone()()() | Creates a shallow copy of the current Object. (Inherited from Object.)
| NamedRanges | Gets the named ranges collection of this workbook (Workbook scope named ranges).
| Palette | Gets the colors palette of the workbook.
| ReadOnly | Gets a value that indicates whether the workbook has been opened as read-only
| Save()()() | Saves the Excel workbook as byte array that can be further saved into a file or send over HTTP. The output format (Excel 97-2003 .xls or Excel 2007 .xlsx) is the current format of the workbook.
| Save(String) | Saves the workbook as the specified file. The output format (Excel 97-2003 .xls or Excel 2007 .xlsx) is the current format of the workbook.
| Save(Stream) | A Saves the workbook in the specified stream. The output format (Excel 97-2003 .xls or Excel 2007 .xlsx) is the current format of the workbook.
| Save(HttpResponse, String) | Saves the workbook to the specified HttpResponse. The output format (Excel 97-2003 .xls or Excel 2007 .xlsx) is the current format of the workbook.
| Save(HttpResponse, String, Boolean) | Saves the workbook to the specified HttpResponse. The output format (Excel 97-2003 .xls or Excel 2007 .xlsx) is the current format of the workbook.
| SaveToCsv(Int32, String, String) | Saves the worksheet at the specified index to a file in CSV format. The default UTF-8 text encoding is used when saving the output file.
| SaveToCsv(Int32, String, String, Encoding) | Saves the worksheet at the specified index to a file in CSV format using the specified text encoding for the output file.
| SaveToCsv(Int32, Stream, String) | Saves the worksheet at the specified index to a stream in CSV format. The default UTF-8 text encoding is used when saving the output stream.
| SaveToCsv(Int32, Stream, String, Encoding) | Saves the worksheet at the specified index to a stream in CSV format using the specified text encoding for the output.
| SerializeDefaultColumnWidth | A flag indicating if the DefaultRowHeightPoints property should be serialized or not when the the format is Xls_2007.
| SerializeDefaultRowHeight | A flag indicating if the DefaultRowHeightPoints property should be serialized or not when the the format is Xlsx_2007.
| Styles | Gets the cell styles collection of this workbook.
| ToString()()() | Returns a String that represents the current Object. (Inherited from Object.)
| UnitsConverter | Gets an object used to convert values between various Excel measurement units (points, pixels, width characters)
| UpdateFormulaResult()()() | Calculate formula results for all the worksheets in the workbook
| Worksheets | Gets the worksheets collection of this workbook.

Inheritance Hierarchy

Object
| ExcelWorkbook

Assembly: ExpertXls.ExcelLib (Module: ExpertXls.ExcelLib) Version: 2.1.0.0 (2.1.0.0)