Data conversion, and plotting cell data in excel folder on Matlab.
1 view (last 30 days)
Show older comments
My data is in excel folder, and although they are number within the two colomns, when I import these data to MATLAB, its class seems to be "cell", How can I convert these datas to "double" class, and using them draw the data signal on Matlab window.
0 Comments
Answers (1)
Jan
on 24 Jan 2017
Edited: Jan
on 25 Jan 2017
I assume "Excel folder" mean an Excel file. Most likely you have imported this file already, then please post the used code. It matters, which output argument of xlsread you are using. The first output should contain numerical data already, see doc xlsread.
[EDITED] With some guessing:
num = xlsread('FileName.xlsx');
plot(num(:, 1), num(:, 2))
3 Comments
Jan
on 25 Jan 2017
@nyuklu: It is still not clear how your data are stored. Excel files are binary files, so if you see the data as posted, you use any software to import it at first. Please explain, which software is used to display the data as you have posted them as text or as screen shot.
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!