Importing Data from a Workbook
To load data from a worksheet to a table in the Settings window of a feature, click the Load from File button () below the table. In the file type list select Microsoft Excel Workbook (*.xlsx). Select the desired file and click Open. Specify the sheet and cell range for the data.
Loading data from workbook files in a COMSOL Multiphysics model is also supported when Excel is not available.
In the Sheet text field enter the name of the worksheet containing the data. If no sheet name is defined, the first worksheet in the Excel file is selected by default.
In the Range field enter the cell range that holds the data. The range can be either defined using:
•
the top-left cell number, to import all data up to the next empty cell.
•
the cell range, to specify which cells are used for the import.
•
empty cell range, to import the entire worksheet.
Also see Supported Formats.
Clear the Overwrite checkbox to append the imported data to the end of the table. Note that you need to resolve conflicting data after the import.
Click Load to load the data to the table. Excel automatically starts in the background, if available. Excel will close after the import has been performed.
Excel usually locks the file when open it and hence the file cannot be loaded by other applications. Use Excel for reading the file to avoid this limitation.
Importing Model Parameters from a Workbook
In case you want to import a list of parameters from a workbook, the Excel Load dialog is slightly different as you have more import options.
For parameters import select Separate units column if the worksheet contains the units in separate but adjacent columns. Select Calculated values if the worksheet contains the parameters values in separate but adjacent columns.