gembox workbook must contain at least one worksheet.

Gembox workbook must contain at least one worksheet. how to#

Style can either be built-in or user-defined. IsDefault - true if Name Style is default ( Normal) and there are no additional modifications of cell formatting otherwise, false.ĮxcelFile contains a set of Styles which can be referenced by multiple cells.ĮxcelFile must always contain at least one Style which cannot be removed and is, by default, referenced by all cells.QuotePrefix - true to store numeric value of a cell as text otherwise, false.Associated properties are Locked and FormulaHidden.Īdditional CellStyle properties not associated with any formatting group are: Protection - contains protection properties associated with the cell.Fill - specifies fill formatting (pattern or gradient).Border - expresses a single set of cell border formats (left, right, top, bottom and diagonal).Font - defines the properties for the used font.Associated properties are HorizontalAlignment, VerticalAlignment, Indent, Rotation, IsTextVertical, WrapText and ShrinkToFit. Alignment - formatting information pertaining to text alignment in cells.

Gembox workbook must contain at least one worksheet. how to#

Number - indicates how to format and render the numeric value of a cell.

Property IsCalculated tells if an item is calculated.Ĭonceptually, cell formatting is divided into following groups: Calculated PivotItem can be added using a AddCalculated(String, String) method and removed using a RemoveCalculated(String) method. Calculated PivotField is automatically moved to a Values Area ( DataFields collection) and only Values Area can contain calculated PivotFields. Property IsCalculated tells if a field is calculated or is a field from the data source. Calculated PivotField can be added using a AddCalculated(String, String) method and removed using a RemoveCalculated(String) method.

Values Area represented by DataFields collection.Įach (non-calculated) PivotField can contain zero or more PivotItems which are used for filtering and grouping by a specific value.Įxcept using fields defined in Pivot Table data source (more precisely, in PivotCache) which cannot be removed, Pivot Table can also define calculated PivotFields and calculated PivotItems which use a formula to specify their values.

Column Axis represented by ColumnFields collection.

Row Axis represented by RowFields collection.Report Filter Area represented by PageFields collection.PivotTable contains the PivotFields collection which PivotField elements can be Add(Int32) into the following Pivot Table areas:

PivotTable is created from a PivotCache with the specified name and the specified cell in the worksheet where it is placed using the Add(PivotCache, String, String) method. PivotCache can be refreshed by using the Refresh() method. PivotCache instances are stored in a PivotCaches collection.

Cache source is represented with a PivotCacheSource type (and its sub-types) and can be accessed from a CacheSource property. GemBox.Spreadsheet represents cache with a PivotCache type. Cache is used to provide better performance of Pivot Table functionality which requires frequent access to data records and their values and to enable sharing the same data source between multiple Pivot Tables. Cache of a data source contains an in-memory copy of data source scheme and, optionally, data and is stored in a workbook which may contain multiple caches of various sources of data.Ĭache can be updated/refreshed from a data source automatically (for example, when opening a workbook) or on request. Pivot Table does not directly reference its data source, but instead it references a cache of a data source.

Scheme - data source fields/columns, its data types, etc.

Source of the data for Pivot Table contains following information: GemBox.Spreadsheet currently supports creating only WorksheetSource.Īll other sources are supported through preservation (to correctly round-trip to XLSX format).