MATLAB: Importing an excel table with words

import excel

I got an excel table with text and numbers. The code below does not allow me to display the text properly in the matlab table. how can i import the file as cell array so words can be read as well?

fileToRead = fullfile('C:\Users\Untitled Spreadsheet.xlsx');
 circa1 = xlsread(fileToRead);

Best Answer

'xlsread' returns 3 outputs -

[numOnly, textOnly, rawDataInCellArray] = xlsread(xlFile);

If you need the data in only cell array format, use the below style :

[~, ~, mydata] = xlsread(xlfile);

Please try 'help xlsread' to get more info.

Related Solutions

MATLAB: Filtering problem of dates

As the warning suggests, try specifying the correct 'InputFormat' when you call datetime.

datelike = {'01/10/2017' ; '02/10/2017'};
dt = datetime(datelike)
Warning: Successfully read the date/time text using the format 'MM/dd/uuuu', but their
format is ambiguous and could also be 'dd/MM/uuuu'. Specify a format character vector
to avoid ambiguity. 
> In guessFormat (line 66)
  In datetime (line 612) 
dt = 
  2×1 datetime array
   10-Jan-2017
   10-Feb-2017

versus:

datelike = {'01/10/2017' ; '02/10/2017'};
dt = datetime(datelike, 'InputFormat', 'dd/MM/uuuu')
dt = 
  2×1 datetime array
   01-Oct-2017
   02-Oct-2017

-Cam

MATLAB: Importing files automatically callback function error

addlistener automatically passes along two inputs, source and eventdata.

You can either have your function ignore these or ignore them in the call to addlistener

@(~,~)importfcn

The two ~s deny both inputs and then call importfcn as is.

Best Answer

Related Solutions

MATLAB: Filtering problem of dates

MATLAB: Importing files automatically callback function error

Related Question