# xlsopen

Opens an Excel compatible file, file, and stores the information in R using functions defined in omlxlstoolbox. xlsopen is available only on Windows systems where Microsoft Excel is installed.

## Syntax

R = xlsopen(file)

R = xlsopen(file, mode)

## Inputs

file
Name of the file to open. The file extension must be Excel-compatible.
Type: string
mode (optional)
Determines if the file is opened in read-only mode.
0
The file is opened in read-only mode.
1
The file is opened for writing. A new file is created if file does not exist.
By default, file is opened in read-only mode.
Type: integer

## Outputs

R
Output structure which contains information about the opened Excel file, file. Any file opened with xlsopen needs to call xlsclose with R so that all Excel processes are shut down and memory is released. R can be used with the commands xlsread and xlswrite.
Type: struct

## Example

Open an Excel file in write mode:
R = xlsopen('c:\test1.xlsx', 1)
R = struct [
app: xlsx
applicationid: 17363
changed: 1
filename: C:\test1.xlsx
sheetcount: 6
sheets: struct [
rid: [Matrix] 1 x 6
1  2  3  4  5  6
sh_names:
{
[1,1] Properties
[1,2] Evaluation Data
[1,3] Statistics
]