- 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
- Cells
- CellTypeConverter
- CheckBoxCellType
- ColorFilterItem
- Column
- ColumnFooter
- ColumnHeader
- ColumnHeaderFilterCellType
- Columns
- Columns.DefaultColumn
- ColumnSparklineRenderer
- 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
- DatabarConditionalFormattingRule
- DataFieldConverter
- 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
- Constructors
- Events
- Fields
-
Methods
- AddedControl
- AddParsedSubObject
- CancelEdit
- CreateChildControls
- CreateDesignView
- DataBind
- Dispose
- FindControl
- FlushData
- GetColumnIndex
- GetEditValue
- GetExcelSheetNames
- GetImage
- GetMergeCell
- GetMergeCells
- GetPageIndex
- GetRowIndex
- GetTabText
- GoalSeek
- GotoPage
- Group
- IsExcelFile
- IsExcelStream
- IsStrictMode
- LoadFormulas
- LoadViewState
- MoveColumn
- MoveRow
- OnAdd
- OnAggregate
- OnButtonCmd
- OnCancel
- OnCellClick
- OnChildView
- OnColumnHeaderClick
- OnDelete
- OnEdit
- OnExpandView
- OnFirstPage
- OnInit
- OnInsert
- OnLastPage
- OnLoad
- OnLoadOnDemand
- OnMenuItemClicked
- OnNextPage
- OnPage
- OnPreRender
- OnPrevPage
- OnPrint
- OnPrintAbort
- OnPrintBackground
- OnPrintExternalImage
- OnPrintExternalImageEnd
- OnPrintPDF
- OnRowHeaderClick
- OnSaveExcel
- OnSelect
- OnSelectView
- OnSortColumn
- OnTabLeft
- OnTabRight
- OnTouchStripItemClicked
- OnUpdate
- OnUpdateDownLevel
- OnUpdateRenderEditors
- OnUpdateRowEditTemplate
- OnUpdateUpperLevel
- Open
- OpenExcel
- RecreateControl
- Regroup
- RemovedControl
- RemoveGroup
- Render
- RenderBeginTag
- RenderChildren
- RenderControl
- RenderEndTag
- Reset
- Save
- SaveChanges
- SaveExcel
- SaveExcelToResponse
- SavePdf
- SavePdfToResponse
- SaveViewState
- Search
- SearchHeaders
- SetImage
- SetProtect
- TrackViewState
- UpdateView
- Validate
- Properties
- 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
- 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
- Delegates
- Enums
- Interfaces
- Structs
-
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.FpSpread.GetExcelSheetNames
GetExcelSheetNames Method
GetExcelSheetNames(string)
Gets an array of sheet names from the specified Excel file.
Declaration
public static string[] GetExcelSheetNames(string fileName)Public Shared Function GetExcelSheetNames(fileName As String) As String()Parameters
| Type | Name | Description |
|---|---|---|
| string | fileName | Path and filename of Excel file |
Returns
| Type | Description |
|---|---|
| string[] |
GetExcelSheetNames(string, string)
Gets an array of sheet names from the specified Excel file.
Declaration
public static string[] GetExcelSheetNames(string fileName, string password)Public Shared Function GetExcelSheetNames(fileName As String, password As String) As String()Parameters
| Type | Name | Description |
|---|---|---|
| string | fileName | Path and filename of Excel file |
| string | password | The password |
Returns
| Type | Description |
|---|---|
| string[] |
GetExcelSheetNames(Stream)
Gets an array of sheet names from the specified Excel file from a stream.
Declaration
public static string[] GetExcelSheetNames(Stream stream)Public Shared Function GetExcelSheetNames(stream As Stream) As String()Parameters
| Type | Name | Description |
|---|---|---|
| Stream | stream | Stream that contains an Excel Compound Storage file |
Returns
| Type | Description |
|---|---|
| string[] |
GetExcelSheetNames(Stream, string)
Gets an array of sheet names from the specified Excel file from a stream.
Declaration
public static string[] GetExcelSheetNames(Stream stream, string password)Public Shared Function GetExcelSheetNames(stream As Stream, password As String) As String()Parameters
| Type | Name | Description |
|---|---|---|
| Stream | stream | Stream that contains an Excel Compound Storage file |
| string | password | The password |
Returns
| Type | Description |
|---|---|
| string[] |