Info
This question is closed. Reopen it to edit or answer.
excel& matlab
2 views (last 30 days)
Show older comments
Hi everyone! I've got one more question to you. I create a function for importing .xlsx files.
I call it "importfile.m".
The output are a data.mat and a textdata.
So....
sheet = uigetfile('*.xlsx','Select Weekly Performance Report for Analysis');
importfile (sheet)
Now i want something else. I have a folder with some .xlsx files which concern different machine(10).
All of them have exact the same format. The Cell "C3" has the name of machine.
So i want somehow to read the cell C3 and accordingly with the content , all the .xlsx files to be distributed in their respective folders(already exist).
Can you help me???
0 Comments
Answers (1)
Fangjun Jiang
on 25 Jul 2011
Looks like you can use the built-in function xlsread(). It can read a single sheet or a single cell.
help xlsread
0 Comments
This question is closed.
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!