MATLAB: How to save workspace variables to an excel file, storing them coloumn by coloumn with their respective name in the first row

excelfilenameMATLABsavesimulinkwinopenworkspacexlswrite

I have workspace variables (numbers) out of a simulation by Simulink. I'd like to save them in an excel file, each one with its name on the first row, then the values in coloumn. Than I'd like to automatically open the saved file in excel. Here below my draft code:

 filename='workspace_variable.xls';
 save(filename,'time','Temperature','-ASCII','-double');
 winopen('workspace_variable.xls');

I get error in excel that the file format and extension of the "workspace_variable.xls" don't match, then i click ok and it opens the file anyway. The cells are filled just in the first coloumn with "time" values, but not the coloumn for Temperature values.

Thank you.

Best Answer

eugenio - your code seems to be writing text data to a file that has an Excel extension, but this doesn't mean that you are creating an Excel file which may explain the format and extension error. You would need to use xlswrite to write your MATLAB data to an Excel file. See the examples from this link which show how you can do this.

As for your temperature values not appearing, I suspect that they are being appended beneath the time values. Again, see the xlswrite documentation to get an idea on how to write your variable data to specific columns in the Excel spreadsheet.

Or perhaps a text file is sufficient?

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

You can rename an Excel sheet using the "Name" property of a sheet object. For example the following renames the first sheet of an Excel file:

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;
% Rename the first sheet
Sheets.Item(1).Name = 'This is sheet 1';

The following code then saves the Workbook, quits Excel and removes the COM server:

% Save the file
Workbook.Save();
% Quit Excel, remove the COM server and delete the related objects
Excel.Quit();
Excel.delete();
clear Excel;
clear Workbook;
clear Sheets;

MATLAB: Write pre-existing variable names and their values to excel

load the data into a variable (as the load documentation states, it is a structure):

Results_Struct = load('1102 XRAIL_Z_Values.mat');

You can then get the variable names using fieldnames:

Results_Names = fieldnames(Results_Struct);

As the help and that error message tell you, the input to xlswrite must be a numeric, logical or cell array. You can easily get a cell array from the structure using struct2cell:

Results_Cell = struct2cell(Results_Struct);

Assuming that load returned a scalar structure then Results_Cell will have size px1x1, where p is the number of fields in the structure (i.e. the number of variables in the .mat file). You must ensure that the contents of each cell is a scalar: if this is not the case then you will need to deal with this in whatever way appropriate to your data. You could optionally convert this data to a numeric matrix.

You now have everything you need to call xlswrite.

Note that load-ing into a structure and using fieldnames is more efficient and less buggy than load-ing straight into the workspace and using who or whos.

Best Answer

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

MATLAB: Write pre-existing variable names and their values to excel

Related Question