how to read excel data

Hello everyone,

I want to create a function which will read data from a given excel file and will return different vectors, each corresponding to a different vector (numerical data only). Do you have any idea?

thank you

Answer 1

[Azzi Abdelmalek]

To get numerical data

v=xlsread('your_file.xlsx')

[jimaras]

this works when I compile in command window, but I want to create a function (which reads this data and will separate the columns into different vectors), so I am doing this:

filename='excelfile.xlsx'; Function(filename)

and I get the following message

Undefined function 'ReadApple' for input arguments of type 'char'.

What am I doing wrong?

[Azzi Abdelmalek]

Post your function

[jimaras]

%Function Trasformation which reads part of data from excel file
%and returns this data in form of vectors;

function[K]= Trasformation(filename)
K=xlsread(filename);
n=length(K);
K

[jimaras]

and in the command window I set

filename='excelfile.xlsx';

[Azzi Abdelmalek]

This doesn't make any sens, you are just replacing the function xlsread by Transformation. Just write

K=xlsread('yourfile.xls')

Then do whatever you want with the matrix K. And it's a bad idea to separate it to many vectors. If you want a third column, you can get it by

K(:,3)