MATLAB: Writing matlab table to excel with spaces in variable names

excelexportMATLABtable

Hello,

Is there are way to write your matlab table to a .xlsx file with spaces in the column names.

Error using test (line 36)

'Save Name' is not a valid variable name.

I use another program to call that variable and it needs to have a space in the excel doc. I am currently putting a stop in my code and manually changing it, because I use an underscore so it is valid.

Any help would be great.

Thanks!

Best Answer

No. You will need to convert your content to cell and put the desired names as the first row, and write the cell (without variable name). This was made slightly easier in R2019a with the new writecell()

Related Solutions

MATLAB: Writetable change “Row” in cell A1

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

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

Hope this helps.

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?

Best Answer

Related Solutions

MATLAB: Writetable change “Row” in cell A1

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

Related Question