MATLAB: Reading excel files with texts in matlab

importing excel data

I have an excel file with fields that are texts that I want to read.

X = xlsread('filename') reads the numbers, but does not read the texts. How to solve this problem?

if true
[X,T,c] = xlsread ('file_name');
end

Try this.

[numbers, strings, everything] = xlsread(filename);

You can control the excel file directly without importing it through ActiveX:

% Open the excel file (it remains invisible however)

excel    = actxserver ('Excel.Application');
% excel.Visible = 1;
workbook = excel.Workbooks.Open('C:\Users\ok1011\Desktop\test.xlsx');

% Activate the sheet you need (optional if the sheet is the first)

workbook.Worksheets.Item(1).Activate;

% Delete A2, shifts upwards

workbook.ActiveSheet.Range('A2').Delete

% Now save/close/quit/delete

% excel.Visible = 0;
workbook.Save;
excel.Workbook.Close;
invoke(excel, 'Quit');
delete(excel)