FlexCel.Core Namespace

Core types and utilities used by FlexCel. If you are creating a VCL application, you need to use VCL.FlexCel.Core at least once in your app.

For FireMonkey apps, you need to use FMX.FlexCel.Core at least once.

For Linux, use SKIA.FlexCel.Core.

You will normally use this in the platform dependent units in your app. For your units which could be used from any platform, you can simply use FlexCel.Core.

Classes

Name	Description
EFlexCelCoreException	Exception thrown when an exception on the core engine happens.
EFlexCelException	Exception thrown when an specific FlexCel error happens. Base of all FlexCel hierarchy list.
TAlphaModFixBlipTransform	Represents a transform that changes the opacity of the image.
TAxisLineOptions	Line options for an Axis.
TAxisRangeOptions	Properties for the ranges of an axis.
TAxisTickOptions	Properties for the ticks and labels of an axis.
TBaseAxis	Common ancestor for all Axis types.
TBlipFillMode	This class is designed to store tiling or stretching fill mode information. You need to use any of its descendants, TBlipFillStretch or TBlipFillTile
TBlipFillStretch	This element specifies that a BLIP should be stretched to fill the target rectangle. The other option is a tile where a BLIP is tiled to fill the available area.
TBlipFillTile	This element specifies that a BLIP should be tiled to fill the available space. This element defines a "tile" rectangle within the bounding box. The image is encompassed within the tile rectangle, and the tile rectangle is tiled across the bounding box to fill the entire area.
TBlipTransform	Represents a simple transformation applied to an image. You should use the descendants of this class, not this class directly.
TBlipTransformList	A list with TBlipTransforms.
TBlurEffect	A blur effect applied to the whole shape.
TCategoryAxis	Information about an Axis of categories. (normally the x axis)
TChartDropBars	Information about a Drop Bar.
TChartErrorBars	Information about an Error Bar.
TChartOneDropBar	Information about one specific drop bar.
TChartSeriesMarkerOptions	Marker options for the whole series or a point in the series when the chart is line or scatter.
TChartSeriesMiscOptions	Misc options for the whole series or a point in the series that do no enter in any other category.
TChartSeriesOptions	Options for the whole series or for a data point inside it.
TChartSeriesPieOptions	Pie options for a series or a slice of the series when the chart is a pie chart.
TChartTitle	Represents the title of the chart.
TChartWallOptions	Fill and Line options for the walls and floor of a 3D chart.
TCmsSigner	Represents an abstract class to create a pdf PKCS7 DER encoded signature. Descend from this class to create your own SignerFactory implementations.
TColorChangeBlipTransform	Represents a color transformation from one color to another. This transform can be used to make a color transparent.
TConditionalFormatColorList	A list of conditional value colors.
TConditionalFormatDef	The format to apply when a IConditionalFormatRule is applied.
TConditionalFormatDefColorScale	Defines a format of the color scales in a conditional format.
TConditionalFormatDefDataBar	Defines a format of the databars in a conditional format.
TConditionalFormatDefIconSet	Defines a format of the color scales in a conditional format.
TConditionalFormatDefStandard	Defines a format to apply for cells when a rule evaluates to true.
TConditionalFormatValueAndColorList	A list of conditional value objects with their corresponding colors.
TConditionalFormatValueList	A list of conditional value objects.
TConditionalFormatValueObject	Describes an interpolation point in a gradient scale.
TCustomTableStyleSection	Represents the format of a table section (header, totals, etc).
TDataBarColors	Colors which define the databar.
TDataConnection	This class represents one data connection on the workbook.
TDataConnectionDbProperties	This element stores all properties associated with an ODBC or OLE DB external data connection.
TDataConnectionOlapProperties	This element contains all the properties needed for an OLAP data connection. OLAP connections contain both the TDataConnectionDbProperties and TDataConnectionOlapProperties child elements.
TDataConnectionParameter	This element stores properties about any parameters used with external data connections. Parameters are used to change the query executed externally and cause different data to be retrieved into the workbook.The type of parameter used determines whether the user is prompted for a value before data is refreshed, or the value is pulled from a cell in the workbook, or whether the same value should be used until explicitly changed in the data connection. Parameters are permitted for ODBC and web queries.
TDataConnectionParameters	A list of TDataConnectionParameter.
TDataConnectionTable	Specifies the HTML table to import.
TDataConnectionTables	Collection of HTML tables in a web query connection.
TDataConnectionTextField	This element specifies field settings for text import.
TDataConnectionTextFields	Collection of fields in the Text connection.
TDataConnectionTextImportProperties	This element contains all of the text import settings.
TDataConnectionWebQueryProperties	This element specifies the properties for a web query source. A web query will retrieve data from HTML tables, and can also supply HTTP "Get" parameters to be processed by the web server in generating the HTML by including the parameters and parameter elements.
TDataLabelOptions	Options for a data label.
TDocumentProperties	Properties for an Excel sheet.
TDrawingEffect	Base class for all drawing effects, like TBlurEffect or TGlowEffect
TDrawingGradientDef	A base class for storing gradient definitions, be them Linear or Path gradients.
TDrawingLinearGradient	This class holds a linear gradient definition.
TDrawingPathGradient	Holds a Path gradient definition.
TEffectContainer	This class encapsulates a node of the effect DAC.
TEffectList	This class holds a list of effects that are applied to a drawing.
TEffectStyle	A class encapsulating a style including 3D styles.
TEffectStyleList	A list with all the effects for subtle, moderate and intense formatting types.
TEncryptionFactory	This class encapsulates what we need to support encryption routines. You can derive from this class and override the methods to return your own encryption classes. then you need to assign the static variable EncryptionFactory to your descendant class, and FlexCel will then use the new classes.
TExcelFile	Interface a FlexCel engine has to implement to be used by the other components in the suite like TFlexCelReport or TFlexCelPdfExport.
TExcelObjectList	A list that contains the Ids and positions of the Excel objects
TFillOverlayEffect	A fill overlay effect.
TFillStyleList	Represents the fill style characteristics for an autoshape.
TFlexCelErrorInfo	This class contains generic information about a non fatal error that happened in FlexCel. Children classes might contain more information specific to the error type.
TFlexCelFormatSettings	This class allows customization of the numeric formats FlexCel uses to display, either globally for all instances or by thread.
TFontCreatedEventArgs	Arguments passed in FontCreated events.
TFontCreatingEventArgs	Arguments passed in FontCreating events.
TFontCreationEventArgs	Base class for font creation events.
TGlowEffect	A glow effect.
THtmlFontEventArgs	Arguments passed on FlexCel.Render.FlexCelHtmlExport.OnHtmlFont.
THtmlParsedString	An Html string parsed into a C# string and tags.
THtmlSaveSharingViolationError	This class has information for a TFlexCelError.HtmlSaveSharingViolation error. Look at TFlexCelError.HtmlSaveSharingViolation for more information.
TImplementedFunction	Data of an implemented formula function.
TImplementedFunctionList	Holds a list of currently implemented formula functions on FlexCel.
TInnerShadowEffect	An inner shadow effect.
TLegendEntryOptions	Description of one particular entry on the Legend box.
TLegendOptionsList	A list of options for the legend on the whole series and for specific data points inside these series.
TLineStyleList	Represents the line style characteristics.
TLoadLinkedFileEventArgs	Arguments passed on TWorkspace.LoadLinkedFile
TMalformedUrlError	This class has information for a TFlexCelError.MalformedUrl error. Look at TFlexCelError.MalformedUrl for more information.
TMimeWriter	A simple class used to create MIME formatted messages. While it does not provide much functionality, it gives enough to create simple multipart archives.
TObjectTextProperties	Specifies properties for the text in an autoshape or object.
TOnPasswordEventArgs	Use this class to supply a password to open an encrypted file.
TOnSheetNameEventArgs	Arguments passed on a OnSheetName event.
TOuterShadowEffect	An outer shadow effect.
TPdfCorruptFontInFontFolderError	This class has information for a TFlexCelError.PdfCorruptFontInFontFolder error. Look at TFlexCelError.PdfCorruptFontInFontFolder for more information.
TPdfFauxBoldOrItalicsError	This class has information for a TFlexCelError.PdfFauxBoldOrItalics error. Look at TFlexCelError.PdfFauxBoldOrItalics for more information.
TPdfFontLicenseDoesntAllowEmbeddingError	This class has information for a TFlexCelError.PdfFontLicenseDoesntAllowEmbedding error. Look at TFlexCelError.PdfFontLicenseDoesntAllowEmbedding for more information.
TPdfFontNotFoundError	This class has information for a TFlexCelError.PdfFontNotFound error. Look at TFlexCelError.PdfFontNotFound for more information.
TPdfGlyphNotInFontError	This class has information for a TFlexCelError.PdfGlyphNotInFont error. Look at TFlexCelError.PdfGlyphNotInFont for more information.
TPdfUsedFallbackFontError	This class has information for a TFlexCelError.PdfUsedFallbackFont error. Look at TFlexCelError.PdfUsedFallbackFont for more information.
TPresetShadowEffect	Applies a preset shadow effect.
TProtection	Encryption data for an Excel sheet.
TRecoveryInvalidFormat	This error happens when in recovery mode and a format has invalid data.
TRecoveryInvalidFormulaTokens	This error happens when in recovery mode and a formula has invalid data.
TRecoveryInvalidNameError	This error happens when in recovery mode and a name has to be ignored because it can't be read.
TReflectionEffect	Applies a reflection effect.
TRenderCorruptImageError	This class has information for a TFlexCelError.RenderCorruptImage error. Look at TFlexCelError.RenderCorruptImage for more information.
TRenderErrorDrawingImageError	This class has information for a TFlexCelError.RenderErrorDrawingImage error. Look at TFlexCelError.RenderErrorDrawingImage for more information.
TRenderGenericPreviewError	This class has information for a TFlexCelError.RenderGenericPreview error. Look at TFlexCelError.RenderGenericPreview for more information.
TRenderMetafileError	This class has information for a TFlexCelError.RenderMetafile error. Look at TFlexCelError.RenderMetafile for more information.
TReplaceAction	Specifies actions to do in every replacement.
TSeriesOptionsList	A list of options for the whole series and for specific data points inside these series.
TSoftEdgesEffect	Applies a soft edges effect.
TTableFormat	Defines a custom format for a table.
TThemeFont	Represents either a major or a minor font for the theme.
TToken	This class and all its descendants represent a token in a formula. You can use these classes to modify formulas without having to parse the text in them, which can be a difficult task.
TTokenCellAddress	A single cell address in the same sheet or to other sheet. See also TTokenCellRange, TTokenRelativeCellAddress, TTokenRelativeCellRange for other tokens that can contain addresses.
TTokenCellRange	A range of cells. See TTokenCellAddress for single cell references.
TTokenData	Constant data, like "Hello" and 1 in the formula: "=IF(A1 = 1,,"Hello")"
TTokenDataArray	Array of Constant data, like "Hello" and 1 in the formula: "=IF(A1 = 1,,"Hello")"
TTokenFunction	A function like "Sum" or "If"
TTokenMissingArgument	A missing argument for a function. For example the second parameter in the formula: "=IF(A1 = 1,,"Hello")"
TTokenName	A named range
TTokenOperator	An operator like "+" or "-"
TTokenParenthesis	A parenthesis surrounding the last token. Note that this token is not used in the formula (since RPN doesn't need parenthesis) but it is there so Excel can display them.
TTokenRangeOp	An operator that operates in ranges, like union or intersection.
TTokenReferenceError	This token represents an error like #REF!
TTokenRelativeCellAddress	A single cell address in the same sheet or to other sheet. It handles a reference relative to the current cell. So a reference in Cell A4 of RowOffset = -1 and ColOffset = 3 would mean the cell D3.
TTokenRelativeCellRange	A range of cells with relative references. This is used mostly in named ranges.
TTokenStructuredReference	A reference for a cell in a table. For example the reference in the formula =SUM(Table1[[#All],[SomeColumn]])
TTokenUnsupported	This token is not supported by FlexCel.
TTokenWhitespace	Whitespace like " ". This is not used in calculation, but it is use by Excel to show the formula as it was entered.
TUdfEventArgs	Encapsulates the parameters to send to an User Defined Function for evaluation.
TUIBrush	A base brush for painting.
TUIColorBlend	Defines a complex gradient by using an array of TUIGradientStop
TUIFont	Represents a font used for drawing in a pdf/gdi+/wpf/winrt canvas. This class might hold resources which need disposing.
TUIGraphics	This class represents a native canvas for drawing.
TUIHatchBrush	A class representing a platform independent hatch brush.
TUIImage	A platform independent image.
TUIImageAttributes	Platform independent image attributes.
TUILinearGradientBrush	Represents a platform independent linear gradient.
TUIMultiPageSaver	This class is used to carry information when saving multi page images, like for example a multipage tiff.
TUIPathGradientBrush	A platform-independent Path gradient implementation.
TUIPen	A pen used to draw into a canvas.
TUISolidBrush	A solid brush with a single color.
TUITextureBrush	A brush using an image as a pattern.
TUnknownBlipTransform	Represents a color transform that FlexCel currently doesn't know about.
TUnsupportedFormula	An unsupported formula, the cell it is in, and the reason why it is not supported.
TUnsupportedFormulaList	A list of unsupported formulas on a sheet.
TUserDefinedFunction	Inherit from this class to create your own user defined functions. Make sure you read 'Using Excel's user defined functions (UDF)' in the Api Developer Guide to get more information on what user defined functions are and how they are created.
TValueAxis	Information about an Axis of values. (normally the y axis)
TVirtualCellEndReadingEventArgs	Arguments passed in the event.
TVirtualCellReadEventArgs	Arguments passed in the event.
TVirtualCellStartReadingEventArgs	Arguments passed in the event.
TWorkspace	This class links together a group of spreadsheets, so you can recalculate among linked spreadsheets. In order to use it, just define an object of this class and add all the files you need for the linked recalculation. If you don't know in advance which files you will need, you can use the TWorkspace.LoadLinkedFile event. Note that whenever you recalculate any file in the workspace, all files will be recalculated, so you don't need to calculate them twice.
TX509Certificate2	Represents an abstract class to hold a certificate. Descend from this class to create your own SignerFactory implementations.
TXlsTooManyPageBreaksError	This class has information for a TFlexCelError.XlsTooManyPageBreaks error. Look at TFlexCelError.XlsTooManyPageBreaks for more information.
TXlsxInvalidNameError	This class has information for a TFlexCelError.XlsxInvalidName error. Look at TFlexCelError.XlsxInvalidName for more information.
TXlsxMissingPartError	This class has information for a TFlexCelError.XlsxMissingPart error. Look at TFlexCelError.XlsxMissingPart for more information.
TXmlMapDataBinding	Specifies how the XML binding works.
TXmlMapMap	Defines the XML Map.
TXmlMapSchema	Stores the schemas for a particular XML map object. There can be multiple Schema elements in a workbook, one for each XML map.

Records

Name	Description
ARGB	Represents a color used to draw in a canvas (gdi+, wpf, etc) in a way that is independent of the drawing framework.
Colors	A list of standard colors.
TAdaptativeFormats	Information about characters in a numeric format that need to be adapted when rendering. For example, if the cell A1 has value 1 and format "*_0" it will print as "______1" when the cell is wide, and as "_1" when the cell is shorter.
TAddress	Used to summarize a range of cells. This class is for internal use.
TAverageValue	This class is for internal use. It is used to calculate an average over a range of cells.
TCachedFontWidth	A font size cached for speed.
TCellAddress	Small class that can convert between a string reference ("A1") into row and col integers (1,1).
TCellAddressRange	A class with 2 TCellAddress objects marking the start and end of a cell range.
TCellAddressWithFileName	Encapsulates a cell address and the file where the cell is stored.
TCellMergedState	This struct is used in TExcelFile.CellMergedNext to keep track of the next merged cell that will be iterated.
TCellValue	Represents a value inside a cell.
TCharAndPos	A simple structure containing a position and a character.
TChartPlotAreaPosition	Defines the rectangle where a chart element is positioned.
TChartRelativeRectangle	A rectangle used in charts that is relative to a parent rectangle. The coordinates of the rectangle go between 0 and 1 where 0 means 0%% of the coordinate of the parent, and 1 means 100%%.
TChartStyle	This structure defines the default style of a chart. Excel defines 48 default styles.
TChildAnchor	A class to hold the offsets relative to the parent on grouped shapes.
TClientAnchor	Image Anchor information.
TColorTransform	Specifies a color transformation to be applied to a color.
TColumnBlock	This class represents a block of columns with the same formatting, options and width.
TCondFmtApplyBorders	Determines which parts of the borders will be applied in the conditional format.
TCondFmtApplyFill	Determines which parts of the pattern will be applied in the conditional format.
TCondFmtApplyFont	Determines which parts of the font will be applied in the conditional format.
TCondFmtBorders	Determines which parts of the borders will be applied in the conditional format.
TCondFmtFont	Determines which parts of the font will be applied in the conditional format.
TConditionalFormat	This class encapsulates a list of conditional formats for a range of cells.
TConditionalFormatCustomIconDef	This structure holds a single icon from an specific icon set.
TCropArea	Defines a cropping area for an image. If the values are not zero, only a part of the image will display on Excel.
TCustomXmlPart	Implements a custom XML part as described in https://msdn.microsoft.com/en-us/library/bb608618.aspx
TDataValidationInfo	Contains the information to define a data validation in a range of cells.
TDocumentCustomProperty	Encapsulates a custom property of an Excel file.
TDrawingColor	Represents a Color for a drawing or a theme. Different from TExcelColor, this structure is defined in terms of DrawingML, not SpreadsheetML.
TDrawingConditionalFormatDataBar	Defines the characteristics of a conditional format data bar which is going to be rendered on the screen or to a file. It is used for exporting xls/x files to drawings or pdf.
TDrawingConditionalFormatIconSet	Defines the characteristics of a conditional format icon which is going to be rendered on the screen or to a file. It is used for exporting xls/x files to drawings or pdf.
TDrawingCoordinate	A coordinate in a drawing.
TDrawingGradientStop	Represents one of the points in a Gradient definition for a drawing (autoshapes, charts, etc). Note that Excel cells use a different Gradient definition: TGradientStop
TDrawingHyperlink	Specifies an hyperlink in a drawing. While this class is similar to THyperlink for links in cells, it has some differences.
TDrawingParagraphProperties	Properties of a text paragraph inside a drawing.
TDrawingPoint	A point with x and y coordinates.
TDrawingRelativeRect	A rectangle with coordinates used in a drawing.
TDrawingRichString	A rich string used in drawings. It is similar to TRichString but it has more properties like for example wordart properties. Similar to a string, this class is immutable.
TDrawingTextAttributes	Group of simple attributes for text properties.
TDrawingTextParagraph	A paragraph in the text inside a drawing. This struct is immutable.
TDrawingTextProperties	Properties of a text run inside a drawing.
TDrawingTextRun	A rich formatting run used in text inside of a drawing. This struct is immutable.
TDrawingUnderline	Specifies the Fill style and line style of underlined text, when it is underlined.
TExcelColor	Represents an Excel color. Colors in Excel can be defined in four ways: Automatic Colors, Indexed Colors (for compatibility with Excel 2003 or older), Palette colors, and RGB colors. This Structure is immutable, once you create it you cannot change its members. You need to create a new struct to modify it.
TExcelFont	Utility methods to create normal fonts from Excel ones.
TExcelMetrics	Returns Information to convert between standard units and Excel units.
TExcelTypes	Manages converting from/to objects/Native excel types.
TFlexCelConfig	A central point of for configuring FlexCel parameters.
TFlexCelDataFormats	Excel formats to copy/paste to/from the clipboard
TFlexCelTrace	This class reports al FlexCel non-fatal errors. Use it to diagnose when something is going wrong.
TFlexCelWriter	Encapsulates a generic writer. This record converts automatically from a TStreamWriter or a TFlexCelStreamWriter, so you can use both when a FlexCel method requires a TFlexCelWriter.
TFlxApplyBorders	Border style for a cell.
TFlxApplyFillPattern	Fill pattern and color for the background of a cell.
TFlxApplyFont	Encapsulation of an Excel Font.
TFlxApplyFormat	Defines which attributes of a TFlxFormat will be applied for one cell. Whatever member is set to false, it will not apply this member property to the cell.
TFlxBorders	Border style for a cell.
TFlxChartFont	A TFlxFont with Scaling factor. Scaling factor might be different than 1 if the chart has Autosize Fonts. To get the real value of the font, you need to multiply by the factor.
TFlxConsts	Utility methods and constants usable anywhere.
TFlxDateTime	Use this class to convert between a Date expressed on Excel format (a double) and a TDateTime.
TFlxFillPattern	Fill pattern and color for the background of a cell.
TFlxFont	Encapsulation of an Excel Font.
TFlxFormat	Format for one cell or named style. Cell formats are used to format cells, Named styles to create styles. A Cell format can have a parent style format, even when normally this is null (parent is normal format). Named styles will have a non-null Style property. Cell formats will have style = null.
TFlxMessages	FlexCel Native string Constants. It reads the resources from the active locale, and returns the correct string. If your language is not supported and you feel like translating the messages, please send us a copy. We will include it on the next FlexCel version. To add a new language:...[more]
TFlxNumberFormat	Static class to convert cells to formatted strings. It uses format strings from Excel, that are different to those on .net, so we have to try to reconcile the diffs.
TFlxOneBorder	Border style and color for one of the 4 sides of a cell.
TFlxPartialFormat	This structure holds together the format definition for a cell, and which parts of that format definition should be applied. With this you can apply only parts of the format to a cell.
TFormula	An Excel formula. Use this class to pass a formula to an Excel sheet.
TFormulaMessages	Tokens that can be used on a formula.
TFormulaSpan	This structure is used in formulas that span more than one cell, like some array formulas, or "what-if" table formulas.
TFormulaValue	Represents a value inside a formula. it might be an array of values in case it is an array formula.
TGradientStop	Represents one of the points in a Gradient definition for an Excel cell. Note that drawings (autoshapes, charts, etc) use a different Gradient definition: TDrawingGradientStop
THeaderAndFooter	Contains all information about headers and footers in an Excel sheet.
THeaderOrFooterAnchor	Image information for an image inside a header or footer.
THSLColor	Implements a simple representation of a color in Hue/Saturation/Lum colorspace.
THtmlColors	Converts between Color structs and HTML values.
THtmlDataUri	Provides functionality to create a data uri from data.
THtmlEntities	Contains a list of HTML entities and their values
THtmlFixes	Defines special fixes to the generated files to workaround browser bugs.
THtmlTag	Contains an HTML tag and its position on the string.
THtmlTagCreator	Creates html tags for different actions, and depending on the HTML style.
THyperLink	An encapsulation of an Excel hyperlink.
TImageUtils	Utilities for manipulating images.
TLabColor	Implements a simple representation of a color in CIE-Lab* colorspace. This colorspace is mostly used for finding distances between colors.
TLineArrow	Describes an arrow at the end of a line. This struct is immutable.
TLinkedStyle	This class is used as a part of a TFlxFormat class, and stores how a cell format is linked to a style.
TPaperDimensions	Dimensions of an Excel paper
TPrinterDriverSettings	Printer specific settings. It is a byte array with a Win32 DEVMODE struct.
TProtectedRange	Specifies a protected range in a sheet. You can define those ranges in Excel 2007 by going to "Review" tab and selecting "Allow Users to Edit Ranges" In Excel 2003, they are available under "Menu->Tools->Protection".
TRichString	A string cell value with its rich text information. RTFRuns is an array of TRTFRun structures, where each struct identifies a font style for a portion of text. For example, if you have: Value = "Hello" RTFRuns = {FirstChar:1 Font:Font1, FirstChar:3, Font:Font2} "H" (char 0) will be formatted with the specific cell format. "el" (chars 1 and 2) will have Font1 "lo" (chars 3 and 4) will have Font2
TRTFRun	One RTF run for the text in a cell. FirstChar is the first (base 0) character to apply the format, and Font is the font definition for the text
TScRGBColor	Implements a simple representation of a color in scRGB colorspace. Components are doubles going from 0 to 1.
TShapeConnector	Used to link two different shapes with a connector.
TSharedWorkbookProtectionOptions	Options for protecting the change list in a shared workbook. In Excel you can change this settings in Protection->Protect Shared Workbook.
TSheetProtectionOptions	Options for protecting a sheet.
TSheetView	This class has the different "Page View" modes that you can choose in Excel, ad properties of each mode.
TSingleFormulaValue	Represents a single value inside a formula.
TSpinProperties	Spin properties of a scrollbar, spinner, listbox or combobox.
TStandardMimeType	Mime types for common file types.
TSVGAttribute	Represents an attribute for using in SVG.
TTableApplyBorders	Determines which parts of the borders will be applied in the Table.
TTableApplyFill	Determines which parts of the pattern will be applied in the table.
TTableApplyFont	Determines which parts of the font will be applied in the Table.
TTableBorders	Determines which parts of the borders will be applied in the Table.
TTableColumnDefinition	Contains the definition for a column in an Excel table. This is mostly useful if the table doesn't have headers, since when the table has headers the columns are inferred from the cells where the header is.
TTableFont	Determines which parts of the font will be applied in the Table.
TTableStyle	Defines a table style.
TThemeTextFont	The characteristics that define a font.
TUIColor	Represents a color used to draw in a canvas (gdi+, wpf, etc) in a way that is independent of the drawing framework.
TUIGradientStop	A structure describing a gradient point, with its color and position in the gradient.
TUIPointF	Platform independent point
TUIRectangle	A platform independent rectangle. Coordinates are floating point numbers.
TUISize	A platform independent Size structure. Width and Height are floating point numbers.
TUITextDecoration	Defines appearance of decorative lines used in text, like underline or strikeout.
TVirtualCellValue	Represents a cell, including the row, column and sheet where it was read.
TWorkbookProtectionOptions	Options for protecting the workbook.
TXls3DRange	A 3d Excel range.
TXlsCellRange	An Excel Cell range, 1-based.
TXlsChartLabelPosition	Stores a label position in the format used in xls files. The numbers can have many different meanings depending on where they are applied.
TXlsMargins	Sheet margin for printing, in inches.
TXlsNamedRange	An Excel named range.

Interfaces

Name	Description
IAreaChartOptions	Options specific for an Area chart.
IAreaLineChartOptions	Options specific for a Line or Area chart.
IBarChartOptions	Options for a Bar or Column chart.
IBaseImageProperties	Image information, for headers and footers, normal images or objects in general.
IBlip	Picture and properties used in a Blip fill.
IBlipFill	Shapes are filled with an image.
IChart3DOptions	Holds the 3D properties of the chart.
IChartAxis	A class encapsulating the information of an axis
IChartFillOptions	Fill options for a chart element.
IChartFrameOptions	Description of a box, its coordinates, fill style and line style.
IChartLegend	Description of the chart's legend box.
IChartLineOptions	Line style options for an element of a chart.
IChartOptions	Base class for options specific to the type of chart.
IChartPlotArea	Line and fill styles for the Plot Area.
IChartSeries	The definition for a series, and the values of it.
IChartSeriesFillOptions	Fill options for a series or a point inside a series.
IChartSeriesLineOptions	Line style options for a series or a point inside a series.
IChartTextOptions	Options for text inside the chart.
ICommentProperties	Holds the properties for a comment. This class is a descendant of IObjectProperties, and it adds specific behavior for a comment.
IConditionalAboveAverageRule	A conditional format rule which highlights cells which are below or above the average value of the group of cells.
IConditionalBaseTextRule	A base conditional format rule which highlights cells which contain specific text. This class is not used directly, you use the descendants.
IConditionalBeginsWithTextRule	A conditional format rule which highlights cells which start with some text.
IConditionalCellIsRule	A conditional format rule specified by the value on a cell (less than, equal, etc).
IConditionalColorScaleRule	A conditional format rule specified as a color scale.
IConditionalContainsBlanksRule	A conditional format rule which highlights blank cells.
IConditionalContainsErrorsRule	A conditional format rule which highlights cells with errors.
IConditionalContainsTextRule	A conditional format rule which highlights cells which contain some text.
IConditionalDataBarRule	A conditional format rule specified as a Data Bar.
IConditionalDuplicateValuesRule	A conditional format rule which highlights duplicated values.
IConditionalEndsWithTextRule	A conditional format rule which highlights cells which end with some text.
IConditionalExpressionRule	A conditional format rule specified by a formula.
IConditionalFormatRule	A rule specifying a conditional format. You cannot create instances of this class, only of their children.
IConditionalFormatStandardDefRule	A conditional format rule which modifies the cell format (color, font, etc). This is different from other rules as databars or iconsets.
IConditionalFormatValuesRule	An abstract class which has common properties for a Databars, IconSet or ColorScale rule.
IConditionalIconSetRule	A conditional format rule specified as an icon Set.
IConditionalNotContainsBlanksRule	A conditional format rule which highlights not blank cells.
IConditionalNotContainsErrorsRule	A conditional format rule which highlights cells without errors.
IConditionalNotContainsTextRule	A conditional format rule which highlights cells which don't contain some text.
IConditionalTimePeriodRule	A conditional format rule which highlights cells which are in an specific time period. Note that it will also apply to number intervals, since dates are formatted numbers.
IConditionalTopNRule	A conditional format rule specified by the top-N or bottom-N values.
IConditionalUniqueValuesRule	A conditional format rule which highlights unique values.
ICustomTableStyle	Represents a custom table style.
IDataConnections	Collection of data connections in a file.
IDataLabel	Represents one data label on the chart.
IDrawingConditionalFormat	This class contains the data needed to draw a "complex" conditional format like a databar or iconset. It is used for exporting xls/x files to drawings or pdf.
IEffectProperties	A class encapsulating an effect that can be used for subtle, intense or moderate types. This class can contain either a standard list of effects (which you can access with EffectLst) or a Directed Acyclic Graph (DAG). One of EffectLst or EffectDag will always be null.
IEmbeddedObjects	Use this interface to read or write Embedded drawing objects inside other object.
IExcelChart	Information for a chart inside a sheet or an object.
IExcelGradient	Represents a gradient fill for a background cell. This class is abstract, you need to use its children: IExcelLinearGradient and IExcelRectangularGradient
IExcelLinearGradient	A linear gradient used for filling a background.
IExcelRectangularGradient	A rectangular gradient used for filling a background.
IFillStyle	Base definition for a Drawing fill style. This class is abstract, and you should use its descendants like ISolidFill or IGradientFill
IGradientFill	Shapes are filled with a gradient.
IGroupFill	Shape is part of a group and filled with its parent fill style.
IHeaderOrFooterImageProperties	Image information for an image embedded inside a header or footer.
IHtmlFontEvent	Provides a method to customize the fonts used in the HTML methods.
IImageProperties	Image information for a normal image.
ILineChartOptions	Options specific for a Line chart.
ILineStyle	Definition for a Drawing line style.
INoFill	There is no fill associated with the shapes.
IObjectProperties	Holds the properties for an object.
IPatternFill	Shapes are filled with a texture.
IPieChartOptions	Options specific for a Pie chart.
IRowColSize	Interface for row heights and columns widths. XlsFile implements this interface, so you can pass an XlsFile object anytime you need to pass this interface.
IScatterChartOptions	Options specific for a Scatter/Bubble chart.
IShapeEffects	Contains information for the effects of an autoshape.
IShapeFill	Contains the information for the fill of an autoshape.
IShapeFont	Contains information for the font of an autoshape.
IShapeLine	Contains the information for the line style for an autoshape.
IShapeOptionList	This class holds a list of key/values pairs specifying the options for a shape. To Get a value from it, use: ShapeOptionList[TShapeOption.xxx];
IShapeProperties	A class describing an Excel graphics object.
ISolidFill	Shapes are filled with a solid color.
IStackedOptions	Interface for charts that can be stacked.
ITableDefinition	Contains the definition of an Excel table.
ITheme	Contains a complete definition for an Office Theme.
IThemeColorScheme	A color scheme for a theme.
IThemeElements	Definitions of the elements in a theme (colors, fonts, formats). This is the main part of a theme.
IThemeFontScheme	Represents the fonts for a theme.
IThemeFormatScheme	Represents the drawing formats (fill styles, line styles, effects) for a theme.
ITokenList	A list of tokens which create a formula.
IUnknownChartOptions	Options for an unknown chart. This class does not have any information except the charttype.
IUserDefinedFunctionAggregator	This interface is passed to methods that will process the workbook. Implement your own custom decendant to create new functions.
IXmlMap	Encapsulates the XML Maps in a file.

Enumerations

Name	Description
TArrowLen	The length of an arrow head.
TArrowStyle	Style of an arrow.
TArrowWidth	Preset width for an arrow.
TAutofitMerged	Specifies how a merged cell will be autofitted. For example, if you have a merged cell from row 1 to 4, You might want to increase the size of the first row, the second, the last, or every row a little.
TAutomaticColor	A list of special colors that depend on the user settings in windows.
TAxisLabelPosition	Position of the labels on the axis.
TAxisType	Type of axis.
TBackgroundMode	How to draw backgrounds of text.
TBlipCompression	This type specifies the amount of compression that has been used for a particular picture.
TBlipTransformType	The type of transform applied to an image.
TBubbleSizeType	What the bubble size means.
TBuiltInStyle	Enumerator with all built-in styles in Excel.
TCategoryAxisOptions	Options for a Category Axis.
TCellIndentationRendering	Defines how FlexCel renders cell indentation when exporting to pdf or printing.
TCellType	This enumeration holds all the possible datatypes inside a cell.
TCellValueType	This enumeration holds all the possible datatypes inside a cell.
TCfvoType	Type of a Value-Object for a conditional format.
TChartAxisPos	Axis postion.
TChartErrorBarBarType	Specifies the possible ways to draw an error bar.
TChartErrorBarDirection	Direction of an Error bar in a chart.
TChartErrorBarErrorType	Error amount type for the error bar.
TChartLabelPositionMode	How coordinates are stored for a label when it is manually positioned.
TChartLayoutMode	Specifies how the coordinates of a chart rectangle apply.
TChartLayoutTarget	Defines if the coordinates of the enclosing rectangle include the axis marks and labels.
TChartLegendPlacement	Position of the legend inside the chart.
TChartLineStyle	Line styles for a chart object.
TChartLineWeight	Different widths for chart lines. Since Excel 2007 this isn't used anymore, as you can use arbitrary line widths.
TChartMarkerType	Kind of marker.
TChartType	Chart style.
TCheckboxState	Possible values of a checkbox in a sheet.
TClippingStyle	Can be used to clip into a region instead of drawing on it.
TCollapseChildrenMode	Determines how the children of the node of an outline will be when the node is collapsed or expanded.
TColorTransformType	List of transformations that can be done to a color.
TColorType	Defines which one of the values stored in a TExcelColor structure is the one that must be used.
TColumnImportType	Handles how to convert a column from text when importing a text file.
TCompoundLineType	Type of line.
TCompressionLevel	This specifies how much the xlsx or pdf files must be compressed. The bigger compression ratio, the slower it will be to generate the files.
TCondFmtError	Errors that might happen in a conditional format.
TCondFmtIconSet	Different icon sets used in conditional formatting.
TConditionalFormatKind	Defines which kind of conditional formatting the rule contains.
TConditionType	A list of conditional operators that you can apply in a Conditional format.
TContentTransferEncoding	Defines how a part of a MIME message will be coded.
TDataBarAxisPosition	Axis position for the databar.
TDataBarDirection	The direction of the databar.
TDataBindingLoadMode	Specifies the loading mode of an XML Map databinding.
TDataConnectionCredentialMethod	Credentials method used for server access.
TDataConnectionFieldType	These are the possible data types to use when importing text into the SpreadsheetML document. Strings are converted to these data types in the worksheet.
TDataConnectionFileType	The file type being used for text import.
TDataConnectionHtmlFormat	How to handle formatting from the HTML source.
TDataConnectionParameterType	Specifies how a parameter is refreshed.
TDataConnectionQualifier	Qualifier to use to denote string data types in when text is imported from an external file.
TDataConnectionReconnectionMethod	How to reconnect when a connection fails.
TDataConnectionType	Represents a connection type. This enumeration lists the documented values, but there could be other values peresent in the file.
TDataLabelPosition	Defines where a label is displayed on a chart.
TDataValidationConditionType	Defines the condition used in the data validation box.
TDataValidationDataType	Possible types of data validation.
TDataValidationIcon	Icon to be displayed in the error box of a data validation action. Note that this not only affects the icon used, but the possible values. An information icon will allow you to enter an invalid value in a cell, a stop icon will not.
TDataValidationImeMode	The IME (input method editor) mode enforced by a data validation.
TDateUnits	Date units for a date axis.
TDocumentCustomPropertyType	Defines which kind of property is a custom property.
TDrawingAlignment	Specifies the alignment types for text in a drawing.
TDrawingColorType	Defines the kind of colors that might be stored inside a color definition in a drawing or a theme.
TDrawingFontAlign	Different types of font alignment.
TDrawingPattern	Different types of patterns for filling an Excel 2007 object. This is different from the patterns to fill a cell.
TDrawingRectAlign	How to position two rectangles relative to each other.
TDrawingTextCapitalization	how text is capitalized when rendered.
TDrawingTextStrike	How the text is stroke out.
TDrawingUnderlineStyle	Possible underline types in a drawing.
TEncryptionAlgorithm	Encryption algorithms supported in xlsx encrypted files.
TEncryptionType	How the file is encrypted. This applies only to xls files. Xlsx files are encrypted using the Agile xlsx encryption.
TEnterStyle	Defines how characters will be converted when encoding a string as Html.
TEscherConnectorType	The type of connector.
TExcelFileErrorActions	Enumerates what to do on different FlexCel error situations.
TExcelFileFormat	Different Excel versions create different empty xls/xlsx files. For example an empty xls file created by Excel 2003 will have "Arial" as its default font, and one created by Excel 2007 will have "Calibri". By default, when you call TExcelFile.NewFile FlexCel will create a file that is similar to what Excel 2003 would create. This is fine, but if you want to start for example from an empty Excel 2007 file, you can do so by calling NewFile() with this enumeration.
TExcelVersion	Defines which Excel version FlexCel is targeting. Note that while on v2007 you still can make xls 97 spreadsheets.
TExcludedRecords	A list of records that might not be saved into a file when using TExcelFile.SaveForHashing(TStream)
TFileFormats	Supported file formats to read and write files.
TFillStyleType	Stores the different kind of fill styles for an autoshape or drawing.
TFillType	Type of fill for an autoshape. (In xls files)
TFlexCelClipboardFormat	The file fomats that FlexCel can natively put in the clipboard.
TFlexCelError	An enumeration of all possible FlexCel non fatal errors that can be logged.
TFlexCelImageHorizAlign	Sets how an image is aligned inside a box.
TFlexCelImageVertAlign	How an image is aligned inside a box.
TFlipMode	How an image will be flipped when filling a pattern.
TFlxAnchorType	How an image behaves when inserting/copying rows/columns
TFlxBorderStyle	Cell border style.
TFlxDiagonalBorder	Diagonal border style.
TFlxErr	Error Codes used in Exceptions.
TFlxFontStyles	Font style. You can "or" on "and" it to get the actual styles. For example, to set style to bold+italic, you should use TFlxFontStyles.Bold \| TFlxFontStyles.Italic. to check if style includes italic, use ((Style & TFlxFontStyles.Italic)!=0)
TFlxFormulaErrorValue	Error codes for cells on excel
TFlxInsertMode	Inserting mode. Important: This enumeration is also used when deleting ranges. When deleting, Down means Up and Right means Left.
TFlxMessage	Some custom strings.
TFlxParam	Parameter names that can go into an "invalid params" error message.
TFlxPatternStyle	Pattern style.
TFlxReadingOrder	Reading order for a cell.
TFlxUnderline	Underline type.
TFmReturnType	Formula return types... A value, an array or a reference.
TFontCharSet	Character set for a font as defined in the DrawingML standard.
TFontScheme	Specifies the scheme to which a font belongs in the theme. This attribute is only valid in Excel 2007 or newer.
TFormattingType	The elements here are different types of fill/effects/etc that can be applied to an object. Currently Excel only defines 3 types, but more can be added in future specifications. Newer types can be accessed by casting an int to TFormattingType. (for example "(TFormattingType)5" would refer to a now non existing formatting type)
TFormulaToken	Known token on a formula. They are not supposed to be localized, but they can be by editing formulamsg.resx
TFormulaValueType	This enumeration contains the possible values a formula might contain.
TFullRecalcOnLoadMode	Defines how FlexCel will save the files so they will be recalculated or not when you open them in Excel.
TFunctionGroup	Specifies the function group index if the defined name refers to a function. The function group defines the general category for the function. This attribute is used when there is an add-in or other code project associated with the file.
TGradientType	The type of gradient stored inside a IExcelGradient object.
THeaderAndFooterKind	Different kinds of headers and footers depending on which pages they apply.
THeaderAndFooterPos	Different sections on a header or footer.
THFlxAlignment	Horizontal Alignment on a cell.
THidePrintObjects	Enumeration defining which objects should not be printed or exported to pdf. You can 'or' more than one option together. For example, to not print images and not comments, you should specify: THidePrintObjects.Images \| THidePrintOption.Comments
THtmlFileFormat	How the html page will be saved.
THtmlStyle	Defines the way html is generated.
THtmlVersion	Defines the HTML version that will be used when exporting.
THyperLinkType	Possible types of cell hyperlinks.
TIgnoredErrors	Specifies what kind of errors Excel will ignore for ranges of cells. "Errors" in a spreadsheet are the green triangles that appear in the top left crner of the cell, like "Number stored as text".
TImageColorDepth	Number of colors for the exported images.
TImageExportType	Defines how you want to export the sheet.
TImageNaming	Defines how images will be automatically named by FlexCel, when you do not supply a better name.
TInternalNameRange	List of internal range names. On Excel, internal range names like "Print_Area" are stored as a 1 character string. This is the list of the names and their value. You can convert an InternalNameRange into a string by casting it to a char, or by calling TXlsNamedRange.GetInternalName
TJpegOrientation	Specifies the rotation of a JPEG image.
TLabelDataValue	Defines what information a DataLabel should show.
TLineCap	How the line ends.
TLineDashing	Line style (dashes, solid, etc).
TLineJoin	How a line joins with the next
TLinkOption	Specifies to which object the label is linked to.
TListBoxSelectionType	Types of selection allowed in a listbox.
TMultipartType	Different ways to define a multipart archive.
TObjectType	A type of object. Do not confuse this with a type of shape ( TShapeType ) This does not describe the shape form (like if it is a rectangle or a circle) but the shape kind (for example if it is a comment, an image or an autoshape)
TOperator	Operators that can be found inside a formula
TOverlayBlendMode	Overlay blend modes.
TPanePosition	Position on a pane when window is split
TPaperSize	Pre-defined Page sizes. For Printer specific page-sizes, see TPrinterDriverSettings Note that a printer specific page size might have a value that is not on this enumeration.
TPathShadeType	Enumerates the different gradient modes for a Path gradient.
TPenAlignment	Specifies the alignment to be used for the underline stroke.
TPitchFamily	Pitch family for a font.
TPlotEmptyCells	Defines how empty cells will be plotted in the chart.
TPresetColor	Preset colors.
TPresetShadowEffectType	Types of preset shadow.
TPrimaryThemeColor	Specifies one of the 12 theme colors. Does not include semantic colors, which are in TThemeColor
TPrintOptions	How the sheet should be printed. You can mix value together by and'ing and or'ing the flags. See the example to see how to set or clear one specific value of the enumeration.
TPropertyId	Standard properties of an ole file. There are two different sets of properties, the standard ones (properties that exist for any file) and the extended ones (properties that exist for Ms Office documents)
TProtectionType	Indicates how a sheet will be protected.
TQEncodeMetaInfo	Defines how a string returned by Q-Encode will be handled.
TRangeCopyMode	What we do with the cells when we call InsertAndCopyRange.
TRangeOp	Operation between ranges.
TRecalcMode	Sets how the excel file will be recalculated. Normally FlexCel calculates a file only before saving and when you explicitly call TExcelFile.Recalc(Boolean). With this enum you can change that behavior.
TRecalcVersion	Identifies how FlexCel will identify itself in the generated file, in order to recalculate.
TReferenceStyle	Use this enumerator in the property TExcelFile.FormulaReferenceStyle to specify the reference mode that FlexCel will use when you enter formulas as text or when it returns the formula text.
TShapeOption	Many different configuration options for a shape.
TShapeOptionType	Returns the type of option type.
TShapePresetGuideType	Internal use.
TShapeType	Enumeration with the different shapes.
TSheetCalcMode	How the file will be calculated by Excel. This enum doesn't affect FlexCel recalculation.
TSheetOptions	General options for a sheet. In Excel, this settings are located in Tools->Options->View in the "Window options" box. Most of this options can be set with dedicated methods in TExcelFile, but this type allows to set them all at once, or copy them from other file. This options apply only to the active sheet. For options that apply to all the sheets see TSheetWindowOptions
TSheetType	Sheet types
TSheetViewType	The page mode of a sheet. You select this in Excel by changing the icons at the bottom right, or from the ribbon, in the "View" tab.
TSheetWindowOptions	General options for how sheets display. In Excel, this settings are located in Tools->Options->View in the "Window options" box. This options apply only to all the sheets. For options that apply only to the active sheet see TSheetOptions
TSortFormulaMode	Defines how FlexCel will sort a range of cells, when you call XlsFile.Sort. You will normally want to specify "MoveFormulas", but for huge amounts of data where you know formulas won't matter, you might choose the "ExcelLike" mode. Note that Excel itself doesn't adapt correctly the formulas when sorting, and it works like the ExcelLike mode.
TSortOrder	The sort order for a sort operation.
TStackedMode	Way the series stack one to the other. This does not apply to all chart types.
TStructRefSection	This enum contains the possible values that can go into a structured reference. You can combine multiple values, but not all combinations make sense. For example #Data + #Headers it fine, but #All + #Headers is just #All.
TStyleCategory	Category to which a cell style belongs. This is only valid for Excel 2007 or newer.
TSVGExportType	Customized what data will be included in an svg file.
TSystemColor	System colors.
TTableStyleType	Defines the part of the table for which a tablestyle applies.
TTextRotation	Text direction for objects like comments, that allow rotation, but only in 90 degrees.
TThemeColor	Specifies one of the 12 theme colors, or one of the 4 semantic colors. In cells, Excel doesn't use semantic colors, but in drawings they can be used, even if the Excel UI only allows one type of color.
TTickType	Ticks for an axis.
TTimePeriod	A time period for conditional format.
TTokenType	Enumerates the different kind of tokens you can find in a formula
TTokenWhitespaceCharacter	Character used in the whitespace.
TTokenWhitespacePosition	Specifies where the whitespace is added in relation to the next token.
TUIDashStyle	Platform independent line style.
TUIFontStyle	The different styles a font can have.
TUIHatchStyle	Specifies the different patterns available.
TUIInterpolationMode	How the image will be scaled. See System.Drawing.Drawing2D.InterpolationMode for reference.
TUISmoothingMode	Smoothing mode. See System.Drawing.Drawing2D.SmoothingMode.
TUIStrikeout	Defines if the text is stroke out. Currently there is only an style of strike out, which is a single strikeout.
TUIUnderline	Type of underline in the text.
TUnsupportedFormulaErrorType	Types of error that might happen while recalculating.
TUserDefinedFunctionLocation	Defines where the custom function is located, if inside a macro in the same file, or inside a macro in an external file.
TUserDefinedFunctionScope	Defines how custom functions are added to the recalculation engine. If a function is defined in both Global and Local scope, Local scope will be used.
TValueAxisOptions	Options for a Value Axis.
TVFlxAlignment	Vertical Alignment on a cell.
TXlsBiffVersion	The specific Excel version that FlexCel will emulate when reading and saving files.
TXlsImgType	Possible image types on an excel sheet.
TXlsSheetVisible	Sheet visibility.

Anonymous methods

Name	Description
TOnSheetNameEventHandler	Delegate used to specify which name to use for every sheet when exporting multiple sheets to multiple files.

Methods

Name	Description
FlexCelDllInit	Use this method to initialize FlexCel when encapsulating it in a dll. Note that you don't normally need to call this method, as FlexCel is initialized automatically. But when you are hosting FlexCel inside a dll instead of the main application you need to call this method before calling the methods in the dll. Currently, this method will just initialize GDI+ when running in Windows, because GDI+ can't be initialized from the dll itself. When you use this method, always call FlexCelDllShutdown before closing your app.
FlexCelDllShutdown	This method shutdowns FlexCel, and is designed to be used when you are using FlexCel inside a dll. for more information, take a look at FlexCelDllInit.
TUISmoothingMode_FlexCelDefault	Default mode used by FlexCel. You can change this value with TUISmoothingMode_SetFlexCelDefault.
TUIInterpolationMode_FlexCelDefault	Default mode used by FlexCel. You can change this value with TUIInterpolationMode_SetFlexCelDefault.
TUISmoothingMode_SetFlexCelDefault	Sets the default mode used by FlexCel. You can change this in your application to change how FlexCel will render the images.
TUIInterpolationMode_SetFlexCelDefault	Sets the default mode used by FlexCel. You can change this in your application to change how FlexCel will render the images.
EncryptionFactory	Returns the encryption factory used by FlexCel. You can use it to sign PDF files