writetable change "Row" in cell A1

6 views (last 30 days)
David
David on 7 Apr 2015
Edited: Leon on 15 Feb 2024
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?

Accepted Answer

Peter Perkins
Peter Perkins on 8 Apr 2015
David, you can set the dimension names property, such as
data.Properties.DimensionNames{1} = 'SomethingOtherThanRow';
Hope this helps.
  1 Comment
Leon
Leon on 15 Feb 2024
Edited: Leon on 15 Feb 2024
Very helpful! One minor correction: I found I needed to use brackets rather than curly braces:
my_table.Properties.DimensionNames(1) = "SomethingOtherThanRow";

Sign in to comment.

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!