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
  [1,4] Trade-Off
  [1,5] Trade-Off Settings
  [1,6] Sheet1
}
sheetid: [Matrix] 1 x 6
17369  17372  17376  17379  17382  17385
]
workbookid: 17366
xtype: OML
]