Info

此问题已关闭。 请重新打开它进行编辑或回答。

excel& matlab

1 次查看(过去 30 天)
alexis
alexis 2011-7-25
关闭: MATLAB Answer Bot 2021-8-20
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???

回答(1 个)

Fangjun Jiang
Fangjun Jiang 2011-7-25
Looks like you can use the built-in function xlsread(). It can read a single sheet or a single cell.
help xlsread

此问题已关闭。

Community Treasure Hunt

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

Start Hunting!

Translated by