9.1.1 Mapping to and from Excel Cells

Using the mapping directions “From Aras to Excel Cell” and “From Excel Cell to Aras” allow you to tie values of worksheet cells to properties in Aras. This can be used, for example, to drive a calculation in Excel from values coming from Aras. When using these options, the value specified in the “Office Property” column is the name of a named cell in Excel. To name a cell in Excel, select the cell, right click, and select Define Name….