MATLAB: How to import entire columns from an excel file into MATLAB 7.6 (R2008a)

columncolumnsexcelMATLABreadxlsread

I would like to import all of a column (column C for instance) into MATLAB. The data in the columns may be of mixed type (text and numerical).

Best Answer

The XLSREAD function can be used for importing excel files into MATLAB 7.6 (R2008a). You can read entire columns, for instance column C, of an excel file using the following syntax:

[num, txt, raw] = xlsread('filename.xls',1,'C:C');

For more information on the XLSREAD function consult the documentation by executing the following at the MATLAB prompt:

doc xlsread

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

You can rename an Excel sheet using the "Name" property of a sheet object. For example the following renames the first sheet of an Excel file:

filename = 'C:\SomeExcelFile.xls';
% Open Excel Automation server
Excel = actxserver('Excel.Application');
% Make Excel visible
Excel.Visible=1;
% Open Excel file
Workbook = Excel.Workbooks.Open(filename);
% Get the list of sheets in the workbook
Sheets = Excel.ActiveWorkbook.Sheets;
% Rename the first sheet
Sheets.Item(1).Name = 'This is sheet 1';

The following code then saves the Workbook, quits Excel and removes the COM server:

% Save the file
Workbook.Save();
% Quit Excel, remove the COM server and delete the related objects
Excel.Quit();
Excel.delete();
clear Excel;
clear Workbook;
clear Sheets;

MATLAB: How to take input as excel file from user in matlab?

[filename, pathname] = uigetfile({'*.xls', '*.xlsx'}, 'Pick an excel file');
fullname = fullfile(pathname, filename);
[num, txt, raw] = xlsread(fullname);

Best Answer

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

MATLAB: How to take input as excel file from user in matlab?

Related Question