[]
        
(Showing Draft Content)

GrapeCity.SpreadBuilder

GrapeCity.SpreadBuilder Namespace

Classes

ColumnCountOutOfRangeException

Thrown when the number of columns is out of range in a certain Excel format.

CompressionException

Indicates that an error has occurred in the compression library, most likely related to images.

DDColumn

Represents a column in a spreadsheet.

DDRow

Represents a single row on a sheet.

DDSecurity

Encapsulates the information required for spreadsheet document security and encryption.

DDSheet

Represents a WorkSheet.

DDSheetNameAlreadyExistsException

DDSheets

A collection of DDSheet objects.

DDSheets.DDSheetsEnumerator

An Enumerator for the DDSheets collection. Allows use of foreach statements.

FormatConverter

This class is a tool for converting AR TextBox's OutputFormat and Value to Excel NumberFormat and Value. AR TextBox's OutputFormat is based on .NET Framework Formatting. See http://msdn.microsoft.com/en-us/library/fbxft59x(v=vs.80) In addition, AR OutputFormat also supports the forth section and _(undersorce). For Excel NumberFormat, see http://www.brainbell.com/tutorials/ms-office/excel/Create_Custom_Number_Formats.htm

InvalidDDSheetNameException

Thrown if the name of a sheet is changed to an invalid value. The name cannot be empty, cannot exceed 31 characters and cannot contain any of the following characters: : \ / ? * [ or ].

InvalidPasswordException

Thrown if the password is invalid in a certain Excel format (for example, the length of the password is out of range).

NoDDSheetsException

It is thrown when an operation is requested that requires at least one sheet in the Sheets collection (for example, when the workbook is saved).

PageBreaks

Collection of horizontal or vertical page breaks.

RowCountOutOfRangeException

Thrown when the number of rows in a particular Excel format is out of range.

SpreadBuilderException

A general exception thrown for application errors in the GrapeCity.SpreadBuilder assembly.

VersionNotImplementedException

The exception that is thrown when a feature or operation is not implemented for a specific version of the Excel/BIFF file format.

Workbook

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...).

Structs

PageBreaks.PageBreak

Excel97DevKit: The cbrk field contains the number of page breaks. Each element of the rgbrk structure contains three 2-byte integers: the first specifies the row (or col for vertical) of the break, the second specifies the starting column (or row for vertical), and the third specifies the ending column (or row for vertical) for the break. All row and column numbers are 1-based, and the breaks occur after the row or column. This array is sorted by row, and then by starting/ending column. No two page breaks may overlap.

StringMeasurementParams

Represents the parameters for text measurement

Enums

FileFormat

Specifies the file format that the outputted file should support.

OpenXmlStandard

Specifies the level of conformance of the Open XML document when exporting to the Xlsx file format.