What do you mean by excel client, i think you would like to export the o/p of your service to an excel sheet. For this follow the below procedure:
Follow the [url=http://idnxchange.com/webmethods-blogs/webmethods-step-by-step-xml-to-flat-file.html]post[/url] to first transform your data to Flat file.
Try Tab delimited files with a .xls extension. These files can be easily created and can be opened by Excel as worksheets - No need to worry about quotes.
You can create a template or just use variable substitution for each record to a tab delimited line. And place an Enter after each record.
Then while using writeToFile service, specify the extension as .xls.
Anusha
Hi,
I need step by step procedure for building excel client using developer.
Thanks&Regards
Anuarthi
Tomas
Anuarthi,
What do you mean by excel client, i think you would like to export the o/p of your service to an excel sheet. For this follow the below procedure:
Follow the [url=http://idnxchange.com/webmethods-blogs/webmethods-step-by-step-xml-to-flat-file.html]post[/url] to first transform your data to Flat file.
Try Tab delimited files with a .xls extension. These files can be easily created and can be opened by Excel as worksheets - No need to worry about quotes.
You can create a template or just use variable substitution for each record to a tab delimited line. And place an Enter after each record.
Then while using writeToFile service, specify the extension as .xls.
Hope this helps.
Anusha
Hi,
Building a excel client means using the service generated in webMethods in an excel sheet
Regards
anusha