importing data from excel
显示 更早的评论
Hello, i'm trying to use xls read
[num,txt,raw]=xlsread('id_vds.xlsx')
to get excel data but i'm getting this error
Error using xlsread (line 129)
XLSREAD unable to open file 'id_vds.xlsx'.
File 'C:\Users\rmkotech\Desktop\excel2matlab\id_vds.xlsx' not found.
Error in excel2mat (line 5)
[num,txt,raw]=xlsread('id_vds.xlsx')
采纳的回答
Image Analyst
2014-11-7
Your Excel workbook is not in that folder. Specify the full filename.
folder = 'C:\Users\rmkotech\Desktop\excel2matlab'; % Whatever the real folders (not this one)
fullFileName = fullfile(folder, 'id_vds.xlsx');
[num,txt,raw]=xlsread(fullFileName);
You need to correct the folder because it's not in that one.
3 个评论
Image Analyst
2014-11-7
Ram's "Answers" moved here.
The excel workbook is in that folder and that's why i'm surprised about this error. I tried giving the entire path but it still gave me the same error.
Thanks!
Hi Analyst,
I changed the computer and now it's running fine for some reason.
Now, I had another question if you could help.
I have different columns of data in it and i want to have multiple curves on the same plot. How do i do that.
thanks, Ram
Image Analyst
2014-11-7
col1 = num(:, 1);
col2 = num(:, 2);
col3 = num(:, 3);
plot(col1, 'rd-', 'LineWidth', 3);
hold on;
plot(col2, 'ks-', 'LineWidth', 3);
plot(col3, 'bo-', 'LineWidth', 3);
ram
2014-11-7
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
