MATLAB: I want to cycle average an excel data (36000*5) which repeats every 720 deg and make a separate excel file

jithinlukose@gmail.com

I want to cycle average an excel data (36000*5) which repeats every 720 deg and make a separate excel file. I wat to cycle average every 720 degree and make a separate excel sheet

Best Answer

Read about reshape. You can reshape your data into 3D matrices and then write into excel sheet.

Related Solutions

MATLAB: I have few excel program that I needed to be read by MATLAB. Now I want to enter the file name as an input. How to make Matlab read that input file name

Hi,

xlsfinfo will get you a list of sheet names into your Excel file.

[~,sheets] = xlsfinfo(filename);

Then you can use xlsread to read data from each specific sheet.

A more elegant way (that I suggest) is to learn how to use ActiveX to parse data from your Excel e.g.

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;
% Save the file
Workbook.Save();
% Quit Excel, remove the COM server and delete the related objects
Excel.Quit();
Excel.delete();

A good starting point is here as reference Are there any examples that show how to use the ActiveX automation interface to connect MATLAB to Excel?

MATLAB: I have a multi dimension matrix (:,:,:) that I need to export to excel

If it would be acceptable to have all matrices in one excel sheet, you could use:

A = (reshape(your_matrix,5,[],1))'

Best Answer

Related Solutions

MATLAB: I have few excel program that I needed to be read by MATLAB. Now I want to enter the file name as an input. How to make Matlab read that input file name

MATLAB: I have a multi dimension matrix (:,:,:) that I need to export to excel

Related Question