Is there code to recognize and allow me to browse and select CSV data?

12 次查看(过去 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?

回答(2 个)

dpb
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...

Shameer Parmar
Shameer Parmar 2016-6-22
[filename, pathname] = uigetfile({'*.xls';'*.xlsx';'*.csv'});
  4 个评论
dpb
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 CenterFile Exchange 中查找有关 Low-Level File I/O 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by