Is there code to recognize and allow me to browse and select CSV data?
13 views (last 30 days)
Show older comments
I currently have a code that reads CSV data and allows me to search through it to find specific info. But, I have many different CSV files that I may want to examine and I dont want to have to put in the URL for each data file each time. Is there a function that I can use inside CSVread that opens up a browse window to allow me to select the data file I want to look at?
0 Comments
Answers (2)
dpb
on 21 Jun 2016
Edited: dpb
on 23 Jun 2016
Actually, building on Shameer's suggestion,
[file,path] = uigetfile('*.csv','Select a CSV file');
if ischar(file)
filename=fullfile(path,file);
S=uiimport(filename);
end
let's you "have your cake and eat it, too!" :) Use uigetfile for the file dialog and then pass the selected file to uiimport.
You could wrap this in an outer loop, to allow repetitive calls, but you'll have to be careful because the uiimport is asynchronous and the dialog box may reappear again before you're ready...I'm sure there must be some way around it but didn't have time to 'spearmint...
Good luck...
Or, of course, you can just live with the default file selection list and type *.csv in the selection box to get the list...
0 Comments
Shameer Parmar
on 22 Jun 2016
[filename, pathname] = uigetfile({'*.xls';'*.xlsx';'*.csv'});
4 Comments
Shameer Parmar
on 23 Jun 2016
@Madison:
your syntax is incorrect..
it should be as uigetfile('*.csv');
dpb
on 23 Jun 2016
Actually, there's not a syntax error that will cause an error; the prompt string looks a little funky with the trailing ';' that isn't needed as well as the cellstr curlies, but it works just fine. The other argument is a line-start count other than zero for csvread which is also legal.
Consequently, if the file that were selected is in the working directory and a valid .csv file with no more than one header line, the code as written would, in fact work (I just tested it, copied and pasted on such a file here).
But, as noted, he'll then have the content of the file in a inappropriately named variable (only a style issue of course) but the key point is it again won't open any preview window...
See Also
Categories
Find more on Data Import and Analysis in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!