Visual Studio Tools for Office 2007: VSTO for Excel, Word, and Outlook

20. Server Data Scenarios

Populating a Document with Data on the Server

Consider the following portion of an all-too-common server scenario. An authenticated user, perhaps a salesperson, requests an Excel spreadsheet from a server. The spreadsheet is an expense report, and the server is an ASP, ASP.NET, or SharePoint server. The server code looks up some information about the user from a database, Active Directory, or Web service. For example, perhaps the server has a list of recent corporate credit card activity that it will prepopulate into the expense list. The server starts up Excel but keeps it “invisible” because there is no interactive user on the server. It then uses the Excel object model to insert the data into the appropriate cells, ...