FlexCel.Core Namespace
The core classes and general utilities for using FlexCel.
Classes
Name | Description |
---|---|
CellValue | Represents a cell, including the row, column and sheet where it was read. |
ChartBubbleSeries | Returns the the bubble values for a bubble chart. |
ChartFillOptions | Fill options for a chart element. |
ChartLineOptions | Line style options for an element of a chart. |
ChartSeries | The definition for a series, and the values of it. |
ChartSeriesFillOptions | Fill options for a series or a point inside a series. |
ChartSeriesLineOptions | Line style options for a series or a point inside a series. |
ChartSeriesMarkerOptions | Marker options for the whole series or a point in the series when the chart is line or scatter. |
ChartSeriesMiscOptions | Misc options for the whole series or a point in the series that do no enter in any other category. |
ChartSeriesOptions | Options for the whole series or for a data point inside it. |
ChartSeriesPieOptions | Pie options for a series or a slice of the series when the chart is a pie chart. |
ChartWallOptions | Fill and Line options for the walls and floor of a 3D chart. |
Colors | A list of standard colors. |
CultureCreatingEventArgs | Event when creating a culture. |
ExcelChart | Information for a chart inside a sheet or an object. |
ExcelFile | Interface a FlexCel engine has to implement to be used with FlexCelReport. |
ExcelFont | Utility methods to create normal fonts from Excel ones. |
ExcelMetrics | Returns Information to convert between standard units and Excel units. |
FlexCelConfig | A central point of for configuring FlexCel parameters. |
FlexCelCoreException | Exception thrown when an exception on the core engine happens. |
FlexCelDataFormats | Excel formats to copy/paste to/from the clipboard |
FlexCelException | Exception thrown when a specific FlexCel error happens. Base of all FlexCel hierarchy list. |
FlexCelTrace | This class reports al FlexCel non-fatal errors. Use it to diagnose when something is going wrong. |
FlxConsts | Utility methods and constants usable anywhere. |
FlxDateTime | Use this class to convert between a Date expressed on Excel format (a double) and a TDateTime. |
FlxMessages | 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] |
FontCreatedEventArgs | Arguments passed in FontCreated events. |
FontCreatingEventArgs | Arguments passed in FontCreating events. |
FontCreationEventArgs | Base class for font creation events. |
HtmlFontEventArgs | Arguments passed on FlexCel.Render.FlexCelHtmlExport.OnHtmlFont. |
ImageUtils | Utilities for manipulating images. |
LoadLinkedFileEventArgs | Arguments passed on TWorkspace.LoadLinkedFile |
OnPasswordEventArgs | Use this class to supply a password to open an encrypted file. |
OnSheetNameEventArgs | Arguments passed on a OnSheetName event. |
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. |
TAlphaModFixBlipTransform | Represents a transform that changes the opacity of the image. |
TAreaChartOptions | Options specific for an Area chart. |
TAreaLineChartOptions | Options specific for a Line or Area chart. |
TAxisLineOptions | Line options for an Axis. |
TAxisRangeOptions | Properties for the ranges of an axis. |
TAxisTickOptions | Properties for the ticks and labels of an axis. |
TBarChartOptions | Options for a Bar or Column chart. |
TBaseAxis | Common ancestor for all Axis types. |
TBaseImageProperties | Image information, for headers and footers, normal images or objects in general. |
TBlip | Picture and properties used in a Blip fill. |
TBlipFill | Shapes are filled with an image. |
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) |
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. |
TChart3DOptions | Holds the 3D properties of the chart. |
TChartAxis | A class encapsulating the information of an axis |
TChartDropBars | Information about a Drop Bar. |
TChartErrorBars | Information about an Error Bar. |
TChartFrameOptions | Description of a box, its coordinates, fill style and line style. |
TChartLegend | Description of the chart's legend box. |
TChartOneDropBar | Information about one specific drop bar. |
TChartOptions | Base class for options specific to the type of chart. |
TChartPlotArea | Line and fill styles for the Plot Area. |
TChartTextOptions | Options for text inside the chart. |
TChartTitle | Represents the title of the chart. |
TChartTrendline | This class holds a definition for a trendline. |
TChartTrendlineLabel | Properties for a label in a trendline. |
TChildAnchor | A class to hold the offsets relative to the parent on grouped shapes. |
TClientAnchor | Image Anchor information. |
TColorChangeBlipTransform | Represents a color transformation from one color to another. This transform can be used to make a color transparent. |
TColumnBlock | This class represents a block of columns with the same formatting, options and width. |
TCommentProperties | Holds the properties for a comment. This class is a descendant of TObjectProperties, and it adds specific behavior for a comment. |
TConditionalAboveAverageRule | A conditional format rule which highlights cells which are below or above the average value of the group of cells. |
TConditionalBaseTextRule | A base conditional format rule which highlights cells which contain specific text. This class is not used directly, you use the descendants. |
TConditionalBeginsWithTextRule | A conditional format rule which highlights cells which start with some text. |
TConditionalCellIsRule | A conditional format rule specified by the value on a cell (less than, equal, etc). |
TConditionalColorScaleRule | A conditional format rule specified as a color scale. |
TConditionalContainsBlanksRule | A conditional format rule which highlights blank cells. |
TConditionalContainsErrorsRule | A conditional format rule which highlights cells with errors. |
TConditionalContainsTextRule | A conditional format rule which highlights cells which contain some text. |
TConditionalDataBarRule | A conditional format rule specified as a Data Bar. |
TConditionalDuplicateValuesRule | A conditional format rule which highlights duplicated values. |
TConditionalEndsWithTextRule | A conditional format rule which highlights cells which end with some text. |
TConditionalExpressionRule | A conditional format rule specified by a formula. |
TConditionalFormat | This class encapsulates a list of conditional formats for a range of cells. |
TConditionalFormatColorList | A list of conditional value colors. |
TConditionalFormatDef | The format to apply when a TConditionalFormatRule 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. |
TConditionalFormatRule | A rule specifying a conditional format. You cannot create instances of this class, only of their children. |
TConditionalFormatStandardDefRule | A conditional format rule which modifies the cell format (color, font, etc). This is different from other rules as databars or iconsets. |
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. |
TConditionalFormatValuesRule | An abstract class which has common properties for a Databars, IconSet or ColorScale rule. |
TConditionalIconSetRule | A conditional format rule specified as an icon Set. |
TConditionalNotContainsBlanksRule | A conditional format rule which highlights not blank cells. |
TConditionalNotContainsErrorsRule | A conditional format rule which highlights cells without errors. |
TConditionalNotContainsTextRule | A conditional format rule which highlights cells which don't contain some text. |
TConditionalTimePeriodRule | A conditional format rule which highlights cells which are in a specific time period. Note that it will also apply to number intervals, since dates are formatted numbers. |
TConditionalTopNRule | A conditional format rule specified by the top-N or bottom-N values. |
TConditionalUniqueValuesRule | A conditional format rule which highlights unique values. |
TCropArea | Defines a cropping area for an image. If the values are not zero, only a part of the image will display on Excel. |
TCustomTableStyle | Represents a custom table style. |
TCustomTableStyleSection | Represents the format of a table section (header, totals, etc). |
TCustomXmlPart | Implements a custom XML part as described in https://msdn.microsoft.com/en-us/library/bb608618.aspx |
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. |
TDataConnections | Collection of data connections in a file. |
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. |
TDataLabel | Represents one data label on the chart. |
TDataLabelOptions | Options for a data label. |
TDataValidationInfo | Contains the information to define a data validation in a range of cells. |
TDefaultShapeOptions | Helper class to know which shape options default to true when not specified. |
TDocumentProperties | Properties for an Excel sheet. |
TDrawingConditionalFormat | 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. |
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. |
TDrawingHyperlink | Specifies an hyperlink in a drawing. While this class is similar to THyperlink for links in cells, it has some differences. |
TDrawingLinearGradient | This class holds a linear gradient definition. |
TDrawingPathGradient | Holds a Path gradient definition. |
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. |
TDrawingUnderline | Specifies the Fill style and line style of underlined text, when it is underlined. |
TEffectContainer | This class encapsulates a node of the effect DAC. |
TEffectList | This class holds a list of effects that are applied to a drawing. |
TEffectProperties | 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 TEffectProperties.EffectLst) or a Directed Acyclic Graph (DAG). One of TEffectProperties.EffectLst or TEffectProperties.EffectDag will always be null. |
TEffectStyle | A class encapsulating a style including 3D styles. |
TEffectStyleList | A list with all the effects for subtle, moderate and intense formatting types. |
TExcelGradient | Represents a gradient fill for a background cell. This class is abstract, you need to use its children: TExcelLinearGradient and TExcelRectangularGradient |
TExcelLinearGradient | A linear gradient used for filling a background. |
TExcelObjectList | A list that contains the Ids and positions of the Excel objects |
TExcelRectangularGradient | A rectangular gradient used for filling a background. |
TExcelTypes | Manages converting from/to objects/Native excel types. |
TFillOverlayEffect | A fill overlay effect. |
TFillStyle | Base definition for a Drawing fill style. This class is abstract, and you should use its descendants like TSolidFill or TGradientFill |
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. |
TFlxApplyBorders | Border style for 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. |
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. |
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. |
TFormula | An Excel formula. Use this class to pass a formula to an Excel sheet. |
TFormulaMessages | Tokens that can be used on a formula. |
TGlowEffect | A glow effect. |
TGradientFill | Shapes are filled with a gradient. |
TGroupFill | Shape is part of a group and filled with its parent fill style. |
THeaderOrFooterAnchor | Image information for an image inside a header or footer. |
THeaderOrFooterImageProperties | Image information for an image embedded inside a header or footer. |
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 |
THtmlParsedString | An Html string parsed into a C# string and tags. |
THtmlSaveSharingViolationError | This class has information for a FlexCelError.HtmlSaveSharingViolation error. Look at FlexCelError.HtmlSaveSharingViolation for more information. |
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. |
TImageProperties | Image information for a normal image. |
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. |
TLineChartOptions | Options specific for a Line chart. |
TLineStyle | Definition for a Drawing line style. |
TLineStyleList | Represents the line style characteristics. |
TLinkedStyle | This class is used as a part of a TFlxFormat class, and stores how a cell format is linked to a style. |
TMalformedUrlError | This class has information for a FlexCelError.MalformedUrl error. Look at FlexCelError.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. |
TNoFill | There is no fill associated with the shapes. |
TObjectProperties | Holds the properties for an object. |
TObjectTextProperties | Specifies properties for the text in an autoshape or object. |
TOuterShadowEffect | An outer shadow effect. |
TPaperDimensions | Dimensions of an Excel paper |
TPatternFill | Shapes are filled with a texture. |
TPdfCorruptFontInFontFolderError | This class has information for a FlexCelError.PdfCorruptFontInFontFolder error. Look at FlexCelError.PdfCorruptFontInFontFolder for more information. |
TPdfFauxBoldOrItalicsError | This class has information for a FlexCelError.PdfFauxBoldOrItalics error. Look at FlexCelError.PdfFauxBoldOrItalics for more information. |
TPdfFontLicenseDoesntAllowEmbeddingError | This class has information for a FlexCelError.PdfFontLicenseDoesntAllowEmbedding error. Look at FlexCelError.PdfFontLicenseDoesntAllowEmbedding for more information. |
TPdfFontNotFoundError | This class has information for a FlexCelError.PdfFontNotFound error. Look at FlexCelError.PdfFontNotFound for more information. |
TPdfGlyphNotInFontError | This class has information for a FlexCelError.PdfGlyphNotInFont error. Look at FlexCelError.PdfGlyphNotInFont for more information. |
TPdfUsedFallbackFontError | This class has information for a FlexCelError.PdfUsedFallbackFont error. Look at FlexCelError.PdfUsedFallbackFont for more information. |
TPieChartOptions | Options specific for a Pie chart. |
TPresetShadowEffect | Applies a preset shadow effect. |
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". |
TProtection | Encryption data for an Excel sheet. |
TRadarChartOptions | Options specific for a Radar chart. |
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 FlexCelError.RenderCorruptImage error. Look at FlexCelError.RenderCorruptImage for more information. |
TRenderErrorDrawingImageError | This class has information for a FlexCelError.RenderErrorDrawingImage error. Look at FlexCelError.RenderErrorDrawingImage for more information. |
TRenderGenericPreviewError | This class has information for a FlexCelError.RenderGenericPreview error. Look at FlexCelError.RenderGenericPreview for more information. |
TRenderMetafileError | This class has information for a FlexCelError.RenderMetafile error. Look at FlexCelError.RenderMetafile for more information. |
TReplaceAction | Specifies actions to do in every replacement. |
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 FontIndex:1, FirstChar:3, FontIndex:2} "H" (char 0) will be formatted with the specific cell format. "el" (chars 1 and 2) will have font number 1 "lo" (chars 3 and 4) will have font number 2 |
TScatterChartOptions | Options specific for a Scatter/Bubble chart. |
TSeriesOptionsList | A list of options for the whole series and for specific data points inside these series. |
TShapeEffects | Contains information for the basic effects of an autoshape (subtle, none or moderate). |
TShapeFill | Contains the information for the fill of an autoshape. |
TShapeFont | Contains information for the font of an autoshape. |
TShapeLine | Contains the information for the line style for an autoshape. |
TShapeOptionList | 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]; |
TShapeProperties | A class describing an Excel graphics object. |
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. |
TSoftEdgesEffect | Applies a soft edges effect. |
TSolidFill | Shapes are filled with a solid color. |
TSpinProperties | Spin properties of a scrollbar, spinner, listbox or combobox. |
TTableDefinition | Contains the definition of an Excel table. |
TTableFormat | Defines a custom format for a table. |
TTheme | Contains a complete definition for an Office Theme. |
TThemeColorScheme | A color scheme for a theme. |
TThemeElements | Definitions of the elements in a theme (colors, fonts, formats). This is the main part of a theme. |
TThemeFont | Represents either a major or a minor font for the theme. |
TThemeFontScheme | Represents the fonts for a theme. |
TThemeFormatScheme | Represents the drawing formats (fill styles, line styles, effects) for a 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" |
TTokenLambdaCallName | This token is used when you call a name like "=MyName(5)" and MyName has a lambda function. Note that if a cell has the expression like "=Lambda(x,x)" then you will just get a simple TTokenFunction with a name of "Lambda". This token only appears when using a name as a user-defined function. |
TTokenLambdaParameterDefinition | A parameter definition in the expression of a =LET or =LAMBDA function, like the first x in the formula: "=LET(x,3,x+3)" |
TTokenLambdaParameterReference | A parameter reference in the expression of a =LET or =LAMBDA function, like the second x in the formula: "=LET(x,3,x+3)" |
TTokenList | A list of tokens which create a formula. |
TTokenMissingArgument | A missing argument for a function. For example the second parameter in the formula: "=IF(A1 = 1,,"Hello")" |
TTokenName | A named range. Might refer to a name in a different file. |
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 a 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. |
TUnknownChartOptions | Options for an unknown chart. This class does not have any information except the charttype. |
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) |
TWorkbookProtectionOptions | Options for protecting the workbook. |
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. |
TXls3DRange | A 3d Excel range. |
TXlsCellRange | An Excel Cell range, 1-based. |
TXlsMargins | Sheet margin for printing, in inches. |
TXlsNamedRange | An Excel named range. |
TXlsTooManyPageBreaksError | This class has information for a FlexCelError.XlsTooManyPageBreaks error. Look at FlexCelError.XlsTooManyPageBreaks for more information. |
TXlsxInvalidNameError | This class has information for a FlexCelError.XlsxInvalidName error. Look at FlexCelError.XlsxInvalidName for more information. |
TXlsxMissingPartError | This class has information for a FlexCelError.XlsxMissingPart error. Look at FlexCelError.XlsxMissingPart for more information. |
TXmlMap | Encapsulates the XML Maps in a file. |
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. |
TZippyReader | Simple class for reading the contents of a zip file. It can read from multiple files at the same time, but not multithreaded. |
TZippyWriter | Simple class for writing to a zip file. It can compress on the fly as you are generating the file. |
VirtualCellEndReadingEventArgs | Arguments passed in the event. |
VirtualCellReadEventArgs | Arguments passed in the event. |
VirtualCellStartReadingEventArgs | Arguments passed in the event. |
Structures
Name | Description |
---|---|
ChartStyle | This structure defines the default style of a chart. Excel defines 48 default styles. |
StandardMimeType | Mime types for common file types. |
TCachedFontWidth | A font size cached for speed. |
TCellAddressWithFileName | Encapsulates a cell address and the file where the cell is stored. |
TCellMergedState | This struct is used in ExcelFile.CellMergedNext to keep track of the next merged cell that will be iterated. |
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%. |
TColorTransform | Specifies a color transformation to be applied to a color. |
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. |
TConditionalFormatCustomIconDef | This structure holds a single icon from a specific icon set. |
TDataLabelsRange | Encapsulates the data for a range of text used in labels |
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 |
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. |
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. |
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. |
TFlxApplyFillPattern | Fill pattern and color for the background of a cell. |
TFlxFillPattern | Fill pattern and color for the background of a cell. |
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. |
TFormulaSpan | This structure is used in formulas that span more than one cell, like some array formulas, or "what-if" table formulas. |
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. |
THSLColor | Implements a simple representation of a color in Hue/Saturation/Lum colorspace. |
THtmlFixes | Defines special fixes to the generated files to workaround browser bugs. |
TLabColor | Implements a simple representation of a color in CIE-L*a*b* 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. |
TLoopOverUsedRangeParameters | This structure contains the parameters passed in ExcelFile.LoopOverUsedRange |
TPoint | Represents a point on X,Y coordinates. We used instead of System.Drawing.Point because we do not want references to System.Drawing (because .NET 3.0 applications do not need GDI+) |
TPointF | Platform independent point |
TRTFRun | One RTF run for the text in a cell. FirstChar is the first (base 0) character to apply the format, and FontIndex is the font index 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. |
TSVGAttribute | Represents an attribute for using in SVG. |
TSVGBlip | Contains the data of an SVG image, when the blip is of SVG type. |
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. |
TTableFormula | Contains the formula for a table total or calculated formula. |
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. |
TUIInterpolationMode | Interpolation mode. See System.Drawing.InterpolationMode for details. |
TUIRectangle | A platform independent rectangle. Coordinates are floating point numbers. |
TUISize | A platform independent Size structure. Width and Height are floating point numbers. |
TUISmoothingMode | Smoothing mode. See System.Drawing.Drawing2D.SmoothingMode. |
TUITextDecoration | Defines appearance of decorative lines used in text, like underline or strikeout. |
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. |
TZippyFileInfo | Stores information for a single file inside the zip file. |
Interfaces
Name | Description |
---|---|
IEmbeddedObjects | Use this interface to read or write Embedded drawing objects inside other object. |
IFlexCelFontList | Interface for passing font information. Internal use. |
IFlexCelPalette | Interface for passing palette and theme information. XlsFile implements IFlexCelPalette, so you can pass any XlsFile object whenever you need to use this interface. |
IHtmlFontEvent | Provides a method to customize the fonts used in the HTML methods. |
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. |
IStackedOptions | Interface for charts that can be stacked. |
IUserDefinedFunctionAggregator | This interface is passed to methods that will process the workbook. Implement your own custom decendant to create new functions. |
Enumerations
Name | Description |
---|---|
ColumnImportType | Handles how to convert a column from text when importing a text file. |
CondFmtError | Errors that might happen in a conditional format. |
FlexCelClipboardFormat | The file fomats that FlexCel can natively put in the clipboard. |
FlexCelError | An enumeration of all possible FlexCel non fatal errors that can be logged. |
FlexCelGraphicFramework | Defines the Graphics Framework that FlexCel will use to render files to images or PDF. Only works in .NET 5+. You can change it by setting the property FlexCelConfig.GraphicFramework |
FlxErr | Error Codes used in Exceptions. |
FlxMessage | Some custom strings. |
FlxParam | Parameter names that can go into an "invalid params" error message. |
ImageColorDepth | Number of colors for the exported images. |
ImageExportType | Defines how you want to export the sheet. |
InternalNameRange | 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 |
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 | Values we can write on 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. |
TChartRadarStyle | Style for the radar chart. |
TChartTrendlineType | Defines the type of trendline. |
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. |
TCompoundLineType | Type of line. |
TCompressionMode | How the fields inside the zip file will be compressed. Zippy supports only both most used methods, Store and Deflate. |
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 ExcelFile.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 ExcelFile.SaveForHashing(Stream) |
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) |
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. |
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. |
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 |
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 TExcelGradient 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 corner of the cell, like "Number stored as text". |
TImageNaming | Defines how images will be automatically named by FlexCel, when you do not supply a better name. |
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 |
TPrintComments | Determines how the comments will be displayed when printing. |
TPrintErrors | Determines how to print the errors when printing or exporting a sheet. |
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 ExcelFile.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 ExcelFile.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 ExcelFile, 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. |
TTextHorzOverflow | How the text in a shape will overflow horizontally once there is no more room for it. |
TTextRotation | Text direction for objects like comments, that allow rotation, but only in 90 degrees. |
TTextVertOverflow | How the text in a shape will overflow vertically once there is no more room for it. Note that from the Excel UI, you can only set both Vert overflow and Horizontal overflow at the same time. |
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. |
TTotalsRowFunction | Type of function used to summarize a table column. |
TUIDashStyle | Platform independent line style. |
TUIFontStyle | The different styles a font can have. |
TUIHatchStyle | Specifies the different patterns available. |
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. |
Delegates
Name | Description |
---|---|
CultureCreatingEventHandler | Delegate for CultureCreating events. Return null to use the culture that would have been used had this event not be assigned. |
FlexCelErrorEventHandler | Delegate for ErrorInfo events. |
FontCreatedEventHandler | Delegate for FontCreated events. |
FontCreatingEventHandler | Delegate for FontCreating events. |
HtmlFontEventHandler | Delegate used to specify which fonts to use on a page. |
LoadLinkedFileEventHandler | Delegate for LoadLinkedFile event. |
OnPasswordEventHandler | This event fires when opening an encrypted file and no password has been supplied. |
OnSheetNameEventHandler | Delegate used to specify which name to use for every sheet when exporting multiple sheets to multiple files. |
VirtualCellEndReadingEventHandler | Delegate for virtual cell reads. This delegate is called after the full file has been read. |
VirtualCellReadEventHandler | Delegate for virtual cell reads. |
VirtualCellStartReadingEventHandler | Delegate for virtual cell reads. It is called before we start reading the file, but after sheet names are known. |