Reading data from multiple excel files
조회 수: 1 (최근 30일)
이전 댓글 표시
Hello, I have a folder containing 15 excel files. Each file represents data of 3 audio signals. I want to read all these files and draw all signals on the same plot.
댓글 수: 0
답변 (1개)
TS
2021년 3월 24일
편집: TS
2021년 3월 24일
I'm actually doin something like this.
First define the directory:
pathData = 'C:\...\';
If you just want to use CSV data use
fileEnding = '*.csv';
and merg them together (u could do this in one line if u want to save space)
audioData = [pathData,fileEnding]
then load the data names into a file, and if u want, creat a list just of the file names
liste_audioData = dir(audioData);
files_audioData = {liste_audioData.name}';
then read each file in a for loop for as much files you have and cut them as needed
for i = 1:size(files_audioData)
name_audioData = files_audioData{i};
data = readtable(name_audioData);
data(1:14,:) = [];
data(end,:) = [];
end
to excess the data use
Value(:,i) = data.'columnname'
and then simple
plot(time,Value(:,1),time,Value(:,2)...)
You should to preallocate the size of array Value, this depends on the row and column size of your data.
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!