You can get the value of a particular named cell in an Excel spreadsheet and assign it to a !groupname! using the following command:

E.g., <<*Get*!DecedentName!jones probate.xlsx>>

Anatomy: <<*Get*!groupname!spreadheet.xlsx>>

<<*Get* = the command

!groupname! = the named cell in the target spreadsheet

spreadsheet.xlsx = the target spreadsheet. If the spreadsheet is in the folder of the source document OR in the assigned Excel folder, you need not 'qualify' -- i.e., add drive and folder information -- the spreadsheet. Otherwise, you must qualify the spreadsheet with full drive and path information.

   Groupname represents the groupname to which you wish to assign a numeric value. It must match the name of a cell  in the target Excel spreadsheet.

    Spreadsheet.xlsx is the target from which the groupname value will be drawn. If not fully qualified (i.e., no drive and path preceding the name), Pathagoras will look (first) in the folder from which the base document is called and if not found there, in the folder that has been set as your 'default' Excel data files folder (typically, and by default C:\program files (x86)\Pathagoras\IDBS).

    Note: if you don't want to pre-assign a specific spreadsheet, put '*.*' where the spreadsheet name would by typed. Pathagoras will let you navigate to a specific spreadsheet. E.g., <<*Get*!DecedentName!*.*>>

Usage: The <<*Get* command 'gets' a value, but does not place it or type it anywhere. You must use another tool to use or to place its value. (In this regard, the <<*Get* . . .>> is similar to an <<*Ask . . .* command.>> Once 'gotten,', you can use the value assigned to the !groupname! for any other purpose in the document.

You can compare its value with another using the <<*If* command.

You can analyze it using Pathagoras 'range' function. (In this case, Pathagoras will process the result and return an appropriate block of text associated with the 'gotten' value. Perfect for psychologists and others who need to provide information associated with a particular score on a test. Lots of other applications possible.)

You can place the actual value of the !groupname! in the in the document body in this style <<!groupname!>>

Getting multiple values: to save a bit of time, you can request multiple values from the same spreadsheet. Just list the target names as part of a 'long' groupname, separatng the individual names with commas. E.g.

<<*Get*!DecedentName,DecedentCity,PRName!jones probate.xlsx>>

 

Created with Help & Manual 7 and styled with Premium Pack Version 2.70 © by EC Software