Click to enlarge Click to enlarge What are Web Services?   Web Services allow you to encapsulate a piece of software functionality in an XML based service which can then be called from various applications (even in an inhomogeneous IT environment). Web Services contain pieces of business logic that are typically defined by business analysts in the operating department.   New: Model your Web Services with Microsoft Excel   Building Web Services used to be an expensive and time consuming task, since professional programming skills were required. With Worksheet-Server, business analysts can now directly deploy Excel-based Business Logic as Web Services, eliminating the time and costs required for software coding.
Web-Services with Worksheet-Server - Step by Step         Step 1: Create the Excel Model   (you can download a sample workbook here)   Step 2: Define the Input Cells of the Web Service   Simply "unlock" all Input Cells on the sheet. Then name all input cells using Excel's INSERT NAME DEFINE command.   Step 3: Define the Output Cells of the Web Service   Simply name all output cells using Excel's INSERT NAME DEFINE command.   Step 4: Upload your Excel Model to the Jedox Worksheet-Server   If you don't have a Worksheet-Server available, you can contact Jedox for a demo upload of your file (corporations only)   Step 5: Call the Web Service   To see how to do this, simply check the Working Demos on the right side of this page		Try these Working Demos         Demo 1: Call the Web Service by a URL   Click the following URL to see the Web Service in action. Once you see the result of the Web Service in your browser, start modifing the last 4 parameters of the URL. For example set 'Quantity=10' to 'Quantity=100' and check the result again.   Demo 2: Call the Web Service from PHP using SOAP   Click here to execute a PHP application that uses the Excel-based Web Service. Or have a look at our source sample that shows how easy it is to call this Web Service from PHP.   Demo 3: Call the Web Service from a .NET Application   Download this .NET application and run it. Make sure .NET 1.1 is installed. You can also download the source code of this sample .NET application.   Demo 4: Run the Excel-Model as Browser Application   Click here to have Worksheet-Server run the Excel demo as a browser based web application.