文档下载 文档下载导航
设为首页 | 加入收藏
搜索 请输入内容:  
 导航当前位置: 文档下载 > 所有分类 > IT/计算机 > MATLAB EXCEL Builder 矩阵计算实例
侵权投诉

MATLAB EXCEL Builder 矩阵计算实例

This is a demo for MATLAB Excel Builder. This demo explains how one can compile MATLAB code into an Excel based COM component using MATLAB Excel Builder and use the same in Excel VBA. This demo compiles a MATLAB code that does basic matrix manipulations like addition, subtraction, multiplication, division, and eigen values into an Excel based COM component.

How to use Excel Builder to create COM components using a Matrix Calculator Example:

Background:

With the help of this example we will try to export the MATLAB utilities to do some basic matrix arithmetic to COM clients. We have written small code to do matrix addition, subtraction,

multiplication, division and left division along with a function to evaluate the eigen value for a matrix. These routines are then compiled into a COM component using MATLAB COM Builder.

This example will walk you through how to create an Excel based COM component using MATLAB Excel Builder and how to use this component in an Excel VB macro independent of MATLAB.

How to create the component?

This section describes the prerequisites needed to use the component and how to see the component in use with the files provided with the package.

Pre-requisites

You need to have the latest release of MATLAB, version 6.5 (Release 13), installed on your machine. You will also need MALTAB Compiler version 3.0 and MATLAB Excel Builder Toolbox version 1.1 installed. If you do not have any of these components and if you are under software maintenance you can download a 30-day trial for MATLAB Compiler or MATLAB Excel Builder Toolbox by logging into the download section of The MathWorks, Inc. website at:

If you do not have a license of the latest release of MATLAB and/or MATLAB Compiler and are not able to download the same, please contact your Sales Representative to assist you with this.

What’s included in the package

The example package consists of a self-extracting zip file called MatrixMathExcelDemo.exe. This archive contains the following files:

1. The necessary elements to build the component:

a. addMatrices.m, divideMatrices.m, eigenValue.m, leftDivideMatrices.m, multiplyMatrices.m,

subtractMatrices.m - The MATLAB source code that is compiled into the component

b. matrixMath.xls - The XLS file which is used for testing the component and creating the add-in

c. matrixMath.xla - The Excel add-in that can be used in other Excel files independent of

MATLAB.

2. Documentation – matrixArithDoc.doc

How to create the Excel based COM component?

Copy the m-files in <matlab>\work\MatrixArith directory

From the MATLAB command prompt change directories to <matlab>\work\MatrixArith. Enter the command mxltool to start the MATLAB Excel Builder graphical user interface.

1

1

<matlab> represents the root MATLAB directory

第1页

你可能喜欢

  • matlab实例教程
  • excel VBA
  • matlab矩阵操作
  • matlab积分
  • 矩阵计算
  • 编程实例

热门文档

相关文档

  • 利用Excel进行矩阵计算

    利用Excel进行矩阵计算_理学_高等教育_教育专区。矩阵计算利用Excel 进行矩阵计算 - 1 - 利用 Excel 进行矩阵计算目前有很多软件可进行矩阵运算,特别是 Matlab,其...

  • MATLAB矩阵运算与应用实例

    MATLAB矩阵运算与应用实例_理学_高等教育_教育专区。MATLAB矩阵运算与应用实例...使用xlsread()函数; Read a specific range of data from the Excel file in...

  • Matlab教程之矩阵运算

    第3章 矩阵、数组和符号运算 MATLAB 以矩阵为基本的运算单元,向量和标量作为 特殊的矩阵处理:向量看作只有一行或一列的矩阵; 标量看作只有一个元素的矩阵。 1、...

  • matlab矩阵的简单运算

    MatLab 中的矩阵 我们知道,求解线性方程组是线性代数课程中的核心内容,而矩阵 ...矩阵的基本运算 1、四则运算 例 5.矩阵 矩阵的加法 矩阵 X=A+B X= 9 4...

  • MATLAB矩阵运算与应用实例

    MATLAB矩阵运算与应用实例_计算机软件及应用_IT/计算机_专业资料。MATLAB矩阵运算...使用xlsread()函数; Read a specific range of data from the Excel file in...

  • MATLAB中的矩阵运算

    MATLAB中的矩阵运算_初三数学_数学_初中教育_教育专区。matlab 基本教程MATLAB中的矩阵运算哈 工程大学数学实验电子教案 MATLAB与其它数学软件的不同之处就在于强大...

  • Excel矩阵

    利用 Excel 进行矩阵计算目前有很多软件可进行矩阵运算, 特别是 Matlab, 其矩阵运算功能尤为强大。 但这些专业软件所占空间很大,价格昂贵。其实 Excel 就有矩阵运算...

  • Matlab矩阵运算

    2013年全国大学生数学建模竞赛江西赛区九江学院赛点培训 MATLAB 矩阵运算主讲教师:... Excel键盘快捷键 Photoshop的抠图技巧分析 20份文档 乘机安全小贴士 安全乘机...

  • 基于MATLAB的EXCEL数据计算与分析

    基于MATLAB的EXCEL数据计算与分析_计算机软件及应用_IT/计算机_专业资料。结合本人近期工作上的需要测量计算,想偷懒就选择了利用MATLAB偷懒,于是便有了本文。本文...

  • Matlab灰度共生矩阵计算

    Matlab灰度共生矩阵计算_数学_自然科学_专业资料。灰度共生矩阵计算一个简单的灰度共生矩阵计算实例本科的时候学过杨磊库老师讲授的武大贾永红编的《数字图像处理》...

站点地图 | 文档上传 | 侵权投诉 | 手机版
本站所有资源均来自互联网,本站只负责收集和整理,均不承担任何法律责任,如有侵权等其它行为请联系我们.
文档下载 Copyright 2013 doc.guandang.net All Rights Reserved.  -  email