Microsoft Office Tutorials and References
In Depth Information
Excel Services SOAP API
Excel Web Services can expose an Excel workbook and its sheets using the SOAP API. You can both read and write
programmatically to the Excel worksheet while other users are editing the workbook, which allows multiuser
collaboration. All you need is a simple reference to the SOAP API.
You can communicate with the Excel file securely either by impersonation or by using credentials while
connecting to data. Let’s see how to connect with TeamTasks.xlsx file using the SOAP API.
prOBLeM CaSe
Connect to the teamtasks excel worksheet that we’ve published to our Sharepoint environment,
programmatically retrieve data, add tasks to the sheet, and then retrieve the updated data.
Solution
We will use the excel Services SOap api to retrieve the title information and the remaining Work (hours) from
teamtasks.xlsx in this example.
1.
Open visual Studio 2012. From the File menu, select New and click on project.
2.
in the New project window, choose Windows from the installed templates section under
visual C#.
3.
Choose .Net Framework 4.5, and select Console application.
4.
enter a proper Name, location, and Solution Name, and click OK. after successful creation of the
project, you’ll see that the program.cs and app.config files are added by default to the project.
5.
right-click on references, and choose add Service reference.
6.
in the address box in the add Service reference window, enter the Url
http://<servername>/_vti_bin/excelservice.asmx and click the Go button.
(See Figure 5-23 .)
 
Search JabSto ::




Custom Search