importing data from excel

3 次查看（过去 30 天）
ram
ram 2014-11-7
评论： ram 2014-11-7
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
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 个评论
显示 1更早的评论
Image Analyst
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
ram 2014-11-7
Thanks.. this should work. I just have to modify it to needs.

请先登录，再进行评论。

更多回答（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