Skip to content
MathWorks - Mobile View
  • Inicie sesión cuenta de MathWorksInicie sesión cuenta de MathWorks
  • Access your MathWorks Account
    • Mi Cuenta
    • Mi perfil de la comunidad
    • Asociar Licencia
    • Cerrar sesión
  • Productos
  • Soluciones
  • Educación
  • Soporte
  • Comunidad
  • Eventos
  • Obtenga MATLAB
MathWorks
  • Productos
  • Soluciones
  • Educación
  • Soporte
  • Comunidad
  • Eventos
  • Obtenga MATLAB
  • Inicie sesión cuenta de MathWorksInicie sesión cuenta de MathWorks
  • Access your MathWorks Account
    • Mi Cuenta
    • Mi perfil de la comunidad
    • Asociar Licencia
    • Cerrar sesión

Vídeos y webinars

  • MathWorks
  • Vídeos
  • Vídeos-Inicio
  • Buscar
  • Vídeos-Inicio
  • Buscar
  • Comuníquese con ventas
  • Software de prueba
2:14 Video length is 2:14.
  • Description
  • Full Transcript
  • Related Resources

How to Install and Use Spreadsheet Link

Spreadsheet Link™ connects Microsoft® Excel® spreadsheet software with the MATLAB® workspace, enabling you to access the MATLAB environment from an Excel spreadsheet. With Spreadsheet Link software, you can exchange data between MATLAB and Excel, taking advantage of the familiar Excel interface while accessing the computational speed and visualization capabilities of MATLAB.

For MATLAB Version R2016b and later, use Excel versions 2019, 2016, 2013, 2010, 2007.

For MATLAB Version R2013b, use Excel versions 2013, 2010, 2007.

In this video, I am going to show you how to install and use Spreadsheet Link for Microsoft Excel.

First, what is Spreadsheet Link?

Spreadsheet Link enables you to access the MATLAB environment from an Excel spreadsheet using an add-in that handles communication between both environments. You can exchange data between MATLAB and Excel, taking advantage of the Excel interface while accessing the computational speed and visualization capabilities of MATLAB.

To enable the Spreadsheet Link add-in, start a Microsoft Excel session and follow these steps.

  1. Select File from the main menu.
  2. Click Options.
  3. Click Add-Ins.
  4. From the Manage selection list, choose Excel Add-Ins.
  5. Click Browse.
  6. The add-in is located in your MATLAB directory. To find it, enter matlabroot on the MATLAB command window, and you can get the path where MATLAB on your computer is installed.
  7. Copy and paste the link in the browse window.
  8. Select toolbox; exlink and then chose exclink.
  9. Click OK to close the dialog box.

The Spreadsheet Link add-in loads and will be available each time you open a new Excel session.

You can check the MATLAB options from the home tab or right-click a cell to see the options list, allowing you to control how MATLAB and Excel interact.

Now, let’s see how to call MATLAB functions through an example.

We have here the closing prices of S&P500 already loaded in the spreadsheet. We can calculate the maximum drawdown, which is the maximum observed loss, by specifying maxdrawdown as the command and selecting the range of data.

To recap, we have seen in this video how to install Spreadsheet Link and MATLAB functions from Excel.

To find out more about the capabilities of Spreadsheet Link, please visit the spreadsheet link product page, where you can read the documentations, watch additional videos, and find examples. Thank you for watching.

Related Products

  • Spreadsheet Link
  • MATLAB

Learn More

Download code

3 Ways to Speed Up Model Predictive Controllers

Read white paper

A Practical Guide to Deep Learning: From Data to Deployment

Read ebook

Bridging Wireless Communications Design and Testing with MATLAB

Read white paper

Deep Learning and Traditional Machine Learning: Choosing the Right Approach

Read ebook

Hardware-in-the-Loop Testing for Power Electronics Control Design

Read white paper

Predictive Maintenance with MATLAB

Read ebook

Electric Vehicle Modeling and Simulation - Architecture to Deployment : Webinar Series

Register for Free

How much do you know about power conversion control?

Start quiz

Feedback

Featured Product

Spreadsheet Link

  • Request Trial
  • Get Pricing

Up Next:

2:37
Project-Based Learning: Students learn how to better use...

Related Videos:

4:26
When and How to Use a Data Dictionary
6:50
New Spreadsheet Import Tool in R2011b
12:23
Raspberry Pi Support from MATLAB, Part 1: Getting Started...
2:04
Install the MATLAB and Simulink Support Packages for Arduino

View more related videos

MathWorks - Domain Selector

Select a Web Site

Choose a web site to get translated content where available and see local events and offers. Based on your location, we recommend that you select: .

  • Switzerland (English)
  • Switzerland (Deutsch)
  • Switzerland (Français)
  • 中国 (简体中文)
  • 中国 (English)

You can also select a web site from the following list:

How to Get Best Site Performance

Select the China site (in Chinese or English) for best site performance. Other MathWorks country sites are not optimized for visits from your location.

Americas

  • América Latina (Español)
  • Canada (English)
  • United States (English)

Europe

  • Belgium (English)
  • Denmark (English)
  • Deutschland (Deutsch)
  • España (Español)
  • Finland (English)
  • France (Français)
  • Ireland (English)
  • Italia (Italiano)
  • Luxembourg (English)
  • Netherlands (English)
  • Norway (English)
  • Österreich (Deutsch)
  • Portugal (English)
  • Sweden (English)
  • Switzerland
    • Deutsch
    • English
    • Français
  • United Kingdom (English)

Asia Pacific

  • Australia (English)
  • India (English)
  • New Zealand (English)
  • 中国
    • 简体中文Chinese
    • English
  • 日本Japanese (日本語)
  • 한국Korean (한국어)

Contact your local office

  • Comuníquese con ventas
  • Software de prueba

MathWorks

Accelerating the pace of engineering and science

MathWorks es el líder en el desarrollo de software de cálculo matemático para ingenieros

Descubra…

Explorar productos

  • MATLAB
  • Simulink
  • Software para estudiantes
  • Soporte para hardware
  • File Exchange

Probar o comprar

  • Descargas
  • Software de prueba
  • Comuníquese con ventas
  • Precios y licencias
  • Cómo comprar

Aprender a utilizar

  • Documentación
  • Tutoriales
  • Ejemplos
  • Vídeos y webinars
  • Formación

Obtener soporte

  • Ayuda para la instalación
  • MATLAB Answers
  • Consultoría
  • Centro de licencias
  • Comuníquese con soporte

Acerca de MathWorks

  • Ofertas de empleo
  • Sala de prensa
  • Misión social
  • Casos prácticos
  • Acerca de MathWorks
  • Select a Web Site United States
  • Centro de confianza
  • Marcas comerciales
  • Política de privacidad
  • Antipiratería
  • Estado de las aplicaciones

© 1994-2022 The MathWorks, Inc.

  • Facebook
  • Twitter
  • Instagram
  • YouTube
  • LinkedIn
  • RSS

Únase a la conversación