MATLAB: How to export data in a wished format to excel

array to columnconvertexcelexporttable to column

I want to export the data below into excel and with xlswrite I managed to export it but in a non wished format, namely in the 4×52 table format in excel.

Are there ways to export each variable (4×52 array) just into 1 column in excel? So i managed to export the data like on the left side e.g. for "trialno" but i want to export the data like on the right side of the screenshot below for each 4×52 array respectivley. Thanks for you help!

Best Answer

Convert your data into column format and pass to xlswrite.

xlswrite(filename, trialno(:)); % trialno(:) will convert 4*52 to a column vector

Related Solutions

MATLAB: Color the particular row of the excel sheet

% Connect to Excel
Excel = actxserver('excel.application');
% Get Workbook object
WB = Excel.Workbooks.Open(fullfile(pwd, 'Book1.xlsx'),0,false);
% Set the color of cell "A1" of Sheet 1 to Yellow
WB.Worksheets.Item(1).Range('A1').Interior.ColorIndex = 6;
% Save Workbook
WB.Save();
% Close Workbook
WB.Close();
% Quit Excel
Excel.Quit();

Does this, ofcourse you can change all the values.

MATLAB: Is there any way to change the appearance of the output excel file as shown in the picture(only some is visible of heading as in Capture2.jpg wanted as Capture1.jpg)?? and can the heading be highlighted by any means in excel sheet ?

This is a problem of the display in Excel, not a Matlab problem.

What about: Ctrl-A and double click on one of the line margins between the columns in the heading line? Alternatively: Ctrl-A, Alt-H, O, I (in my German Excel 2010 it is Alt-R instead of Alt-H).

See e.g. https://www.ablebits.com/office-addins-blog/2017/03/16/autofit-excel-columns-rows/

Best Answer

Related Solutions

MATLAB: Color the particular row of the excel sheet

MATLAB: Is there any way to change the appearance of the output excel file as shown in the picture(only some is visible of heading as in Capture2.jpg wanted as Capture1.jpg)?? and can the heading be highlighted by any means in excel sheet ?

Related Question