Loading and Saving Excel® Files from the COMSOL Desktop®
LiveLink™ for Excel® adds the Excel XLSX format in the list of supported file formats for loading and saving data while setting up applications in the COMSOL Desktop. Feature nodes that support this functionality include Parameters, Variables, Interpolation functions, Piecewise functions, Parametric Sweep, the continuation section of the Stationary node, and the auxiliary sweep section. The data formats used by these features may differ. The easiest way to find out how to organize data in the Excel file is to enter some settings in a table in the COMSOL Desktop and save it to the Excel format.
In the current example, you will modify an existing model by importing model definitions from an Excel file. You will start by loading the model, Electrical Heating in a Busbar, from the COMSOL Multiphysics application library. This model analyzes the resistive heating of a busbar designed to conduct direct current. For details, see the booklet Introduction to COMSOL Multiphysics.
The tutorial walks you through how to import Excel files for three feature nodes, each with a different requirement on the data format. The feature nodes that are covered are: