Spread Windows Forms 14.0
FarPoint.Excel Assembly / FarPoint.Excel Namespace
Inheritance Hierarchy
In This Topic
    FarPoint.Excel Namespace
    In This Topic
    Classes
     ClassDescription
    ClassID Number 0X1050 4176 This record specifies rich text formatting within chart titles, trendline, and data labels.
    ClassID Number 0x101A 4122 This record specifies that the chart group is an area chart group and specifies the chart group attributes.
    ClassID Number 0x100A 4106 This record specifies the patterns and colors used in a filled region of a chart.
    ClassID NumBer 0x100C 4108 Specify properties of a data label on a chart group, series, or data point.
    ClassID Number 0x1062 4194 This record specifies additional extension properties of a date axis, along with a CatSerRange record.
    ClassID Number 0x1046 4166 This record specifies the number of axis groups on the chart.
    ClassID Number 0x101D 4125 This record specifies properties of an axis
    ClassID Number 0x1021 4129 This record specifies which part of the axis is specified by the LineFormat record that follows.
    ClassID Number 0x1041 4161 This record specifies properties of an axis group.
    ClassID Number 0x1017 4119 This record specifies that the chart group is a bar chart group or a column chart group, and specifies the chart group attributes.
    ClassThis record specifies the beginning of a collection of records as defined by the Chart Sheet SubStream ABNF.
    ClassThis structure specifies either a Boolean value or an error value.
    Class 
    ClassID Number 0x201 513 This record specifies an empty cell with no formula or value.
    ClassRepresents the blip to fill the drawing object.
    Class 
    Class 
    ClassID Number 0x205 517 This record specifies a cell that contains either a Boolean value or an error value.
    ClassID Number 0x1061 4193 This record specifies that the chart group is a bar of pie chart group or a pie of pie chart group and specifies the chart group attributes.
    ClassIt needs to consider more!!!!!!!! ID Number 0x1067 4199 This record specifies which data points in the series are contained in the secondary bar/pie instead of the primary pie.
    ClassBorder - Excel 12
    ClassBorder side - Excel 12
    Class 
    ClassDefault Pattern and compound array settings for the pens used to draw borders in the ComplexBorder class.
    Class 
    Class 
    ClassID Number 0x1051 4177 This record specifies a reference to data in a sheet that is used by a part of a series, legend entry, trendline or error bars.
    ClassID Number 0x856 2134 This record specifies the attributes of the axis label.
    ClassID Number 0x1020 4128 This record specifies the properties of a category (3) axis, a date axis, or a series axis.
    ClassThis structure specifies a cell in the current sheet.
    ClassThis structure specifies a color in conditional formatting records or in a SheetExt record.
    ClassID Number 0x1002 4098 position and size of the chart area the beginning of a collection of records as defined by the Chart Sheet SubStream ABNF.
    ClassID Number 0x103A 4154 This record specifies that the plot area of the chart group is rendered in a 3-D scene and also specifies the attributes of the 3-D plot area. The preceding chart group type MUST be of type bar, pie, line, area, or surface.
    ClassID Number 0x105F 4191 Specify the shape of the data points in a bar or column chart group. It is used for a bar or column chart group and MUST be ignored for all other chart groups.
    ClassID Number 0x1014 4116 The record specifies properties of a chart group
    ClassThis structure specifies a formula used in a chart.
    ClassID Number 0x105C 4188 Specify a custom color palette for a chart Sheet.
    ClassThis record specifies the name of a workbook object, a sheet object in the VBA project located in this file. If this record is in the Globals Substream, the name is for the workbook object. If this record is in a Chart Sheet Substream, the name is for the chart sheet object representing the sheet. If this record is in a Macro Sheet Substream, the name is for the macro sheet object representing the sheet. If this record is in a Dialog Sheet Substream, the name is for the the dialog sheet object representing the sheet. If this record is in a Worksheet Substream, the name is for the worksheet object representing the sheet.
    Class 
    ClassID Number 0x87F 2131 This record specifies a continuation of the data in a preceding Future Record Type record that has data longer than 8,224 bytes.
    Class 
    Class 
    ClassID Number 0x89D 2205 This record specifies the layout information for attached label, when contained in the sequence of records that conforms to the ATTACHEDLABEL rule, or legend, when contained in the sequence of records that conforms to the LD rule.
    ClassID Number 0x8A7 2215 This record specifies layout information for a plot area.
    ClassID Number 0x101C 4124 This record specifies the presence of drop lines, high-low lines, series lines or leader lines on the chart group.
    ClassID Number 0x1022 4130 This record is written but unused.
    ClassID Number 0x89E 2206 Specify additional properties for chart elements, as specified by the Chart Sheet SubStream ABNF. These properties complement the record to which they correspond, and are stored as a structure chain defined in XmlTkChain.
    ClassID Number 0x89F 2207 Specifies additional data for a CrtMlFrt record, as specified in the CrtMlFrt record.
    Class 
    Class 
    Class 
    Class 
    Class 
    ClassID Number 0x1063 4195 This record specifies the beginning of a collection of records as defined by the Chart Sheet Substream ABNF.
    ClassID Number 0x1006 4102 Specify the data point or series that the formatting information
    ClassID Number 0x86A 2154 This record specifies the beginning of a collection of records as defined by the Chart Sheet SubStream ABNF.
    ClassID Number 0x86B 2155 Specify the contents of an extended data label.
    ClassID Number 0x1024 4132 This record specifies the text elements that are formatted using the information specified by the Text record.
    ClassID Number 0x200 512 This record specifies the used range of the sheet. It specifies the row and column bounds of used cells in the sheet. Used cells include all cells with formulas or data.
    ClassRepresents the drawing text and its properties.
    ClassID Number 0x103D 4157 This record specifies the attributes of the up bars or the down bars between multiple series of a line chart group.
    Class 
    ClassThis record specifies the end of a collection of records as defined by the Chart Sheet SubStream ABNF.
    ClassThis record specifies the end of a collection of records.
    ClassID Number 0x855 2133 This record specifies properties of an Future Record Type (FRT) as defined by the Chart Sheet SubStream ABNF.
    ClassEnhancedBorderExcelXFormat class
    Class 
    Class 
    ClassExcel Chart Shape class
    ClassRepresents the exceptions arising from loading or saving Excel files.
    ClassHandles loading from and saving to Excel-compatible files.
    Class 
    ClassRepresents a class which contains some utility functions for Excel I/O.
    ClassThe class for hodling properties of excel note shape.
    ClassExcel Picture Shape Class
    ClassRepresents the Excel shape.
    ClassRepresents the warnings arising from loading or saving Excel files.
    ClassRepresents the collection of warnings generated by loading or saving an Excel file.
    ClassXF class
    ClassUtility method for import or export. Internal use only.
    ClassXml style - Excel 12
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    ClassID Number 0x1060 4192 Specify font information at the time the scalable font is added to the chart.
    ClassID Number 0x1068 4200 Specify font information at the time the scalable font is added to the chart.
    ClassRepresents FeatHdr class
    ClassRepresents FillInfo class
    ClassSpecifies an approximation of a real number, where the approximation has a fixed number of digits after the radix point. Value of the real number = Integral + ( Fractional / 65536.0 )
    ClassThis structure specifies a Font record in the file.
    ClassThis structure specifies a font entry used by the FrtFontList record.
    Class 
    Class 
    ClassSpecify formatting information for a text run.
    ClassID Number 0x1032 4146 This record specifies the type, size and position of the frame around a chart element as defined by the Chart Sheet SubStream ABNF.
    ClassThis structure specifies flags used in future record headers.
    ClassID Number 0x85A 2138 Specify font information used on the chart Specify beginning of a collection of Font records as defined by the Chart Sheet SubStream ABNF.
    ClassThis structure specifies a future record type header.
    ClassThis structure specifies a future record type header.
    ClassAn unsigned integer that specifies the record type identifier.
    ClassThis structure specifies a future record type header.
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    ClassID Number 0x1066 4198 This record specifies the properties of a fill pattern for parts of a chart. Page 299 in MS-XLS
    Class 
    Class 
    Class 
    ClassSkip the Record
    ClassThis record specifies a picture used by a sheet header or footer.
    Class 
    ClassID Number 0X104E 4174 This record specifies the number format to use for the text on an axis.
    Class 
    Class 
    Class 
    ClassID Number 0x1015 4117 This record specifies properties of a legend.
    ClassID Number 0x1043 4163 This record specifies information about a legend entry which has been changed from the default legend entry settings. [CLSCompliant(false)]
    ClassID Number 0x1018 4120 This record specifies that the chart group is a line chart group and specifies the chart group attributes.
    ClassID Number 0x1007 4103 This record specifies the appearance of a line.
    ClassThis structure specifies a color as a combination of red, green, and blue.
    ClassID Number 0x1009 4105 Specify the color, size, and shape of the associated data markers that appear on line, radar, and scatter chart groups.
    Class 
    ClassMsoDrawing If this record appears in chart sheet SubStream, The OfficeArtClientAnchor structure mentioned in [MS-OFFDRAW] refers to OfficeArtClientAnchorChart.
    ClassMsoDrawingGroup
    ClassThis record specifies selected drawing objects and the drawing objects in focus on the sheet.
    ClassThis record specifies how a path is constructed. This record is used in conjunction with MSOPATHINFO and an array of POINT data to build a path.
    ClassRepresents a class which contains common strings which are used by Spread. This is a %[LangWord]static class% and so cannot be inherited or instantiated.
    ClassID Number 0x203 515 This record specifies a cell that contains a floating-point number.
    Class 
    Class 
    ClassID Number 0x1027 4135 Specify an object on a chart, or the entire chart, to which Text is linked.
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    ClassProperties enumeration inner class.
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    ClassID Number 0x92 This record specifies a custom color palette. Palette specifies properties of the color palettes used in the chart sheet.
    Class 
    Class 
    ClassID Number 0x103C 4156 This record specifies the layout of a picture attached to a picture-filled chart element.
    Class 
    Class 
    ClassID Number 0x1019 4121 This record specifies that the chart group is a pie chart group or a doughnut chart group, and specifies the chart group attributes.
    ClassID Number 0x100B 4107 Specify the distance of a data point or data points in a series from the center of one of the following: 1: plot area for a doughnut or pie chart group. 2: primary pie in a pie of pie or bar of pie chart group. 3: secondary bar/pie of a pie of pie chart group.
    ClassID Number 0x859 2137 This record specifies the flags applicable to a Pivot Chart.
    ClassID Number 0x1035 4149 This empty record specifies that the Frame record that immediately follows this record specifies properties of the plot area.
    ClassID Number 0x1064 4196 This record specifies the scale factors to use when calculating the font scaling information for a font in the plot area. If no FBI record exists in the chart sheet where scab is 0x0001, this record is unused and MUST be ignored. Otherwise the values from each FBI record where scab is 0x0001 are used in conjunction with values in this record to render the scaled fonts in the plot area.
    Class 
    Class 
    ClassID Number 0x104F 4175 This record specifies the size and position for a legend, an attached label, or the plot area, as specified by the primary axis group.
    ClassThis record specifies the printed size of the chart.
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    ClassID Number 0x103E 4158 This record specifies that the chart group is a radar chart group and specifies the chart group attributes.
    ClassID Number 0x1040 4160 This record specifies that the chart group is a filled radar chart group and specifies the chart group attributes.
    Class 
    ClassA structure that specifies a range of cells on the sheet.
    ClassA structure that specifies a range of cells on the sheet.
    Class 
    Class 
    Class 
    ClassID Number 0x8A6 2214 This record specifies additional text properties for the text in the entire chart, text in the current legend, text in the current legend entry, or the text in the attached label.
    Class 
    Class 
    Class 
    ClassID Number 0x1048 4168 This record specifies the location of a PivotTable view referenced by a chart.
    ClassID Number 0x101B 4123 This record specifies that the chart group is a scatter chart group or a bubble chart group, and specifies the chart group attributes.
    Class 
    ClassID Number OxA0 160 This record specifies the zoom level of the current view in the window used to display the sheet as a fraction given by the following formula: Fraction = nscl / dscl The fraction MUST be greater than or equal to 1/10 and less than or equal to 4. This record MUST exist if the zoom level of the current view is not equal to 1.
    Class 
    ClassID Number 0x105B 4187 This record specifies properties of an error bar.
    ClassID Number 0x104B 4171 This record specifies a trendline.
    Class 
    Class 
    ClassID Number 0x105D 4189 specify properties of the associated data points, data markers, or lines of the series.
    ClassThis record specifies properties of the data for a series, a trendline, or error bars.
    Class 
    ClassID Number 0x1016 4118 This record specifies the series for the chart.
    ClassID Number 0x100D 4109 Specify the text for a series, TrendLine name, TrendLine label, Axis Title or Chart title.
    Class 
    Class 
    ClassID Number 0x104A 4170 This record specifies the series to which the current trendline or error bar corresponds.
    Class 
    ClassID Number 0x1045 4165 This record specifies the chart group for the current series.
    ClassThis record specifies the page format settings used to print the current sheet.
    ClassID Number 0x8A4 2212 This record specifies the shape formatting properties for chart elements. Page 405
    Class 
    Class 
    Class 
    ClassID Number 0x1044 4164 This record specifies properties of a chart as defined by the Chart Sheet Substream ABNF.
    ClassID Number 0x1065 4197 This record is part of a group of records which specify the data of chart.
    ClassThis record specifies the beginning of a collection of records.
    ClassID Number 0x854 2132 This record specifies beginning of a collection of Future Record Type records as defined by the Chart Sheet SubStream ABNF.
    ClassInternal use only. Represents a SupBook workbook.
    Class 
    ClassID Number 0x103F 4159 This record specifies that the chart group is a surface chart group and specifies the chart group attributes.
    ClassID Number 0x858 2136 this record specifies the name of the source PivotTable view associated with a pivot chart.
    ClassID Number 0x1025 4133 This record specifies the properties of an attached label
    ClassID Number 0x8A5 2213 This record specifies additional text properties for the text in the entire chart, text in the current legend, text in the current legend entry, text in the attached label, or the axis labels of the current axis.
    ClassID Number 0x101E 4126 This record specifies the attributes of the axis labels, major tick marks, and minor tick marks associated with an axis.
    Class 
    ClassA coordinate class made up of sheet, row, column
    ClassIComparer implementation for TriCoord objects
    Class 
    Class 
    Class 
    Class 
    Class 
    ClassThis record MUST be zero, and MUST be ignored.
    ClassID Number 0x101F 4127 This record specifies the properties of a value axis.
    Class 
    ClassRepresents View3DInfo class
    Class 
    Class 
    Class 
    Classinternal only
    Class134
    Class 
    Class 
    ClassThis structure specifies a Unicode string.
    ClassSpecify a Unicode string.
    ClassThis structure specifies a Unicode string. When an XLUnicodeStringNoCch is used, the count of characters in the string MUST be specified in the structure that uses the XLUnicodeStringNoCch.
    Class 
    ClassA chain of structures that specifies a group of additional properties or property overrides for a given chart element, specified by the xmltkParent field. See meanings of the additional properties or property overrides in each token structure.
    Class 
    Class 
    Class 
    ClassID Number 0x857 2135 This record specifies properties of the value multiplier for a value axis.
    ClassFolders and Files stored in the memory
    Interfaces
     InterfaceDescription
    InterfaceRepresents a biff8 structure.
    Interface 
    InterfaceInterface that supports reading or importing from an Excel BIFF file.
    InterfaceInterface that supports reading or importing shared formula from an Excel BIFF file.
    InterfaceInterface that supports getting CalcError from bErr
    InterfaceInterface that supports set shared formula
    InterfaceInterface that supports reading or importing shared formula from an Excel BIFF file.
    InterfaceInterface supports all new features of Win 8E >>NFR-140307 tomhoang 2014/03/07
    InterfaceInterface that supports writing or exporting to an Excel BIFF file.
    InterfaceInterface that supports writing or exporting to an Excel BIFF file.This inherits from IExcelBiffWrite interface.
    InterfaceInterface that supports writing or exporting to an Excel BIFF file.This inherits from IExcelBiffWrite2 interface.
    InterfaceInterface that supports writing or exporting to an Excel BIFF file.This inherits from IExcelBiffWrite3 interface.
    Interface 
    InterfaceInterface that supports exporting to an Excel BIFF file.This inherits from IExcelBiffWrite4 interface.
    Interface 
    Interface 
    InterfaceInterface that supports reading or importing from an Excel BIFF file.
    Interface 
    InterfaceInterface that supports reading or importing from an Excel BIFF file.
    InterfaceInterface that supports reading or importing from an Excel BIFF file.
    InterfaceInterface that supports reading or importing from an Excel BIFF file.
    Interface 
    InterfaceInterface that supports reading or importing from an Excel file.
    InterfaceInterface that supports reading or importing Excel file.
    Interface 
    Interface 
    InterfaceInterface that supports writing or exporting to an Excel Chart.
    Interface 
    InterfaceInterface that supports writing or exporting to an Excel Chart.
    Interface 
    Interface 
    InterfaceInterface support export new chart (chartEx of Excel 2016 and above)
    InterfaceInterface that supports get the generated custom names for new charts during export
    InterfaceInterface that supports specified type of importing: spread or sheet
    InterfaceInterface that supports lossless feature.
    InterfaceInterface that supports lossless feature.
    InterfaceInterface that supports writing or exporting RangeGroupButtonOption.
    InterfaceInterface that supports reading Excel XML.
    InterfaceInterface that supports reading Excel XML.
    InterfaceInterface that supports reading Excel *.xls, *xlsx
    InterfaceInterface that supports import excel with better performance
    Interface 
    InterfaceIExcelSupportFontStyle interface
    InterfaceInterface that supports reading and writing Excel Table XML.
    InterfaceInterface that supports writing Excel XML.
    InterfaceInterface that supports writing Excel XML.
    InterfaceExcelXF interface
    InterfaceInterface that supports reading and writing Excel XML.
    InterfaceInterface that supports reading and writing Excel XML
    InterfaceInterface that supports reading and writing Excel XML
    InterfaceInterface that supports reading and writing Excel XML.
    InterfaceInterface that supports reading and writing Excel XML.
    InterfaceInterface that supports reading and writing Excel XML.
    InterfaceInterface that supports reading and writing Excel XML.
    InterfaceInterface that supports reading Excel XML with optimization.
    InterfaceIndicates an interface which represents a set of functions which are used to get the exporting information of cell.
    InterfaceIndicates an interface which represents a set of functions which are used to get the exporting information of column.
    InterfaceIndicates an interface which represents a set of functions which are used to get the exporting information of row.
    Interface 
    InterfaceIndicates an interface which represents a set of functions which are used to get the exporting information (rows/columns/cells) of the specified SheetView.
    Interface 
    Interface 
    InterfaceIndicates an interface which represents a set of functions which are used to optimize Excel I/O.
    InterfaceInterface that supports specified type of importing: spread or sheet
    Interface 
    InterfaceIndicates an interface which represents a set of functions which are used to optimize memory for Excel export.
    InterfaceSupport workbook and worksheet protection mode.
    InterfaceSupport workbook and worksheet protection mode.
    Interface 
    InterfaceIndicates an interface which represent the way to specify supported product
    InterfaceIndicates an interface which represents multi-threading supportable of a class.
    Interface 
    Enumerations
     EnumerationDescription
    EnumerationShape anchor properties.
    Enumeration 
    Enumeration 
    Enumeration 
    Enumeration 
    Enumeration 
    Enumeration 
    EnumerationBiffRec
    Enumeration 
    Enumeration 
    Enumeration 
    Enumeration 
    EnumerationThis record specifies a layout mode. Each layout mode specifies a different meaning of the x, y, dx, and dy fields of CrtLayout12 and CrtLayout12A.
    EnumerationThe DateUnit enumeration specifies the unit of measurement of a date value.
    EnumerationRepresents the horizontal alignment of the drawing text.
    EnumerationRepresents the rotation angle of the shape text.
    EnumerationRepresents the vertical alignment of the drawing text.
    EnumerationError amount type of the error bars.
    EnumerationSpecifies the values for ExcelException that can be retrieved by accessing the Code property of an ExcelException object.
    EnumerationSpecifies what part of the Excel-compatible file you want to load into the spreadsheet.
    EnumerationSpecifies what part of the spreadsheet to export to an Excel-compatible file.
    EnumerationSpecifies the warnings codes returned in the Code property of ExcelWarning.
    EnumerationSpecifies the type of Excel workbook - used by IsExcelFile and IsExcelStream.
    EnumerationThis enumeration specifies the fill pattern.
    EnumerationformatType enumeration
    Enumeration 
    Enumeration 
    Enumeration 
    Enumeration 
    Enumeration 
    Enumeration 
    Enumeration 
    Enumeration 
    Enumeration 
    Enumeration 
    Enumeration 
    EnumerationThe style of the line.
    Enumeration 
    EnumerationType of data marker
    Enumeration 
    Enumerationmso fill type enumeration.
    EnumerationThe MSOPATHESCAPE Enumeration modifies the path properties by adding elements to a path, providing additional control, or specifying how to handle editing of POINT data.
    EnumerationThe MSOPATHTYPE Enumeration specifies how the individual pieces of a path SHOULD be interpreted.
    Enumerationmso shadow type
    EnumerationMsoShapePath
    Enumeration 
    Enumeration 
    Enumeration 
    Enumeration 
    EnumerationSpecify positioning mode for position information saved in a Pos record.
    EnumerationThis structure specifies a single element of a formula.
    Enumeration 
    Enumeration 
    Enumeration 
    EnumerationShape type enumeration.
    Enumeration 
    EnumerationIndicates an enum that specifies supported product
    Enumeration 
    Enumeration 
    Enumeration 
    EnumerationType of TrendLine
    Enumeration 
    Enumeration 
    EnumerationThis enumeration specifies the color reference types.
    See Also