MATLAB: Writetable change “Row” in cell A1

MATLABtablewritetable

I'm familiar with the writetable function to save a table as an Excel file. I regularly use the WriteRowNames option to include the row names in the file. However, when Matlab writes the file it always write "Row" as the title of the series above the row names in cell A1 of the Excel file. Is there any way to change this label?

Best Answer

David, you can set the dimension names property, such as

data.Properties.DimensionNames{1} = 'SomethingOtherThanRow';

Hope this helps.

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: Precision in writetable()

Sadly, no. A OutputFormat formatting string or NumericPrecision option is not available.

I presume since a table can contain any data type including cells too many possibilities are opened up that TMW hasn't wanted to venture down that road.

Does seem like worthy of some design consideration for the normal cases, though, granted...

For text files, the numeric format is long g.

Best Answer

Related Solutions

MATLAB: Color the particular row of the excel sheet

MATLAB: Precision in writetable()

Related Question