cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Highlighted
Regular Member

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 file 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

 

Thanks

2 REPLIES 2
Highlighted

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

The syntax you show does not appear to be Mathcad (nor Prime). Are you using the API?

Why don't you just read the file using the READCSV() function into a matrix. Using Mathcad/Prime matrix operations you can select any rows and/or columns to work with.

 

Success!
Luc

Highlighted

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

xlsread??

 

Could it be you are confusing "Matlab" with "Mathcad"?

Announcements