MATLAB: Three-dimensional matric and Excel

excelthree dimensional matrix

How can I send a Three-dimensional matrix to the Excel?

Best Answer

How about writing each matrix in a sheet.

A = rand(10,10,5) ; 
for i = 1:5
     xlswrite('test.xlsx',A(:,:,i),i) 
end

Related Solutions

MATLAB: Three-dimensional matrix and Excel

Hi,

How do you want your 3rd dimension to be represented in excel? You can use reshape command to change the matrix to be a 2D matrix and then export it to excel.

Check out this link

https://www.mathworks.com/matlabcentral/answers/266299-writing-exporting-3d-data-set-matrix-from-matlab-to-excel

You can also take a look at this file exchange page

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: Three-dimensional matrix and Excel

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

Related Question