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')

Answer 1

[Image Analyst]

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.

[Image Analyst]

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]

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]

Thanks.. this should work. I just have to modify it to needs.