How to read CSV files one at every time using uigetfile and apply a set of formulae

2 次查看(过去 30 天)
Hi, I have several CSV files that contain 10,000 rows by 16 columns in a .CSV generated file as seen in the attachment. I want to execute some formulae on these data so that I can open it up and be able to run the formulae for each CSV file. How can I make this file to work?
Originally I had to convert CSV files to xlsx and then read it as follows.
[num21 txt21 numtxt21] = xlsread('R21_08S','B2:Q10001');
However this is too tedious and I would rather read it as:
[fNameDatai,pathNameData]=uigetfile('*.csv', 'Select the DATA file','Multiselect','on');
if ~iscell(fNameDatai),fNameData{1}=fNameDatai;else fNameData=fNameDatai;end
so that I don't have to convert CSV file to xslx and be able to just select the rows and columns I need.
Thanks

回答(1 个)

Image Analyst
Image Analyst 2018-9-17
To process a sequence of files, use one of the two code samples in the FAQ:
Just alter it so that the filenames are what you get from uigetfile() instead of dir().
You can use csvread() instead of using xlsread().
  1 个评论
juan sanchez
juan sanchez 2018-9-17
编辑:juan sanchez 2018-9-17
Thank you very much. Would you kindly show me how to do it? I am trying but I do not know how to be able to open R6.csv and apply the set of equations. After if I decide to open R7 and I would like that too but at different times. I only want to select 'R21_08S','B2:Q10001' for each CSV at a time and autogenerate the formula.

请先登录,再进行评论。

类别

Help CenterFile Exchange 中查找有关 File Operations 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by