Reading data from multiple excel files
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponses (1)
TS
le 24 Mar 2021
Modifié(e) : TS
le 24 Mar 2021
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 commentaires
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!