1. Catalogs
  2. The MathWorks
  3. Spreadsheet Link EX (for Microsoft Excel)

Spreadsheet Link EX (for Microsoft Excel)

Spreadsheet Link EX (for Microsoft Excel)

Spreadsheet Link EX (for Microsoft Excel)

Product catalog summary
Overview: Spreadsheet Link™ EX is a software tool that connects Microsoft Excel with the MATLAB workspace, allowing users to leverage MATLAB's computational and visualization capabilities directly from Excel. This integration facilitates data exchange and enhances data analysis using MATLAB's advanced functions.
Key Features:
  • Data preprocessing, editing, and viewing within Excel's familiar environment.
  • Advanced analysis of Excel data using MATLAB and its toolboxes.
  • Development of Excel-based applications using MATLAB as a computational engine.
  • Interactive function selection via the MATLAB Function Wizard.
  • Customizable preferences through a visual interface.
Functionality: Spreadsheet Link EX operates as an Excel add-in, managing communication between Excel and MATLAB through ActiveX. It allows users to:
  • Manage the connection between Excel and MATLAB.
  • Automatically start MATLAB when Excel is launched.
  • Transfer data bidirectionally between MATLAB and Excel.
  • Execute MATLAB functions directly from Excel.
  • Navigate and run MATLAB functions using the Function Wizard.
Data Management: Users can edit and view data in Excel, then pass it to MATLAB for further analysis. Data from MATLAB can also be imported back into Excel. This integration supports the use of MATLAB functions within Excel formulas, macros, and Visual Basic subroutines.
Resources: Additional resources include online user communities, training services, and third-party products and services. Technical support and sales contacts are available through MathWorks' website.
See more

Catalog excerpts

Spreadsheet Link EX (for Microsoft Excel)-1

Spreadsheet Link EX for Microsoft Excel Use MATLAB from Microsoft Excel Spreadsheet Link™ EX connects Excel® spreadsheet software with the MATLAB® workspace, enabling you to access the MATLAB environment from an Excel spreadsheet. With Spreadsheet Link EX 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. Key Features ▪ Data preprocessing, editing, and viewing in the familiar Excel® environment ▪ Sophisticated analysis of Excel data using MATLAB® and application toolboxes ▪ Delivery of Excel based applications, using MATLAB as a computational and graphics engine and Excel as an interface ▪ Interactive selection of available functions using the MATLAB Function Wizard ▪ Visual interface for customization of all Spreadsheet Link™ EX preferences Spreadsheet Link EX is especially useful as an array editor for viewing and editing data interactively in any MATLAB application. Any data that you can import into Excel can be passed to MATLAB for analysis and visualization. The connection between MATLAB and Excel is "live" and requires no intermediate files or low-level, inter-process programming.

 Open the catalog to page 1
Spreadsheet Link EX (for Microsoft Excel)-2

MATLflB Function Wi?ard Function Arguments | matlab\elmat - Elementary matrices and matrix manic ^"j Update Opt trial output cell(s); I RAND Uniformly distributed pseudo-random numbers, R = RflND(rj) returns an N-by-N matrix containing pseudo-random values drawn from a uniform distribution on the unit interval. RAND(M,N) or RAND([M,N]) returns an M-by-PJ matrix. RANDOM, N,P,,..) or RAND([M,N,P,"]) returns an M-by-N-by-P-by-,,, array. RAND with The MATLAB Function Wizard for Spreadsheet Link™ EX. You can browse MATLAB and run selected functions from an Excel spreadsheet. directories and functions...

 Open the catalog to page 2
Spreadsheet Link EX (for Microsoft Excel)-3

to the MATLAB workspace. Similarly, you can easily bring data from the MATLAB workspace into an Excel The MATLAB workspace includes all the variables created by MATLAB, Handle Graphics , and related toolboxes. MATLAB functions can access and share the data in these variables, and you can call these same MATLAB functions from Excel formulas, macros, or Excel Visual Basic subroutines or functions. Because both MATLAB and Excel are extensible, you can develop and incorporate your own data analysis MATLAB current wetting drectay I- Treat mssn^farrpt!/ rat as r-JaH The Preferences dialog, which you...

 Open the catalog to page 3

All The MathWorks catalogs and technical brochures

  1. Stateflow

    8  Pages

  2. SimEvents

    7  Pages

  3. SimDriveline

    7  Pages

  4. SimHydraulics

    7  Pages

  5. SimRF

    6  Pages

  6. MATLAB Coder

    5  Pages

  7. OPC Toolbox

    5  Pages

  8. SimBiology

    6  Pages

  9. xPC Target

    5  Pages

  10. SimMechanics

    7  Pages

  11. Simscape

    7  Pages

  12. Simulink

    6  Pages

  13. MATLAB®

    6  Pages

*Prices are pre-tax. They exclude delivery charges and customs duties and do not include additional charges for installation or activation options. Prices are indicative only and may vary by country, with changes to the cost of raw materials and exchange rates.