|
|
 |
|
|
|
| Author |
Messages |
|
ealfonso
Posts:1
 |
| 11/06/2007 9:01 PM |
|
I'm using a trial of the SOA Express for Excel and I would like to know if can do the next:
I need to define the Inputs and Outputs fields not just cell by cell, but I need to select the Inputs as a Column and get the Outputs also as a column; and the number of rows can be different every time. For example:
Input / Output
2 / February
4 / April
7 / July
10 / October
Or if you have a sample with something similar to this I would appreciate you let me know where can I find it.
Thanks for your help.
Estela |
|
|
|
|
alex
Posts:24
|
| 11/28/2007 2:15 PM |
|
Estela -
You can make use of Excel's input array function. The following text from the SOAExpress Help explains how to do that:
Working with Web services that contain an input array – SOA Express for Excel uses a reference to an Excel array formula for an input array. An array formula is created by selecting the cells in the array and pressing CTRL+SHIFT+ENTER. To reference an array formula, select the input field (or fields) for the service, then create an array formula as described (CTRL+SHIFT+ENTER). When the service is invoked, an array will be constructed from the array formula and passed to the service.
|
|
|
|
|
|
| You are not authorized to post a reply. |
|
|
|
ActiveForums 3.7
|
|
|
|
|
|
|
|
|
|