I want to import data of excel used automation

1 回表示 (過去 30 日間)
JIN-HWA JEONG
JIN-HWA JEONG 2016 年 5 月 1 日
回答済み: JIN-HWA JEONG 2016 年 5 月 1 日
This is a hand_operated(manual) code. --------------------------------------------- data_a01 = xlsread('2016-01-01.xlsx'); a01 = zeros(ceil(length(data_a01)/15)*15,7); a01(1:length(data_a01),1:7) = data_a01; result1_a01 = mean(reshape(a01,15,[]))'; resultF_a01 = reshape(result1_a01,[],7) ; --------------------------------------------- But I have many excel files. so, I want to hadle many files more easily. For example, using a for_fuction, import 5 files On the top code, How use the for or etc.. code ??? Help me.

サインインしてこの質問に回答する。

回答 (1 件)

JIN-HWA JEONG
JIN-HWA JEONG 2016 年 5 月 1 日
ANd I want to express on workspace.like this workspace----------------------------------- data_a01 = double data_a02 = double data_a03 = double
different name of data_a0? (use automation like for fuction) & Also structures are differnet files.

カテゴリ

Help Center および File Exchange で Spreadsheets についてさらに検索

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by