Search Results for

    Show / Hide Table of Contents

    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.
    ChartSeriesFill​Options Fill options for a series or a point inside a series.
    ChartSeriesLine​Options Line style options for a series or a point inside a series.
    ChartSeriesMarker​Options Marker options for the whole series or a point in the series when the chart is line or scatter.
    ChartSeriesMisc​Options 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.
    ChartSeriesPie​Options 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.
    CultureCreating​Event​Args 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.
    FontCreating​Event​Args Arguments passed in FontCreating events.
    FontCreation​Event​Args Base class for font creation events.
    HtmlFontEventArgs Arguments passed on FlexCel.​Render.​FlexCel​Html​Export.​OnHtml​Font.
    ImageUtils Utilities for manipulating images.
    LoadLinkedFile​Event​Args Arguments passed on TWorkspace.​Load​Linked​File
    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.
    TAlphaModFix​Blip​Transform Represents a transform that changes the opacity of the image.
    TAreaChartOptions Options specific for an Area chart.
    TAreaLineChart​Options 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.
    TColorChange​Blip​Transform 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.
    TConditional​Above​Average​Rule A conditional format rule which highlights cells which are below or above the average value of the group of cells.
    TConditional​Base​Text​Rule A base conditional format rule which highlights cells which contain specific text. This class is not used directly, you use the descendants.
    TConditional​Begins​With​Text​Rule A conditional format rule which highlights cells which start with some text.
    TConditional​Cell​IsRule A conditional format rule specified by the value on a cell (less than, equal, etc).
    TConditional​Color​Scale​Rule A conditional format rule specified as a color scale.
    TConditional​Contains​Blanks​Rule A conditional format rule which highlights blank cells.
    TConditional​Contains​Errors​Rule A conditional format rule which highlights cells with errors.
    TConditional​Contains​Text​Rule A conditional format rule which highlights cells which contain some text.
    TConditional​Data​BarRule A conditional format rule specified as a Data Bar.
    TConditional​Duplicate​Values​Rule A conditional format rule which highlights duplicated values.
    TConditional​Ends​With​Text​Rule A conditional format rule which highlights cells which end with some text.
    TConditional​Expression​Rule A conditional format rule specified by a formula.
    TConditionalFormat This class encapsulates a list of conditional formats for a range of cells.
    TConditional​Format​Color​List A list of conditional value colors.
    TConditional​FormatDef The format to apply when a TConditional​Format​Rule is applied.
    TConditional​Format​DefColor​Scale Defines a format of the color scales in a conditional format.
    TConditional​Format​DefDataBar Defines a format of the databars in a conditional format.
    TConditional​Format​DefIconSet Defines a format of the color scales in a conditional format.
    TConditional​Format​DefStandard Defines a format to apply for cells when a rule evaluates to true.
    TConditional​Format​Rule A rule specifying a conditional format. You cannot create instances of this class, only of their children.
    TConditional​Format​Standard​DefRule A conditional format rule which modifies the cell format (color, font, etc). This is different from other rules as databars or iconsets.
    TConditional​Format​Value​AndColor​List A list of conditional value objects with their corresponding colors.
    TConditional​Format​Value​List A list of conditional value objects.
    TConditional​Format​Value​Object Describes an interpolation point in a gradient scale.
    TConditional​Format​Values​Rule An abstract class which has common properties for a Databars, IconSet or ColorScale rule.
    TConditional​Icon​SetRule A conditional format rule specified as an icon Set.
    TConditional​NotContains​Blanks​Rule A conditional format rule which highlights not blank cells.
    TConditional​NotContains​Errors​Rule A conditional format rule which highlights cells without errors.
    TConditional​NotContains​Text​Rule A conditional format rule which highlights cells which don't contain some text.
    TConditional​Time​Period​Rule 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.
    TConditional​Unique​Values​Rule 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.
    TCustomTable​Style​Section 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.
    TDataConnection​DbProperties This element stores all properties associated with an ODBC or OLE DB external data connection.
    TDataConnection​Olap​Properties This element contains all the properties needed for an OLAP data connection. OLAP connections contain both the TDataConnection​DbProperties and TDataConnection​Olap​Properties child elements.
    TDataConnection​Parameter 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.
    TDataConnection​Parameters A list of TDataConnection​Parameter.
    TDataConnections Collection of data connections in a file.
    TDataConnectionTable Specifies the HTML table to import.
    TDataConnection​Tables Collection of HTML tables in a web query connection.
    TDataConnection​Text​Field This element specifies field settings for text import.
    TDataConnection​Text​Fields Collection of fields in the Text connection.
    TDataConnection​Text​Import​Properties This element contains all of the text import settings.
    TDataConnection​WebQuery​Properties 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.
    TDrawingConditional​Format 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.
    TDrawingLinear​Gradient 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 TExcelRectangular​Gradient
    TExcelLinearGradient A linear gradient used for filling a background.
    TExcelObjectList A list that contains the Ids and positions of the Excel objects
    TExcelRectangular​Gradient 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.
    THeaderOrFooter​Anchor Image information for an image inside a header or footer.
    THeaderOrFooter​Image​Properties 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.
    THtmlSaveSharing​Violation​Error This class has information for a FlexCelError.​Html​Save​Sharing​Violation error. Look at FlexCelError.​Html​Save​Sharing​Violation 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.
    TImplemented​Function​List 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.
    TPdfCorruptFont​InFont​Folder​Error This class has information for a FlexCelError.​Pdf​Corrupt​Font​InFont​Folder error. Look at FlexCelError.​Pdf​Corrupt​Font​InFont​Folder for more information.
    TPdfFauxBold​OrItalics​Error This class has information for a FlexCelError.​Pdf​Faux​Bold​OrItalics error. Look at FlexCelError.​Pdf​Faux​Bold​OrItalics for more information.
    TPdfFontLicense​Doesnt​Allow​Embedding​Error This class has information for a FlexCelError.​Pdf​Font​License​Doesnt​Allow​Embedding error. Look at FlexCelError.​Pdf​Font​License​Doesnt​Allow​Embedding for more information.
    TPdfFontNotFound​Error This class has information for a FlexCelError.​Pdf​Font​NotFound error. Look at FlexCelError.​Pdf​Font​NotFound for more information.
    TPdfGlyphNot​InFont​Error This class has information for a FlexCelError.​Pdf​Glyph​NotIn​Font error. Look at FlexCelError.​Pdf​Glyph​NotIn​Font for more information.
    TPdfUsedFallback​Font​Error This class has information for a FlexCelError.​Pdf​Used​Fallback​Font error. Look at FlexCelError.​Pdf​Used​Fallback​Font for more information.
    TPieChartOptions Options specific for a Pie chart.
    TPresetShadowEffect Applies a preset shadow effect.
    TPrinterDriver​Settings 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.
    TRecoveryInvalid​Format This error happens when in recovery mode and a format has invalid data.
    TRecoveryInvalid​Formula​Tokens This error happens when in recovery mode and a formula has invalid data.
    TRecoveryInvalid​Name​Error 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.
    TRenderCorrupt​Image​Error This class has information for a FlexCelError.​Render​Corrupt​Image error. Look at FlexCelError.​Render​Corrupt​Image for more information.
    TRenderError​Drawing​Image​Error This class has information for a FlexCelError.​Render​Error​Drawing​Image error. Look at FlexCelError.​Render​Error​Drawing​Image for more information.
    TRenderGeneric​Preview​Error This class has information for a FlexCelError.​Render​Generic​Preview error. Look at FlexCelError.​Render​Generic​Preview for more information.
    TRenderMetafileError This class has information for a FlexCelError.​Render​Metafile error. Look at FlexCelError.​Render​Metafile 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[​TShape​Option.​xxx]​;
    TShapeProperties A class describing an Excel graphics object.
    TSharedWorkbook​Protection​Options Options for protecting the change list in a shared workbook. In Excel you can change this settings in Protection->Protect Shared Workbook.
    TSheetProtection​Options 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, TTokenRelative​Cell​Address, TTokenRelative​Cell​Range 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.
    TTokenLambda​Parameter​Definition A parameter definition in the expression of a =LET or =LAMBDA function, like the first x in the formula: "=LET(x,3,x+3)"
    TTokenLambda​Parameter​Reference 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.
    TTokenMissing​Argument 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!
    TTokenRelative​Cell​Address 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.
    TTokenRelative​Cell​Range A range of cells with relative references. This is used mostly in named ranges.
    TTokenStructured​Reference A reference for a cell in a table. For example the reference in the formula =SUM(​Table1[​[​#​All]​,[​Some​Column]​]​)
    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.
    TUILinearGradient​Brush 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.
    TUnknownBlip​Transform 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.
    TUnsupported​Formula​List 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)
    TWorkbookProtection​Options 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.​Load​Linked​File 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.
    TXlsTooManyPage​Breaks​Error This class has information for a FlexCelError.​Xls​TooMany​Page​Breaks error. Look at FlexCelError.​Xls​TooMany​Page​Breaks for more information.
    TXlsxInvalid​Name​Error This class has information for a FlexCelError.​Xlsx​Invalid​Name error. Look at FlexCelError.​Xlsx​Invalid​Name for more information.
    TXlsxMissing​Part​Error This class has information for a FlexCelError.​Xlsx​Missing​Part error. Look at FlexCelError.​Xlsx​Missing​Part 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.
    VirtualCellEnd​Reading​Event​Args Arguments passed in the event.
    VirtualCellRead​Event​Args Arguments passed in the event.
    VirtualCellStart​Reading​Event​Args 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.
    TCellAddress​With​File​Name Encapsulates a cell address and the file where the cell is stored.
    TCellMergedState This struct is used in ExcelFile.​Cell​Merged​Next to keep track of the next merged cell that will be iterated.
    TCharAndPos A simple structure containing a position and a character.
    TChartPlotArea​Position Defines the rectangle where a chart element is positioned.
    TChartRelative​Rectangle 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.
    TConditional​Format​Custom​IconDef This structure holds a single icon from a specific icon set.
    TDataLabelsRange Encapsulates the data for a range of text used in labels
    TDocumentCustom​Property 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.
    TDrawingConditional​Format​DataBar 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.
    TDrawingConditional​Format​IconSet 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
    TDrawingParagraph​Properties 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.
    TDrawingText​Attributes Group of simple attributes for text properties.
    TDrawingText​Paragraph A paragraph in the text inside a drawing. This struct is immutable.
    TDrawingText​Properties 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.
    TLoopOverUsed​Range​Parameters This structure contains the parameters passed in ExcelFile.​Loop​Over​Used​Range
    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.
    TTableColumn​Definition 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.​Interpolation​Mode 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.​Smoothing​Mode.​
    TUITextDecoration Defines appearance of decorative lines used in text, like underline or strikeout.
    TXlsChartLabel​Position 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.
    IUserDefined​Function​Aggregator 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.
    FlexCelClipboard​Format 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.
    FlexCelGraphic​Framework 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.​Graphic​Framework
    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.​Get​Internal​Name
    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.
    TCellIndentation​Rendering 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.
    TChartErrorBar​BarType Specifies the possible ways to draw an error bar.
    TChartErrorBar​Direction Direction of an Error bar in a chart.
    TChartErrorBar​Error​Type Error amount type for the error bar.
    TChartLabelPosition​Mode 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.
    TChartLegend​Placement 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.
    TCollapseChildren​Mode 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.
    TConditional​Format​Kind Defines which kind of conditional formatting the rule contains.
    TConditionType A list of conditional operators that you can apply in a Conditional format.
    TContentTransfer​Encoding 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.
    TDataConnection​Credential​Method Credentials method used for server access.
    TDataConnection​Field​Type 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.
    TDataConnection​File​Type The file type being used for text import.
    TDataConnection​Html​Format How to handle formatting from the HTML source.
    TDataConnection​Parameter​Type Specifies how a parameter is refreshed.
    TDataConnection​Qualifier Qualifier to use to denote string data types in when text is imported from an external file.
    TDataConnection​Reconnection​Method 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.
    TDataValidation​Condition​Type Defines the condition used in the data validation box.
    TDataValidation​Data​Type 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.
    TDataValidation​ImeMode The IME (input method editor) mode enforced by a data validation.
    TDateUnits Date units for a date axis.
    TDocumentCustom​Property​Type 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.
    TDrawingText​Capitalization how text is capitalized when rendered.
    TDrawingTextStrike How the text is stroke out.
    TDrawingUnderline​Style 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.
    TExcelFileError​Actions 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.​Save​ForHashing(​​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)
    TFlexCelImage​Horiz​Align Sets how an image is aligned inside a box.
    TFlexCelImage​Vert​Align 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)
    TFlxFormulaError​Value 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 "(​TFormatting​Type)​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
    TFullRecalcOn​Load​Mode 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.
    TListBoxSelection​Type 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 TPrinterDriver​Settings 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.
    TPresetShadow​Effect​Type 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 InsertAndCopy​Range.​
    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.​Formula​Reference​Style 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.
    TShapePreset​Guide​Type 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
    TTokenWhitespace​Character Character used in the whitespace.
    TTokenWhitespace​Position 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.
    TUnsupported​Formula​Error​Type Types of error that might happen while recalculating.
    TUserDefined​Function​Location Defines where the custom function is located, if inside a macro in the same file, or inside a macro in an external file.
    TUserDefined​Function​Scope 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
    CultureCreating​Event​Handler Delegate for CultureCreating events. Return null to use the culture that would have been used had this event not be assigned.
    FlexCelError​Event​Handler Delegate for ErrorInfo events.
    FontCreatedEvent​Handler Delegate for FontCreated events.
    FontCreating​Event​Handler Delegate for FontCreating events.
    HtmlFontEventHandler Delegate used to specify which fonts to use on a page.
    LoadLinkedFile​Event​Handler Delegate for LoadLinkedFile event.
    OnPasswordEvent​Handler This event fires when opening an encrypted file and no password has been supplied.
    OnSheetNameEvent​Handler Delegate used to specify which name to use for every sheet when exporting multiple sheets to multiple files.
    VirtualCellEnd​Reading​Event​Handler Delegate for virtual cell reads. This delegate is called after the full file has been read.
    VirtualCellRead​Event​Handler Delegate for virtual cell reads.
    VirtualCellStart​Reading​Event​Handler Delegate for virtual cell reads. It is called before we start reading the file, but after sheet names are known.
    In This Article
    Back to top FlexCel Studio for the .NET Framework v7.24.0.0
    © 2002 - 2025 tmssoftware.com