MATLAB: How to import .mat file in excel

.mat fileimportprogramming

for i=1:10
    j(i)=i*5:
    end 
save('j.mat', 'j')

can i import this j.mat file in excel?

Best Answer

There are several worksarounds to do that, as explained in

http://www.mathworks.com/matlabcentral/answers/94104-how-can-i-directly-import-a-mat-file-into-an-excel-sheet-bypassing-matlab

Alternatively, you could create an excel file from Matlab using

xlswrite

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 save values in array or in .mat file by ascending order

j = sort( j );
save( 'j.mat', j );

In your example they would already be in ascending order though.

Best Answer

Related Solutions

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

MATLAB: How to save values in array or in .mat file by ascending order

Related Question