필터 지우기
필터 지우기

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