Sum up data from various excel files in different folders
4 次查看(过去 30 天)
显示 更早的评论
Hi, I am quite new to Matlab and have a question for you experts :) I want to sum up specific rows in a certain column in different excel-files located in various folders. The search path is attached (see matlab.jpg) where Matlab_Esignatur is the home location, "eltest" contains different addresses (such as Berzeliigatan 14) that are folders, and within each adress there are a number of excel-files. The no. of excel-files differs from each adress/folders. The excel-files are also attached. I only want to sum up the value of certain rows in column G with the column value of 1, and not 2, in column A (see matlab2.jpg).
What I have managed so far is to read the different street names or folders, see matlab3.jpg, where the code is also seen. What is my next step?
Thank you!
2 个评论
Jan
2018-1-4
The screenshots are very inconvenient to read. Please post the information as text instead. The image containing the "search path" is not useful, because '"eltest" contains different addresses (such as Berzeliigatan 14)' is not clear.
回答(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!