Exporting code from MATLAB and producing a table in Excel.

I need to create a 3x2 arrangement of headers using the MATLAB function writetable. I need to replicate the picture below and include the same color code as well. I am having trouble doing so. The code is also attached below.

dataTable.Properties.RowNames % obtains the row names from the table
dataTable.Properties.VariableNames % obtains the variables

annotations.rowHeader % Obtains the Row Header from the table
annotations.columnHeader % Obtains the Column Header from the table
annotations.fileName % Obtains the File Name

%% Write to Excel Spreadsheet
writetable(dataTable,[annotations.fileName,'.xlsx']) % writes the table into an excel file 
writetable(dataTable,[annotations.rowHeader,'xlsx']) % locates the row Headers from excel file

[dpb]

Just make a template file and write the data to it...otherwise it's record a macro and see what it's content is to see what you need to write w/ COM engine to reproduce. That's far more trouble than worth most of the time unless you know VBA pretty well and have some idea how to translate it to COM-compatible code.

[Wisam Aboubaker]

I am a little confused.

[dpb]

About?

[Wisam Aboubaker]

What you said.

[dpb]

What, precisely?

I recommended that if you wanted an Excel spreadsheet with a fancy set of colorings, etc., that aren't part of the builtin features of the high-level tools in MATLAB to write to Excel files, the expedient way to do so is to make those changes in Excel (you appear to already have one, so that shouldn't be hard) and save that sheet as a template spreadsheet.

Then, open/create a new workbook from that template when you need it and use writetable to write the data to it with the formatting already in place.

Look at the Excel help files or DAGS to learn how to use Excel...

Doing those changes in MATLAB will have to be done by using the COM engine; there aren't functions with those in ML -- ML lets you read/write data to/from Excel but it's not TMW's job to make every piece of Excel available.

Answer 1

[Maadhav Akula]

Hi Wisam,

As @dpb pointed out there aren't direct functions/properties in Matlab that allow you to color code Excel cells, instead you have to utilise the COM Objects to do that.

You can have a look at the following posts which might help you out:

https://www.mathworks.com/matlabcentral/answers/410669-color-a-cell-excel-using-matlab

https://www.mathworks.com/matlabcentral/answers/3352-how-to-set-excel-cell-color-to-red-from-matlab

https://www.mathworks.com/matlabcentral/answers/102670-how-do-i-identify-which-methods-and-properties-i-need-to-use-when-calling-excel-from-matlab-using-co

https://www.mathworks.com/matlabcentral/answers/137633-change-with-matlab-the-background-color-of-a-cell-in-excel-64-bit

Hope this helps!