Originally posted by: janhess
It's in the documentation somewhere but I can't remember where. The only problem with this solution is that the spreadsheet needs to be open to ba able to access it. This can be rather limiting.
I found this in Help
DDEQUERY
The DDEQUERY function allows you to interface to other Windows applications such as Trading Partner PC, Excel, and so forth, provided that certain criteria are met. For example, if you receive an Excel spreadsheet file, you must have the appropriate version of the Excel application installed (that is compatible with the file received) and the application must be open.
Syntax
DDEQUERY (single-text-expression, single-text-expression, single-text-expression)
Meaning
DDEQUERY (application_name, topic, text)
Returns
This function returns a single-text-item.
Returns a single-text-item from an application.
Example
DDEQUERY ( "excel" , "
http://MKTPRICE.XLSSheet1" , "R8C1:R14C3" )
In this example, DDEQUERY is used to get data from an Excel spreadsheet. The third argument, R8C1:R14C3, specifies the location of the data in the spreadsheet. (In Excel, the 8th row, 1st column to the 14th row, 3rd column is A8:C14.) The content of this spreadsheet range is returned as a single text item.
Uses
As shown in the example above, you can use DDEQUERY to retrieve data from an Excel spreadsheet. Also, you can use DDEQUERY to ask Trading Partner PC for sender or receiver IDs for particular trading partners.
Message was edited by: janhess
#IBM-Websphere-Transformation-Extender#DataExchange#IBMSterlingTransformationExtender