Exporting Data to a Workbook
In the Settings window of the feature click the Save to File button (), usually located below the table. From the Save as type list select Microsoft Excel Workbook (*.xlsx), then specify the desired filename and click Save. Specify the sheet and cell range for the data export.
Saving data to workbook files from a COMSOL model is also supported when Excel is not available.
In the Sheet text field enter the worksheet name where to store the data. If no sheet name is defined, the first worksheet of the Excel workbook is selected by default.
In the Range field enter the cell range where data should be written. The range can be either defined using:
•
a unique cell number defining the top cell in the worksheet.
•
a cell range, to specify the cell where to save the data. Only the data within the specified cell range are exported.
•
an empty cell range, all the data are saved starting from the cell A1.
Also see Supported Formats.
Clear the Overwrite checkbox if you want to append the data to the Excel file. Note that you can only append data to empty cells.
Select Include headers to export the table header row together with the data.
Click Save to save to export the data. Excel automatically starts in the background, if available. Excel will close after the export has been performed.
Exporting Model Parameters To a Workbook
In case you want to export the model parameters to a workbook, the Excel Save dialog is slightly different as you have more export options.
For parameters import select Separate units column to save the units in separate columns. Select Calculated values to save the parameter values in separate columns.