Discussion Closed This discussion was created more than 6 months ago and has been closed. To start a new discussion with a link back to this one, click here.

Extracting data from COMSOL

Please login with a confirmed email address before reporting spam

Hello All

I just want to know how to extract data from COMSOL and then plotting graph in EXCEL sheet.
For example if I am trying to study transmittance with wavelength, then how to get the data into EXCEL.

Thanks

2 Replies Last Post Jun 23, 2015, 6:32 a.m. EDT

Please login with a confirmed email address before reporting spam

Posted: 9 years ago Jun 23, 2015, 3:15 a.m. EDT
Use the derived data sets to get the values for specific parameters that you need and use the export option under results to save the datas to a format easily recognizable by excel.
Use the derived data sets to get the values for specific parameters that you need and use the export option under results to save the datas to a format easily recognizable by excel.

Lars Gregersen COMSOL Employee

Please login with a confirmed email address before reporting spam

Posted: 9 years ago Jun 23, 2015, 6:32 a.m. EDT
Hi Kalpana

You can save data from most tables in Comsol. If you wish to save the data directly into an Excel file you need LiveLink for Excel:

www.comsol.com/livelink-for-excel


Using LiveLink for Excel you can also simply load the COMSOL model into Excel using VBA and extract exactly the data you need into VBA variables and/or Excel sheets.

--
Lars Gregersen
Comsol Denmark
Hi Kalpana You can save data from most tables in Comsol. If you wish to save the data directly into an Excel file you need LiveLink for Excel: http://www.comsol.com/livelink-for-excel Using LiveLink for Excel you can also simply load the COMSOL model into Excel using VBA and extract exactly the data you need into VBA variables and/or Excel sheets. -- Lars Gregersen Comsol Denmark

Note that while COMSOL employees may participate in the discussion forum, COMSOL® software users who are on-subscription should submit their questions via the Support Center for a more comprehensive response from the Technical Support team.