Manipulate Excel from Matlab

5 views (last 30 days)
Virginia
Virginia on 23 Jun 2013
Hi, I want to know how can develope a code so it open phisically an Excel file, and then save the selected cell range that I'll selected with the mouse as a matrix in Matlab

Accepted Answer

Tom
Tom on 23 Jun 2013
The -1 field allows you to use Excel interactively.
[num txt raw] = xlsread(fileName,-1);
  3 Comments
Tom
Tom on 23 Jun 2013
I think you're looking at the raw data, rather than the numeric data (see the three outputs you get from XLSREAD)?
Otherwise, try:
cell2mat(data)
Virginia
Virginia on 23 Jun 2013
I just did it, I just had to set the name of the variable for example
[K] = xlsread(comp,-1)
And that will save the range cell in matlab.
Thanks Tom!

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!