MATLAB: How to get numerical values as well as texts in a single matrix after reading data from a excel file

MATLABmatrixxlsread

[num,txt]=xlsread(filename,sheet) here num contains all numerical value and nan (not a number)and txt contains all the texts.now ,how can i replace these nan elements in num by the elements of txt?

Best Answer

The easiest way (not having your file to test this on) is to add a third output to xlsread:

[num,txt,raw]=xlsread(filename,sheet)

The ‘raw’ output should have everything just as the function imported it.

Related Solutions

MATLAB: How to save certain parts of cleaned data from Excel Spreadsheet

save('filename.mat', 'answerKey', 'studentID', 'essay', 'multipleChoice');

MATLAB: Xlsread function: How to only get certain info from Excel Spreadsheets

>> help xlsread
  xlsread Read Microsoft Excel spreadsheet file.
    [NUM,TXT,RAW]=xlsread(FILE) reads data from the first worksheet in the Microsoft
    Excel spreadsheet file named FILE and returns the numeric data in array NUM.
    Optionally, returns the text fields in cell array TXT, and the unprocessed data
    (numbers and text) in cell array RAW.
 
    [NUM,TXT,RAW]=xlsread(FILE,SHEET) reads the specified worksheet.
 
    [NUM,TXT,RAW]=xlsread(FILE,SHEET,RANGE) reads from the specified SHEET and RANGE.
    Specify RANGE using the syntax 'C1:C2', where C1 and C2 are opposing corners of
    the region. Not supported for XLS files in BASIC mode.

Best Answer

Related Solutions

MATLAB: How to save certain parts of cleaned data from Excel Spreadsheet

MATLAB: Xlsread function: How to only get certain info from Excel Spreadsheets

Related Question