how to read 4th and 10th column of 12 excel files from folder and then plot 4th and 10th column of each excel file

Question

muhammad choudhry 2021-4-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/806592-how-to-read-4th-and-10th-column-of-12-excel-files-from-folder-and-then-plot-4th-and-10th-column-of-e

回答： Shivang Srivastava 2021-4-23

Hi,

How can I read the specific columns and from the bunch of excel files and then use the column data to plot the sub-plot of graphs?

Sofar,

close all; clear all; clc;

folder = fullfile('C:','Users','muhammad','Documents','PhD_3rdYr','Experiments_2021','performance_110');

files = dir( fullfile(folder, '*.ods') );

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Shivang Srivastava 2021-4-23

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/806592-how-to-read-4th-and-10th-column-of-12-excel-files-from-folder-and-then-plot-4th-and-10th-column-of-e#answer_682755

在 MATLAB Online 中打开

As per my understanding you want to read all files in a directory and read the excel files and plot the values in particular columns.

currentpath = pwd; 
dataPath = string(currentpath)+ '\data'; 
 
allFiles = dir(dataPath); 
sz = size(allFiles,1); 
 
figure 
for i = [3:sz]  
% The index start from 3 because for i = 1 & 2,  
% allFiles.names is '.' & '..' respectively. 
    path = dataPath + '\' + allFiles(i).name; 
    data = readtable(path); 
    hold on 
    plot(data.Var4) 
    hold on 
    plot(data.Var10) 
end