-
-
GrapeCity.Documents.Excel
-
- IAboveAverage
- IAreas
- IAuthor
- IAutoFilter
- IAutoMergeRangeInfo
- IBarcode
- IBorder
- IBorders
- IBuiltInDocumentPropertyCollection
- ICalcContext
- ICalculatedFields
- ICalculatedItems
- ICascadeSparkLine
- ICellCollection
- ICellColorSortField
- ICellDecoration
- ICellDecorationIcon
- ICellPadding
- ICodabar
- ICode128
- ICode39
- ICode49
- ICode93
- IColorScale
- IColorScaleCriteria
- IColorScaleCriterion
- IColorStop
- IColorStops
- IComment
- IComments
- ICommentsThreaded
- ICommentThreaded
- IConditionValue
- ICornerFold
- ICsvParser
- ICustomDocumentPropertyCollection
- ICustomView
- ICustomViews
- IDataBar
- IDataBarBorder
- IDataMatrix
- IDataOptions
- IDisplayFormat
- IDocumentProperty
- IDocumentPropertyCollection
- IEAN13
- IEAN8
- IExcelOptions
- IFilter
- IFilters
- IFont
- IFontColorSortField
- IFontOption
- IFormatColor
- IFormatCondition
- IFormatConditions
- IFormulaOptions
- IFormulaResolver
- IGraphic
- IGraphicsInfo
- IGroupInfo
- IGS1128
- IHeaderFooter
- IHPageBreak
- IHPageBreaks
- IHyperlink
- IHyperlinks
- IIcon
- IIconCriteria
- IIconCriterion
- IIconSet
- IIconSetCondition
- IIconSets
- IIconSortField
- IInterior
- IJsonSerializer
- ILabelOption
- ILabelOptions
- ILinearGradient
- IName
- INames
- INegativeBarFormat
- IOutline
- IOutlineColumn
- IPage
- IPageSetup
- IPane
- IPanes
- IPDF417
- IPivotAxis
- IPivotCache
- IPivotCaches
- IPivotCell
- IPivotField
- IPivotFields
- IPivotFilter
- IPivotFilters
- IPivotFormula
- IPivotFormulas
- IPivotItem
- IPivotItemList
- IPivotItems
- IPivotLine
- IPivotLineCells
- IPivotLines
- IPivotTable
- IPivotTables
- IPivotValueCell
- IProtectionSettings
- IQRCode
- IRange
- IRangeProvider
- IReadOnlySignatureDetails
- IRectangularGradient
- IRichText
- IScenario
- IScenarios
- ISheetTab
- ISheetTabs
- IShrinkToFitSettings
- ISignature
- ISignatureSet
- ISignatureSetup
- ISlicer
- ISlicerCache
- ISlicerCaches
- ISlicerItem
- ISlicerItems
- ISlicerPivotTables
- ISlicers
- ISort
- ISortField
- ISortFields
- ISparkAxes
- ISparkColor
- ISparkHorizontalAxis
- ISparkline
- ISparklineGroup
- ISparklineGroups
- ISparkLineObject
- ISparkPoints
- ISparkVerticalAxis
- IStyle
- IStyleCollection
- ITable
- ITableColumn
- ITableColumns
- ITableDataSource
- ITableRow
- ITableRows
- ITables
- ITableStyle
- ITableStyleCollection
- ITableStyleElement
- ITableStyleElements
- ITextRun
- ITheme
- IThemeColor
- IThemeColorScheme
- IThemeFont
- IThemeFonts
- IThemeFontScheme
- ITop10
- IUniqueValues
- IValidation
- IValueSortField
- IVPageBreak
- IVPageBreaks
- IWebRequestHandler
- IWorkbook
- IWorkbookView
- IWorksheet
- IWorksheets
- IWorksheetView
-
- GrapeCity.Documents.Excel.Drawing
- GrapeCity.Documents.Excel.Expressions
- GrapeCity.Documents.Excel.Forms
-
GrapeCity.Documents.Excel
GrapeCity.Documents.Excel.IWorkbook.Open
Open Method
Open(string)
Opens the file.
Declaration
void Open(string fileName)
Sub Open(fileName As String)
Parameters
| Type | Name | Description |
|---|---|---|
| string | fileName | The specified file. |
Open(string, DeserializationOptions)
Opens the JSON file.
Declaration
IList<JsonError> Open(string fileName, DeserializationOptions deserializationOptions)
Function Open(fileName As String, deserializationOptions As DeserializationOptions) As IList(Of JsonError)
Parameters
| Type | Name | Description |
|---|---|---|
| string | fileName | The specified JSON file. |
| DeserializationOptions | deserializationOptions | The JSON deserialization options. |
Returns
| Type | Description |
|---|---|
| IList<JsonError> | The error list of the JSON. |
Open(string, string, OpenOptions)
Opens the specified excel file.
Declaration
void Open(string fileName, string password = null, OpenOptions openOptions = null)
Sub Open(fileName As String, Optional password As String = Nothing, Optional openOptions As OpenOptions = Nothing)
Parameters
| Type | Name | Description |
|---|---|---|
| string | fileName | The excel file. |
| string | password | The password of the file. |
| OpenOptions | openOptions | Options for opening. |
Remarks
This method is now obsolete.
Open(Stream)
Opens the file stream.
Declaration
void Open(Stream fileStream)
Sub Open(fileStream As Stream)
Parameters
| Type | Name | Description |
|---|---|---|
| Stream | fileStream | The specified file stream. |
Open(Stream, string, OpenOptions)
Opens the specified excel file stream.
Declaration
void Open(Stream fileStream, string password = null, OpenOptions openOptions = null)
Sub Open(fileStream As Stream, Optional password As String = Nothing, Optional openOptions As OpenOptions = Nothing)
Parameters
| Type | Name | Description |
|---|---|---|
| Stream | fileStream | The file stream. |
| string | password | The password of the file. |
| OpenOptions | openOptions | Options for opening. |
Remarks
This method is now obsolete.
Open(string, OpenFileFormat)
Opens the specified format file.
Declaration
void Open(string fileName, OpenFileFormat fileFormat)
Sub Open(fileName As String, fileFormat As OpenFileFormat)
Parameters
| Type | Name | Description |
|---|---|---|
| string | fileName | The specified file. |
| OpenFileFormat | fileFormat | The format of the file. |
Open(Stream, OpenFileFormat)
Opens the specified format file stream.
Declaration
void Open(Stream fileStream, OpenFileFormat fileFormat)
Sub Open(fileStream As Stream, fileFormat As OpenFileFormat)
Parameters
| Type | Name | Description |
|---|---|---|
| Stream | fileStream | The specified file stream. |
| OpenFileFormat | fileFormat | The format of the file stream. |
Open(string, OpenOptionsBase)
Opens the file with specified options.
Declaration
void Open(string fileName, OpenOptionsBase options)
Sub Open(fileName As String, options As OpenOptionsBase)
Parameters
| Type | Name | Description |
|---|---|---|
| string | fileName | The excel file. |
| OpenOptionsBase | options | The options of opening the file. Possible types: |
Open(Stream, OpenOptionsBase)
Opens the stream with specified options.
Declaration
void Open(Stream fileStream, OpenOptionsBase options)
Sub Open(fileStream As Stream, options As OpenOptionsBase)
Parameters
| Type | Name | Description |
|---|---|---|
| Stream | fileStream | The file stream. |
| OpenOptionsBase | options | The format of opening the file stream. Possible types: |