PI系统客户端软件应用dl.pptVIP

* Editing an array All of PI DataLink functions, except PITagAtt(), PIPutVal(), and PIPutValX(), return array values. This being the case, you must first select the appropriate array output range. Next, enter the PI function and its arguments into Excels formula bar. Finally, place the PI function into the cells with the CTRL+SHIFT+ENTER combination of keystrokes. See the Excel Users Guide for more information on array functions. Also, note that Excel function wizard will only insert function into one cell on the spreadsheet. Therefore, it may not be appropriate to use the function wizard to enter PI functions into Excel. * Entering Timestamps into PI DataLink Many of the dialog boxes ask for a start time and an end time. In the edit fields, type in the desired PI time string. For example, 10-Nov-04 19:12. Note that for PI time in relative time format (for example, -1d), the reference time is different for the start time and the end time. The current wall clock is the reference time for the translation of the relative time in the start time field. However, the start time is used as the reference time for the translation of the relative time in the end time field. If you want to use cell references, you may refer either to cells that contain a PI time in string format (e.g.,, 10-Nov-04 19:12) or to cells that contain an Excel time (for example, 36504.8, formatted in whatever style you wish). Remember that Excel stores time as the number of days since 1900, but displays it according to Format ? Cells ? Number. For the time interval edit field, you may specify a number followed by an h or an m or an s (for hours, minutes, or seconds, respectively). For example, to indicate a time interval of thirty?two minutes, type 32m into the edit field. If you want to use cell references, you may refer only to cells that contain a valid PI time interval string. That is, you cannot refer to a cell containing an Excel time (i.e., a number). For example, to specify an interval