Regarding importing excel in matlab

1 次查看（过去 30 天）
Yogesh Rao
Yogesh Rao 2015-1-2
评论： Yogesh Rao 2015-1-2
heii friends.....i need help..... I have excel sheet .... The first 5 lines have unwanted text containing header date name etc.... actual data starts from 6th line.... I need to get an array which should have data of first column and another array that will have data of all other columns....... I tried with the code as shown below but i get error stating not enough input arguments ....can any1 suggest modifications/correct way so as to solve the problem...... clc; clear all; close all; b=[]; a=[]; [num,txt,raw] = xlsread('C:\Users\SONY\Desktop\goodresults\22122014.xlsx'); [r,c]=size(raw); a=raw(6:r,1); b=raw(6:r,2:c); figure(1),plot(a,b);

请先登录，再回答此问题。

采纳的回答

Shoaibur Rahman
Shoaibur Rahman 2015-1-2
xlsread import excel data with cell type. Convert them to double before plotting. In this case u can use cell2mat function:
a=raw(6:r,1);
b=raw(6:r,2:c);
A = cell2mat(a);
B = cell2mat(b);
figure(1), plot(A,B);
  1 个评论
Yogesh Rao
Yogesh Rao 2015-1-2
Hey I tried with the above code you mentioned. It worked ! Thanks a lot for timely help ! Thanks a lot again !

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by