# GrapeCity.Documents.Excel.Workbook.Open ## Content

Open Method

Open(string, string, OpenOptions)

Opens the specified excel file

Declaration
[Obsolete("Use Open(string, OpenOptionsBase) instead.")]
public void Open(string fileName, string password = null, OpenOptions openOptions = null)
<Obsolete("Use Open(string, OpenOptionsBase) instead.")>
Public 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.
Implements
IWorkbook.Open(string, string, OpenOptions)

Open(string)

Opens the file with default options. The file type is inferred from file extension.

Declaration
public void Open(string fileName)
Public Sub Open(fileName As String)
Parameters
Type Name Description
string fileName

The specified file.
Implements
IWorkbook.Open(string)

Open(string, DeserializationOptions)

Opens the json file.

Declaration
public IList<JsonError> Open(string fileName, DeserializationOptions deserializationOptions)
Public 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
Implements
IWorkbook.Open(string, DeserializationOptions)

Open(Stream, string, OpenOptions)

Opens the specified excel file stream.

Declaration
[Obsolete("Use Open(Stream, OpenOptionsBase) instead.")]
public void Open(Stream fileStream, string password = null, OpenOptions openOptions = null)
<Obsolete("Use Open(Stream, OpenOptionsBase) instead.")>
Public 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.
Implements
IWorkbook.Open(Stream, string, OpenOptions)

Open(string, OpenFileFormat)

Opens the file with specified file format.

Declaration
public void Open(string fileName, OpenFileFormat fileFormat)
Public Sub Open(fileName As String, fileFormat As OpenFileFormat)
Parameters
Type Name Description
string fileName

The specified file.
OpenFileFormat fileFormat

The format of the file.
Implements
IWorkbook.Open(string, OpenFileFormat)

Open(Stream, OpenFileFormat)

Opens the stream with specified file format.

Declaration
public void Open(Stream fileStream, OpenFileFormat fileFormat)
Public 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.
Implements
IWorkbook.Open(Stream, OpenFileFormat)

Open(Stream)

Opens the file stream.

Declaration
public void Open(Stream fileStream)
Public Sub Open(fileStream As Stream)
Parameters
Type Name Description
Stream fileStream

The specified file stream.
Implements
IWorkbook.Open(Stream)

Open(string, OpenOptionsBase)

Opens the file with specified options.

Declaration
public void Open(string fileName, OpenOptionsBase options)
Public 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:

Implements
IWorkbook.Open(string, OpenOptionsBase)

Open(Stream, OpenOptionsBase)

Opens the stream with specified options.

Declaration
public void Open(Stream fileStream, OpenOptionsBase options)
Public 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:

Implements
IWorkbook.Open(Stream, OpenOptionsBase)