CODEWITHSUNDEEP
excelmatlabexport
Degvik
Degvik

Reputation: 3190

What is the simplest way to export Excel data to Matlab?

What is the simplest way to programmatically export Excel data to Matlab?

Upvotes: 7

Views: 5907

Answers (5)

user6041892
user6041892

Reputation:

In more recent Matlab releases there are also csvread() and writetable() that work with csv which can easily be opened in Excel.

Upvotes: 3

bastibe
bastibe

Reputation: 17217

As has been said, XLSREAD is the right function for the job. On a non-Windows system it will also work without Excel installed. However, it supposedly lacks some of Excels advanced features.

Upvotes: 1

Jouni K. Seppänen
Jouni K. Seppänen

Reputation: 44152

If you are running Matlab on Windows with Excel installed, try XLSREAD.

Upvotes: 7

Scottie T
Scottie T

Reputation: 12245

For a bit of $$$, you can get the MATLAB add-on Excel Link, which provides a nice clean interface for transferring data back and forth between the two programs.

Upvotes: 1

Scottie T
Scottie T

Reputation: 12245

If there's not much text annotation in the Excel file, save it as a csv, then use the MATLAB function csvread.

Upvotes: 4

Related Questions