Is there code to recognize and allow me to browse and select CSV data?
13 次查看(过去 30 天)
显示 更早的评论
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 个评论
回答(2 个)
dpb
2016-6-21
编辑:dpb
2016-6-23
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 个评论
Shameer Parmar
2016-6-22
[filename, pathname] = uigetfile({'*.xls';'*.xlsx';'*.csv'});
4 个评论
dpb
2016-6-23
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...
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!