WarningYour internet explorer is in compatibility mode and may not be displaying the website correctly.
You can fix this by pressing 'F12' on your keyboard, Selecting 'Document Mode' and choosing 'standards' (or the latest version
listed if standards is not an option).
For Simplifying and Extending Your Modeling with Excel®
A parametric simulation of an aluminum heat sink used for the cooling of components in electronic circuits. The parameters controlling the geometric dimensions as well as the inlet air velocity are edited in an Excel spreadsheet and synchronized with COMSOL Multiphysics. The postprocessed COMSOL model can be brought into the Excel spreadsheet as a figure.
Integrating Spreadsheets with COMSOL Multiphysics
The simulation capabilities of Excel® can be augmented by seamlessly integrating them with COMSOL Multiphysics®. Whether you are an engineer with years of Excel data describing your process and looking to utilize it in a COMSOL Multiphysics simulation, or you are a scientist wanting to utilize simulation to find and optimize the value of a material property, LiveLink™for Excel® will provide you with the flexibility you need.
LiveLink™for Excel® allows you to take advantage of the capabilities and structured simplicity offered by Excel to extend your COMSOL Multiphysics® modeling capacity. Parameters and variables that are defined and modeled in COMSOL Multiphysics are instantly available in Microsoft® Excel® and automatically synchronized with your physics model. Moreover, LiveLink™ adds the capability to create a COMSOL® material library from data stored in a worksheet and brings it into COMSOL Multiphysics, while also enabling support for loading Excel files for parameter and variable lists in the COMSOL Desktop®.
The COMSOL Multiphysics tab within Excel gives you access to a number of the features and functionalities that are available in COMSOL Multiphysics – such as opening and saving models, importing and re-defining parameters, variables, and functions, running mesh and solver routines, extracting and treating data, and presenting your results.
The Material Export Settings dialog box allows you to create a material library accessible by COMSOL models from material data you have stored in an Excel file. The equivalent cells in the Excel file are called from the material and property range edit fields.
A COMSOL Model window is opened when running and solving models from the Excel interface to show the geometry, mesh, and postprocessing views of your model, along with the progress of the solving process.
Model of the Joule heating of a busbar where a parametric sweep is run over the operating voltage. Tools from Excel are used to plot the temperature versus electric potential relationship. The temperature profile along an edge, at different voltages, is also plotted by extracting data from the COMSOL Multiphysics model.
Working with Excel® in the COMSOL Multiphysics® Environment
LiveLink™for Excel® provides tools to import data directly into COMSOL Multiphysics for further use in the modeling workflow. This can include importing several of the model definitions like parameters, variables and functions, from a worksheet. Furthermore, with LiveLink™for Excel® you can create a material library within Excel and configure the export in such a way that COMSOL Multiphysics recognizes the material properties and stores them appropriately in your Material Library. You can export results to Excel, where you can compare, optimize, and calibrate these material properties.
Microsoft, Excel, and Windows are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. All other trademarks are the property of their respective owners. For a list of such trademark owners, see http://www.comsol.com/tm. COMSOL AB and its subsidiaries and products are not affiliated with, endorsed by, sponsored by, or supported by these trademark owners.
Working with COMSOL Multiphysics® Models in the Excel® Environment
LiveLink™for Excel® lets you perform and control your COMSOL Multiphysics modeling from an Excel environment. When LiveLink™for Excel® is installed, a COMSOL Multiphysics tab is immediately made available in the Excel ribbon.
With the provided COMSOL-specific icons in the Excel ribbon, you can control most of the steps in your modeling process. This includes opening and saving models; importing and re-defining parameters, variables, and functions; running mesh and solver routines; extracting and treating data; and presenting your results. Parameters are automatically synchronized with cells in the Excel worksheet, and they can be changed on-the-fly and re-synchronized, and the model can be solved again. Moreover, you can augment your COMSOL modeling with some of the tools and functionality provided by Excel. For instance, columns of data in the Excel worksheet can be used to define the point coordinates for evaluations to be performed based on the model solution. After the evaluation, extracted results will populate related Excel columns, and you can achieve curve-fitting of the extracted data by using tools from Excel.
When you open a COMSOL model from Excel, a specialized graphics interface, known as the COMSOL Model window, is made available. This allows you to track the progress of the actual modeling being controlled from Excel as it displays the model geometry, mesh, and result plots. The solvers' progress and other model information can also be viewed here. The COMSOL Model window represents a COMSOL server application running in the background, where the model is loaded, and you do not need to have COMSOL Multiphysics open in the background to be able to manage your modeling from Excel. Additionally, LiveLink™for Excel® provides seamless integration so you can insert your COMSOL Multiphysics graphics, along with your other figures and tables, to produce a complete worksheet presentation.
Perform and control your COMSOL Multiphysics modeling from the Excel environment
Open COMSOL Multiphysics models from an Excel workbook
Synchronize model parameters, variables, and functions with an Excel worksheet
Change parameters, variables, and functions in the worksheet, then update and solve the model
Run parametric sweeps from the Excel environment
Extract results from a model to an Excel worksheet
Track the progress of the solution through the COMSOL Model window
While modeling in the COMSOL Desktop, load and save model definitions from an Excel workbook
Create COMSOL material libraries from data in an Excel worksheet
Supports Excel for Windows: Excel 2013 (Desktop version, MSI-based installation), Excel 2010 (not Excel 2010 Starter), and Excel 2007
Supported File Formats
Video Tutorial: Importing Excel Data into a COMSOL Model
Integrating Microsoft Excel® with COMSOL Multiphysics streamlines the workflow within your engineering team. With LiveLink™ for Excel® you can create COMSOL models using data previously gathered and processed in Excel®.
LiveLink™ for Excel®
Electrical Heating in a Busbar Using the LiveLink for Excel
Tutorial model that demonstrates how to work with COMSOL models in Excel, including loading and saving files, updating model parameters, solving, and retrieving results.