OLE linking

Revision as of 00:39, 21 October 2015 by JHernandez2 (talk | contribs) (Created page with "Category: Analytica User Guide <breadcrumbs> Analytica User Guide > Importing, Exporting, and OLE Linking Data > {{PAGENAME}}</breadcrumbs><br /> Object Linking and Embed...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)


Object Linking and Embedding (OLE) is a widely used Microsoft technology that enables objects in two applications to be hot-linked, so that changes to the object in one application cause the same changes in the other application. For example, by linking an array in Analytica to a table in a Microsoft Excel spreadsheet, any change to the array in the Analytica model is automatically reflected in the spreadsheet.

By using OLE linking, results from Analytica models can be linked into OLE compliant applica- tions like Word and Excel. Linking data can save a great deal of work because it saves you from performing repeated copy and paste operations between Analytica and other applications when- ever your model results change. Without OLE, if you copied result tables from Analytica, pasted them into a Word document, and later you tweak your model results, you would need to re-copy and re-paste all those result tables. However, if you link those tables using OLE, all the data in the Word document either updates automatically, or if you prefer, when you explicitly decide to update the data.

You can link any of the result table views (i.e., Mid, Mean, Statistics, Probability Density, Cumula- tive Probability, and Sample table views). You can link any two-dimensional slice of a multi-dimen- sional table with the regular Copy command. For result tables with more than two dimensions, you might decide to link the entire table as a series of two-dimensional tables using the Copy Table option from the Edit menu. You can also link a rectangular region of cells that are a subset of a a two-dimensional table. However, you cannot link non-table data such as the information that is contained in the Object window or Attribute panel.

Comments


You are not allowed to post comments.