Writing data from cell array to vectors?

13 ビュー (過去 30 日間)
MeitiLuk
MeitiLuk 2020 年 11 月 4 日
編集済み: Stephen23 2020 年 11 月 4 日
So I'm trying to reduce my Code.
I have an Excel file, which has 15 sheets. These Sheets are saved into one cell array?
Then I'm writing all of the Sheets in an Matrix. From Matrix I'm then take two columns and write them into separate vectors.
%%%%%%%%%%%%%
%%% Matlab Code %%%
%%%%%%%%%%%%%
[~,sheet_name]=xlsfinfo('Kippen_Sweep_1-15Hz_VL-0N_0k4G-A_G05-VAQLu-li-2788347-03-S-.xlsx');
for i=1:numel(sheet_name)
Daten{i}=xlsread('Data.xlsx',sheet_name{i});
end
%%% Array to Matrix
Daten_1Hz = Daten{1,1};
Daten_2Hz = Daten{1,2};
Daten_3Hz = Daten{1,3};
Daten_4Hz = Daten{1,4};
Daten_5Hz = Daten{1,5};
Daten_6Hz = Daten{1,6};
Daten_7Hz = Daten{1,7};
Daten_8Hz = Daten{1,8};
Daten_9Hz = Daten{1,9};
Daten_10Hz = Daten{1,10};
Daten_11Hz = Daten{1,11};
Daten_12Hz = Daten{1,12};
Daten_13Hz = Daten{1,13};
Daten_14Hz = Daten{1,14};
Daten_15Hz = Daten{1,15};
%%% Matrix to Vector
Drehmoment_1Hz = Daten_1Hz(:,3);
Drehmoment_2Hz = Daten_2Hz(:,3);
Drehmoment_3Hz = Daten_3Hz(:,3);
Drehmoment_4Hz = Daten_4Hz(:,3);
Drehmoment_5Hz = Daten_5Hz(:,3);
Drehmoment_6Hz = Daten_6Hz(:,3);
Drehmoment_7Hz = Daten_7Hz(:,3);
Drehmoment_8Hz = Daten_8Hz(:,3);
Drehmoment_9Hz = Daten_9Hz(:,3);
Drehmoment_10Hz = Daten_10Hz(:,3);
Drehmoment_11Hz = Daten_11Hz(:,3);
Drehmoment_12Hz = Daten_12Hz(:,3);
Drehmoment_13Hz = Daten_13Hz(:,3);
Drehmoment_14Hz = Daten_14Hz(:,3);
Drehmoment_15Hz = Daten_15Hz(:,3);
Idealy I would have a for loop, which then would go from 1-15Hz.
But I can't get my Code to work, in the Way I would need it.
Can anybody help me with this?
Sorry for my bad explanation, I'm quit new to Matlab and my english is kinda bad since I'm from Germany.
  1 件のコメント
Stephen23
Stephen23 2020 年 11 月 4 日
編集済み: Stephen23 2020 年 11 月 4 日
Putting meta-data (such as frequencies) into variable names is a sign that you are doing something wrong.
Splitting up data into lots of separate variables makes it harder to work with. Avoid doing this.
The MATLAB documentation specifically advises against what you are trying to do. You are going down entirely the wrong path, unless you really want to force yourself into writing slow, complex, buggy code that is difficult to debug:
The simple and very efficient approach is to use indexing. You should use indexing to access your data.

サインインしてコメントする。

回答 (0 件)

カテゴリ

Help Center および File ExchangeMatrix Indexing についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by