User Input with Loops
显示 更早的评论
Hey guys,
I am wondering is there is a function that can read .xlsx, .csv, and .xls files. I wanted something that could work with the uigetfile('*.*') command For example, I want my user to select a spreadsheet either in .xlsx, .csv, or .xls format and send it through an analysis regardless of what they pick. Currently I have csvread, and was wondering if I could form an loop asking them what format the file is in and send it through it's respective analysis, whether it be xlsxread, xlsread, etc.
I apologize if the questions isn't clear.
Thanks!
采纳的回答
Star Strider
2014-12-6
As far as I know, xlsread can potentially read all of them, provided they’re in Excel format. (The xlsread funciton calls Excel.) If you want to specifically select xlsread or csvread on the basis of the file extension, something like this would work:
filext = {'xls' 'xlsx' 'csv'};
fnm = inputdlg('Enter the full name (+ext) of your file: ');
ext = regexpi(fnm, '[.]?','split');
filtyp = find(strcmpi(ext{:}(2),filext));
followed by a switch-case block to call the appropriate function based on the output in ‘filtyp’, and passing to it the full ‘fnm’ file name.
7 个评论
mike
2014-12-6
Star Strider
2014-12-7
My pleasure!
I forgot that inputdlg returns a cell. It didn’t come up in my original code because I kept it all as cells.
A minor change:
filext = {'xls' 'xlsx' 'csv'};
fnmc = inputdlg('Enter the full name (+ext) of your file: ');
fnms = char(fnmc);
ext = regexpi(fnmc, '[.]?','split');
filtyp = find(strcmpi(ext{:}(2),filext));
The input variable changed to ‘fnmc’ (‘file name cell’) and added ‘fnms’ (‘file name string’), now a character array. Use ‘fnms’ for your file name, and csvread should be happy.
mike
2014-12-7
Star Strider
2014-12-7
My pleasure!
The sincerest expression of appreciation here on MATLAB Answers is to Accept the answer that most closely solves your problem.
mike
2014-12-7
Star Strider
2014-12-7
You would have to save them as .csv files, either after having first read them in through MATLAB using xlsread, or directly saving them as .csv files in Excel.
See the documentation for csvwrite for details on writing .csv files in MATLAB.
Thanks!
Image Analyst
2014-12-7
I answered that in your other question: http://www.mathworks.com/matlabcentral/answers/165743#answer_161561
更多回答（1 个）
Image Analyst
2014-12-7
0 个投票
Depending on the way the data is laid out, you could use readtable(). importdata() should also be able to do it since it detects what's there and uses the appropriate lower level importing function (like csvread or xlsread).
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
