MATLAB: How will we convert xls files into mat files please help me

xlsread

how will we convert xls files into mat files? please help me

Best Answer

Try this

    file = dir('*.xl*');    %dir excel
    filename = file.name;   %filename_excel
    excel_path = [pwd, '\', filename];  %get the path of the excel
    [ndata, headertext] = xlsread(excel_path);  %read the data from the excel
    save('a.mat','ndata'); %save to a.mat

Related Solutions

MATLAB: Please tell me how resole this error. “Error in EXCEL_READ_WRITE (line 10) Excel_open = excel_workbook.open(filepath); “

Excel_open = excel_workbook.Open(filepath)

It's Open not open (with uppercase)

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;

Best Answer

Related Solutions

MATLAB: Please tell me how resole this error. “Error in EXCEL_READ_WRITE (line 10) Excel_open = excel_work​book.open(​filepath); “

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

Related Question

MATLAB: Please tell me how resole this error. “Error in EXCEL_READ_WRITE (line 10) Excel_open = excel_workbook.open(filepath); “