i have .xl sheet and i want to convert it to .mat file to give as input vector for trainning in neural networks. how we can do this task and where i need to do this task

i want to train a data using NN tool. the data contain in xl sheet. so i can't put the data to the work space. if i able to convert the .xl sheet to .mat file i think i can give to the tool .
can anybody help regarding this by quoting one example.

Answers (1)

data=xlsread('ExcelFile'); % load an Excel file
save('NewFile','data') % save a .mat file
Pass the array data to the tool.
See
doc xlsread
doc save % and friends
for details.
A useful feature is
help
then look at the categories. In this case it would be iofun for input/output that you're looking for. So then type
help iofun
and use the list/brief descriptions to narrow down what it is you're trying to do.

Asked:

on 26 Feb 2015

Commented:

on 1 Mar 2015

Community Treasure Hunt

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

Start Hunting!