Data conversion, and plotting cell data in excel folder on Matlab.

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.

Answers (1)

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

Dear Jan, The following data is in excel file, 1.200843e-003,-2.919414e-004 1.233418e-003,-2.263049e-004 1.196629e-003,-1.972953e-004 1.090801e-003,-2.135018e-004 9.235489e-004,-2.590421e-004 7.123777e-004,-3.029619e-004 4.802999e-004,-3.134961e-004 2.519498e-004,-2.681178e-004 5.358185e-005,-1.601823e-004 -9.276313e-005,4.313994e-006 -1.754164e-004,2.188885e-004 -1.929195e-004,4.947237e-004 -1.489998e-004,8.496471e-004 -5.662256e-005,1.259349e-003 4.888196e-005,1.634369e-003 1.195424e-004,1.860126e-003 1.179218e-004,1.850078e-003 4.709924e-005,1.598876e-003 -4.949169e-005,1.182854e-003 -1.139937e-004,7.238843e-004 as you see, there are 20 rows and two colomns, two data are separated with comma (,) within the row, each row contains two data, totally there are 40 data. I want to use these data and plot the "data signal" on Matlab. Thanks for your regard.
@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.
Dear Jan, thanks for your help, my data is electromyogram (EMG) data and data is acquired using EMGWorks Acquisition software.

Sign in to comment.

Asked:

on 24 Jan 2017

Commented:

on 27 Jan 2017

Community Treasure Hunt

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

Start Hunting!