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

2 views (last 30 days)
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)

dpb
dpb on 26 Feb 2015
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.

Categories

Find more on Sequence and Numeric Feature Data Workflows in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!