I want to read differently from xlsread as a uigetfile .csv

Hi. I wanto read differently from using xlsread to using uigetfile .csv.

For example if I use [num6 txt6 numtxt6]=xlsread('R6','B2:Q10001'); I will get the following in my workspace (right side):

num6 10,000x16 double numtxt6 10,000 x 16 cell txt6 0x0 cell

However if I use for instance [num6 txt6 numtxt6]=uigetfile('*.csv')

I do not get this info in the workspace. I want to get the same in uigetfile as i got in xlsread and get the same info on the workspace so that that I can apply a set of formula every time I want to open a file since I have several files in sequence R1, R2, R3 etc. Thank you.

Answer 1

[Guillaume]

You request makes no sense. uigetfile does not read files. It prompts you to select a file and simply returns the name of the selected file. You can use csvread, dlmread even xlsread or some other low level function to read that file.

Even better, nowadays you have readtable that can read both excel files and csv files and is easier to use than xlsread.

You should read the documentation of the functions you use if you're not sure what they do.

[juan sanchez]

Thank you for your explanation. I am new to MATLAB and I want to understand. I like the way uigetfile opens up and lets me select the specified file so that I can use my equations. How can I use readtable so that I can open the file as I did in uigetfile and get [num6 txt6 numtxt6] in the specified format above so that I can use this code for any .CSV or .xlsx file. I will greatly appreciate it.

[Guillaume]

[selectedfile, selectedfolder = uigetfile({'*.xls;*.xlsx', 'Excel files'; '*.csv', 'CSV files'});
if ~isequal(selectedfile, 0)   %dialog has not been canceled
   filedata = readtable(fullfile(selectedfolder, selectedfile))
end

[juan sanchez]

Thank you very much. However if I only want to select column B to Q for all the rows? Please advise. Thank you very much!!!

Please note that I wanted to have the format [num6 txt6 numtxt6]

Can I do [num6 txt6 numtxt6]= readtable('*.csv','R21_08S','B2:Q10001')

??

[Guillaume]

There's no column B to Q for a csv file, so you can't have generic code anymore if you want to treat csv and excel file separately. As documented, for excel file use the 'Range' option.

There is no need to separate numeric and textual data with readtable and it is not possible to do so. It is much easier to work with tables than seperate matrices of numeric and textual data.

"Can I do [num6 txt6 numtxt6]= readtable('*.csv','R21_08S','B2:Q10001')"

You've got to stop inventing your own syntax for built in functions.

[juan sanchez]

Thank you very much. I greatly appreciate your advise. I promise I will study the functions in detail. I am very impressed with your high level of knowledge. How can I become good as you in MATLAB? I have no one to help me or where to go. What is the best way to learn or tips you can give me as where to go so I can master this MATLAB that seems so impossible to me. Thank you greatly!!!

[juan sanchez]

Hi Guillaume, is there any way I can read multiple excel files so the analysis is done the same way but with more than one excel time at a time?