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

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

Answer 1

[Image Analyst]

To process a sequence of files, use one of the two code samples in the FAQ:

https://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F

Just alter it so that the filenames are what you get from uigetfile() instead of dir().

You can use csvread() instead of using xlsread().

[juan sanchez]

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.