I need to make a function that reads an excel file?
    2 views (last 30 days)
  
       Show older comments
    
    studentdavid
 on 7 Jun 2016
  
    
    
    
    
    Commented: studentdavid
 on 7 Jun 2016
            How do I read an Excel file into a function without hard coding it? I want to be able to put the file into the functionhandle with a predefined variable as the xlsx file, but i can't seem to make it work.
1 Comment
  Guillaume
      
      
 on 7 Jun 2016
				Can explain more clearly what you're trying to do. An example of inputs and expected outputs would be useful.
" I want to be able to put the file into the functionhandle with a predefined variable as the xlsx file". Does not make any sense to me. What function handle?
Accepted Answer
  Image Analyst
      
      
 on 7 Jun 2016
        How about this
function [numbers, strings, raw] = MyXlsread(filename)
    numbers = [];
    strings = [];
    raw = [];
    if exist(filename, 'file')
        [numbers, strings, raw] = xlsread(filename);
    else
        message = sprintf('File not found:\n%s', filename);
        uiwait(warndlg(message));
    end
More Answers (0)
See Also
Categories
				Find more on Spreadsheets in Help Center and File Exchange
			
	Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
