- FarPoint.CalcEngine Assembly
- FarPoint.Excel Assembly
- FarPoint.Web.Chart Assembly
-
FarPoint.Web.Spread Assembly
-
FarPoint.Web.Spread
-
Classes
- AlternatingRow
- AlternatingRows
- Appearance
- AppearanceProperty
- AutoFilter
- AutoFilteredColumnEventArgs
- AutoFilteringColumnEventArgs
- AverageConditionalFormattingRule
- Background
- BaseCellType
- BaseDropDownCellType
- BaseFilterItem
- BaseSparkline
- BestFitColumnRule
- BetweenValuesConditionalFormattingRule
- BlankConditionalFormattingRule
- Border
- BorderProperty
- ButtonCellType
- CalendarDropDownStyleInfo
- Cell
- CellTypeConverter
- Cells
- CheckBoxCellType
- ColorFilterItem
- Column
- ColumnFooter
- ColumnHeader
- ColumnHeaderFilterCellType
- ColumnSparklineRenderer
- Columns
- Columns.DefaultColumn
- ComboBoxCellType
- CommandBarInfo
- ConditionalFormat
- ConditionalFormatCollection
- ConditionalFormatInfo
- ConditionalFormatting
- ConditionalFormattingColorValue
- ConditionalFormattingColorValueCollection
- ConditionalFormattingIconRuleSet
- ConditionalFormattingIconValue
- ConditionalFormattingModel
- ConditionalFormattingModelEventArgs
- ConditionalFormattingRule
- ConditionalFormattingRulePropertyChangedEventArgs
- ConditionalFormattingValue
- ConditionalFormattingValueCollection
- ContextMenu
- ContextMenuCollection
- ContextMenuStyle
- CreateButtonEventArgs
- CreateChildViewEventArgs
- CurrencyCellType
- CurrencyCellType.EditModeSettings
- CustomFilterItem
- DataFieldConverter
- DatabarConditionalFormattingRule
- DateTimeCellType
- DateTimeCellType.EditModeSettings
- DefaultFilterItem
- DefaultRowFilter
- DefaultSkins
- DefaultSparklineContainer
- DefaultStyleCollection
- DesignTimeCellTypeConverter
- DoubleCellType
- DoubleCellType.EditModeSettings
- DynamicFilterItem
- EmptyCellType
- ErrorConditionalFormattingRule
- ErrorForm
- ExcelBaseSparkLineRenderer
- ExcelSparkline
- ExcelSparklineGroup
- ExcelSparklineSetting
- ExpressionConsumerFormulaInfo
- ExtraRendererSettings
- FetchGroupTextEventArgs
- FilterBar
- FilterBarCellType
- FilterColumnDefinition
- FilterColumnDefinitionCollection
- FilterCondition
- FilterItemCollection
- FilterItemValue
- FilterItemValueCollection
- FloatingObject
- FormulaConditionalFormattingRule
- FormulaEntry
- FormulaEntryCollection
- FormulaExtender
- FormulaRestrictedException
- FpSpread
- FpSpreadTemplateReplacement
- GeneralCellType
- GroupInfo
- GroupInfoCollection
- GroupingEventArgs
- HideRowFilter
- HierBarInfo
- HighlightConditionalFormattingRule
- HighlightConditionalFormattingStyle
- HyperLinkCellType
- IconFilterItem
- IconSetConditionalFormattingRule
- ImageCellType
- Inset
- IntegerCellType
- IntegerCellType.EditModeSettings
- ItemEventArgs
- ItemEventArgs<T>
- ItemPropertyEventArgs<T>
- ItemTrackedEventArgs
- LabelCellType
- LandscapeRule
- LayoutCell
- LayoutCells
- LayoutColumn
- LayoutColumns
- LayoutRow
- LayoutRows
- LayoutTemplate
- LineSparklineRenderer
- ListBoxCellType
- ListItem
- MeasureIconSizeEventArgs
- MenuItem
- MenuItemClickEventArgs
- MenuItemCollection
- MultiColumnComboBoxCellType
- MultiValuesFilterItem
- NamedStyle
- NamedStyleCollection
- NamedStyleCollectionEventArgs
- PagerInfo
- ParentStyleNameConverter
- PercentCellType
- PrePaintConditionalFormattingRule
- PrePaintResult
- PrePaintTextConditionalFormattingRule
- PrePaintTextResult
- PreviewRowInfo
- PreviewRowTemplateContainer
- PrintAbortEventArgs
- PrintBackgroundEventArgs
- PrintEventArgs
- PrintExternalImageEventArgs
- PrintInfo
- PrintMargin
- PrintPDFEventArgs
- PropertyTrackChangedEventArgs
- RadioButtonListCellType
- RangeElement<T>
- RegExpCellType
- ReloadSheetCellRangeFormulaEventArgs
- Row
- RowEditTemplateContainer
- RowHeader
- Rows
- Rows.DefaultRow
- SaveExcelEventArgs
- ScaleRule
- SheetCorner
- SheetSkin
- SheetStyleProperty
-
SheetView
- Constructors
- Fields
- Properties
-
Methods
- AddChart
- AddColumns
- AddImage
- AddRowToDataSource
- AddRows
- AddSpanCell
- AddSparkline
- AddSquareSparkline
- AddUnboundRows
- AutoFilterColumn
- AutoFilterReset
- ClearConditionalFormating
- ClearConditionalFormatings
- ClearRange
- ClearRowFilter
- ClearSparklineGroupsInRange
- ClearSparklines
- CreateColumnAxisModel
- CreateDataModel
- CreateRowAxisModel
- CreateSelectionModel
- CreateSpanModel
- CreateStyleModel
- ExpandAll
- ExpandRow
- FindChildView
- FirePropertyChanged
- FlushData
- GetCellFromTag
- GetCellType
- GetChildRelation
- GetChildView
- GetChildViewName
- GetChildVisible
- GetClip
- GetClipValue
- GetColumnAllowFilter
- GetColumnAutoText
- GetColumnFromTag
- GetColumnLabel
- GetColumnMerge
- GetColumnSizeable
- GetColumnSortIndicator
- GetColumnVisible
- GetColumnWidth
- GetConditionalFormatting
- GetCustomName
- GetDataKey
- GetDefaultEditor
- GetDefaultRenderer
- GetDropDownFilterItems
- GetEditor
- GetExpression
- GetFormatter
- GetFormula
- GetGroupFooterInfo
- GetGroupInfo
- GetModelColumnFromViewColumn
- GetModelRowFromViewRow
- GetNote
- GetRenderer
- GetRowAutoText
- GetRowExpandable
- GetRowFromTag
- GetRowHeight
- GetRowLabel
- GetRowMerge
- GetRowSizeable
- GetRowVisible
- GetSelections
- GetSpanCell
- GetSparkline
- GetStyleInfo
- GetTag
- GetText
- GetUnboundValue
- GetValidConditionalFormat
- GetValue
- GetViewColumnFromModelColumn
- GetViewRowFromModelRow
- GroupSparkline
- InitPropArray
- InitStyle
- InvalidateRowFilter
- IsColumnBound
- IsRowBound
- IsRowExpanded
- LoadFormulas
- LoadTextFile
- LoadViewState
- MoveColumn
- MoveRow
- OnAddColumnFooterRows
- OnAddColumnHeaderRows
- OnAddColumns
- OnAddRowHeaderColumns
- OnAddRows
- OnDataModelChanged
- OnRemoveColumnFooterRows
- OnRemoveColumnHeaderRows
- OnRemoveColumns
- OnRemoveRowHeaderColumns
- OnRemoveRows
- Open
- OpenExcel
- Recalculate
- RecalculateAll
- RemoveColumns
- RemoveRows
- RemoveSpanCell
- Reset
- ResetViewColumnIndexes
- ResetViewRowIndexes
- Save
- SaveHtml
- SaveTextFile
- SaveTextFileRange
- SaveViewState
- SetChildVisible
- SetClip
- SetClipValue
- SetColumnLabel
- SetColumnMerge
- SetColumnSizeable
- SetColumnSortIndicator
- SetColumnVisible
- SetColumnWidth
- SetConditionalFormatting
- SetExpression
- SetFormula
- SetModelDataColumn
- SetNote
- SetRowExpandable
- SetRowHeight
- SetRowLabel
- SetRowMerge
- SetRowSizeable
- SetRowVisible
- SetStyleInfo
- SetTag
- SetText
- SetValue
- ShouldSerializePrintInfo
- Sort
- SortColumns
- SortRows
- ToString
- UngroupSparkline
- SheetViewCollection
- SheetViewStateEventArgs
- SmartPaperRule
- SmartPrintRule
- SmartPrintRulesCollection
- SortInfo
- Sparkline
- SparklineModelUpdateEventArgs
- SpreadCommandEventArgs
- SpreadControlBuilder
- SpreadDataSource
- SpreadDataSourceView
- SpreadFontStyle
- SpreadImage
- SpreadImageCollection
- SpreadImageCollectionEditor
- SpreadImageRender
- SpreadSparklineRenderes
- StateList<T>
- StateManaged
- StyleInfo
- StyleNameConverter
- StyleRowFilter
- TabInfo
- TagCloudCellType
- TextCellType
- TextConditionalFormattingRule
- ThreeColorScaleConditionalFormattingRule
- TimePeriodConditionalFormattingRule
- TitleInfo
- Top10FilterItem
- TopRankedValuesConditionalFormattingRule
- TouchInfo
- TouchStrip
- TouchStripCollection
- TouchStripItem
- TouchStripItemClickEventArgs
- TouchStripItemCollection
- TwoColorScaleConditionalFormattingRule
- UnaryComparisonConditionalFormattingRule
- UniqueOrDuplicatedConditionalFormattingRule
- ValidatorCollection
- WinLossSparklineRenderer
- WorksheetLayoutCell
- WorksheetLayoutCells
- WorksheetTemplate
- YearMonthFormat
- Structs
- Enums
- Interfaces
- Delegates
-
Classes
- FarPoint.Web.Spread.Chart
- FarPoint.Web.Spread.Data
- FarPoint.Web.Spread.Editor
- FarPoint.Web.Spread.Model
- FarPoint.Web.Spread.Renderer
-
FarPoint.Web.Spread
- FarPoint.Web.Spread.Extender Assembly
FarPoint.Web.Spread.SheetView.OpenExcel
OpenExcel Method
OpenExcel(string, string)
Opens an Excel file and loads the specified Excel sheet into this sheet.
Declaration
public bool OpenExcel(string fileName, string sheetName)Public Function OpenExcel(fileName As String, sheetName As String) As BooleanParameters
| Type | Name | Description |
|---|---|---|
| string | fileName | Name of the file to open |
| string | sheetName | Name of the sheet in the Excel file to load |
Returns
| Type | Description |
|---|---|
| bool |
OpenExcel(string, int)
Opens an Excel file and loads the specified Excel sheet into this sheet.
Declaration
public bool OpenExcel(string fileName, int excelSheetIndex)Public Function OpenExcel(fileName As String, excelSheetIndex As Integer) As BooleanParameters
| Type | Name | Description |
|---|---|---|
| string | fileName | Name of the file to open |
| int | excelSheetIndex | Index of the sheet in the Excel file to load |
Returns
| Type | Description |
|---|---|
| bool |
Exceptions
| Type | Condition |
|---|---|
| ExcelException | Specified sheet in Excel is invalid; index must be between 0 and the number of sheets |
OpenExcel(Stream, string)
Opens an Excel file and load the specified Excel sheet into this sheet.
Declaration
public bool OpenExcel(Stream stream, string sheetName)Public Function OpenExcel(stream As Stream, sheetName As String) As BooleanParameters
| Type | Name | Description |
|---|---|---|
| Stream | stream | Stream containing an Excel Compound Document File |
| string | sheetName | Name of sheet in Excel to load |
Returns
| Type | Description |
|---|---|
| bool |
OpenExcel(Stream, int)
Opens an Excel file and loads the specified Excel sheet into this sheet.
Declaration
public bool OpenExcel(Stream stream, int excelSheetIndex)Public Function OpenExcel(stream As Stream, excelSheetIndex As Integer) As BooleanParameters
| Type | Name | Description |
|---|---|---|
| Stream | stream | Stream containing an Excel Compound Document File |
| int | excelSheetIndex | Index of the Excel sheet to load |
Returns
| Type | Description |
|---|---|
| bool |
Exceptions
| Type | Condition |
|---|---|
| ExcelException | Specified sheet in Excel is invalid; index must be between 0 and the number of sheets |
OpenExcel(Stream, string, ExcelOpenFlags)
Opens an Excel file and loads the specified Excel sheet into this sheet.
Declaration
public bool OpenExcel(Stream stream, string sheetName, ExcelOpenFlags excelOpenFlags)Public Function OpenExcel(stream As Stream, sheetName As String, excelOpenFlags As ExcelOpenFlags) As BooleanParameters
| Type | Name | Description |
|---|---|---|
| Stream | stream | Stream that contains an Excel Compound Document File |
| string | sheetName | Name of sheet in Excel to load |
| ExcelOpenFlags | excelOpenFlags | Flags to specify file open options |
Returns
| Type | Description |
|---|---|
| bool |
OpenExcel(Stream, string, ExcelOpenFlags, string)
Opens an Excel file and loads the specified Excel sheet into this sheet.
Declaration
public bool OpenExcel(Stream stream, string sheetName, ExcelOpenFlags excelOpenFlags, string password)Public Function OpenExcel(stream As Stream, sheetName As String, excelOpenFlags As ExcelOpenFlags, password As String) As BooleanParameters
| Type | Name | Description |
|---|---|---|
| Stream | stream | Stream that contains an Excel Compound Document File |
| string | sheetName | Name of sheet in Excel to load |
| ExcelOpenFlags | excelOpenFlags | Flags to specify file open options |
| string | password | The password |
Returns
| Type | Description |
|---|---|
| bool |
OpenExcel(Stream, int, ExcelOpenFlags)
Opens an Excel file and loads the specified Excel sheet into this sheet.
Declaration
public bool OpenExcel(Stream stream, int excelSheetIndex, ExcelOpenFlags excelOpenFlags)Public Function OpenExcel(stream As Stream, excelSheetIndex As Integer, excelOpenFlags As ExcelOpenFlags) As BooleanParameters
| Type | Name | Description |
|---|---|---|
| Stream | stream | Stream that contains an Excel Compound Document File |
| int | excelSheetIndex | Index of the Excel sheet to load |
| ExcelOpenFlags | excelOpenFlags | Flags to specify file open options |
Returns
| Type | Description |
|---|---|
| bool |
OpenExcel(Stream, int, ExcelOpenFlags, string)
Opens an Excel file and loads the specified Excel sheet into this sheet.
Declaration
public bool OpenExcel(Stream stream, int excelSheetIndex, ExcelOpenFlags excelOpenFlags, string password)Public Function OpenExcel(stream As Stream, excelSheetIndex As Integer, excelOpenFlags As ExcelOpenFlags, password As String) As BooleanParameters
| Type | Name | Description |
|---|---|---|
| Stream | stream | Stream that contains an Excel Compound Document File |
| int | excelSheetIndex | Index of the Excel sheet to load |
| ExcelOpenFlags | excelOpenFlags | Flags to specify file open options |
| string | password | The password |
Returns
| Type | Description |
|---|---|
| bool |
OpenExcel(string, string, ExcelOpenFlags)
Opens an Excel file and loads the specified Excel sheet into this sheet.
Declaration
public bool OpenExcel(string fileName, string sheetName, ExcelOpenFlags excelOpenFlags)Public Function OpenExcel(fileName As String, sheetName As String, excelOpenFlags As ExcelOpenFlags) As BooleanParameters
| Type | Name | Description |
|---|---|---|
| string | fileName | Name of the file to open |
| string | sheetName | Name of the sheet in the Excel file to load |
| ExcelOpenFlags | excelOpenFlags | Flags to specify file open options |
Returns
| Type | Description |
|---|---|
| bool |
OpenExcel(string, string, ExcelOpenFlags, string)
Opens an Excel file and loads the specified Excel sheet into this sheet.
Declaration
public bool OpenExcel(string fileName, string sheetName, ExcelOpenFlags excelOpenFlags, string password)Public Function OpenExcel(fileName As String, sheetName As String, excelOpenFlags As ExcelOpenFlags, password As String) As BooleanParameters
| Type | Name | Description |
|---|---|---|
| string | fileName | Name of the file to open |
| string | sheetName | Name of the sheet in the Excel file to load |
| ExcelOpenFlags | excelOpenFlags | Flags to specify file open options |
| string | password | The password |
Returns
| Type | Description |
|---|---|
| bool |
OpenExcel(string, int, ExcelOpenFlags)
Opens an Excel file and loads the specified Excel sheet into this sheet.
Declaration
public bool OpenExcel(string fileName, int excelSheetIndex, ExcelOpenFlags excelOpenFlags)Public Function OpenExcel(fileName As String, excelSheetIndex As Integer, excelOpenFlags As ExcelOpenFlags) As BooleanParameters
| Type | Name | Description |
|---|---|---|
| string | fileName | Name of the file to open |
| int | excelSheetIndex | Index of the sheet in the Excel file to load |
| ExcelOpenFlags | excelOpenFlags | Flags to specify file open options |
Returns
| Type | Description |
|---|---|
| bool |
OpenExcel(string, int, ExcelOpenFlags, string)
Opens an Excel file and loads the specified Excel sheet into this sheet.
Declaration
public bool OpenExcel(string fileName, int excelSheetIndex, ExcelOpenFlags excelOpenFlags, string password)Public Function OpenExcel(fileName As String, excelSheetIndex As Integer, excelOpenFlags As ExcelOpenFlags, password As String) As BooleanParameters
| Type | Name | Description |
|---|---|---|
| string | fileName | Name of the file to open |
| int | excelSheetIndex | Index of the sheet in the Excel file to load |
| ExcelOpenFlags | excelOpenFlags | Flags to specify file open options |
| string | password | The password |
Returns
| Type | Description |
|---|---|
| bool |
- OpenExcel Method
- OpenExcel(string, string)
- Declaration
- Parameters
- Returns
- OpenExcel(string, int)
- Declaration
- Parameters
- Returns
- Exceptions
- OpenExcel(Stream, string)
- Declaration
- Parameters
- Returns
- OpenExcel(Stream, int)
- Declaration
- Parameters
- Returns
- Exceptions
- OpenExcel(Stream, string, ExcelOpenFlags)
- Declaration
- Parameters
- Returns
- OpenExcel(Stream, string, ExcelOpenFlags, string)
- Declaration
- Parameters
- Returns
- OpenExcel(Stream, int, ExcelOpenFlags)
- Declaration
- Parameters
- Returns
- OpenExcel(Stream, int, ExcelOpenFlags, string)
- Declaration
- Parameters
- Returns
- OpenExcel(string, string, ExcelOpenFlags)
- Declaration
- Parameters
- Returns
- OpenExcel(string, string, ExcelOpenFlags, string)
- Declaration
- Parameters
- Returns
- OpenExcel(string, int, ExcelOpenFlags)
- Declaration
- Parameters
- Returns
- OpenExcel(string, int, ExcelOpenFlags, string)
- Declaration
- Parameters
- Returns