Search Wiki:
Resource Page Description
This download provides the complete project files and source code for the hands-on guide "Generating Sales Invoices in Excel" in the VSTO documentation for Visual Studio 2008 SP1.

Note: The hands-on guide that accompanies the samples files has not been published yet. The guide is expected to be published by October, 2008.

This sample provides an implementation of a specific business scenario involving Excel. In this scenario, an employee of the fictitious Northwind company uses an Excel template to create copies of sales invoices for customers that have placed orders with the company.

The employee clicks a button on the Ribbon in Excel to generate a new sales order invoice based on an Excel template. The employee then uses data-bound controls on a custom task pane to choose the customer and the order number. The employee clicks a button on the custom task pane that populates cells in the sales order invoice.

This sample illustrates the following tasks:

• Integrating data with an Excel spreadsheet.
• Adding a custom task pane that contains data bound controls.
• Adding custom buttons to the Ribbon of an Excel application.
• Using a button on the Ribbon to show and hide a custom task pane.
• Using the Excel object model to populate cells in Excel.

This sample requires Excel 2007 and Visual Studio 2008.

Last edited Sep 16 2008 at 2:36 AM  by normesta, version 2
samanani wrote  May 23 2009 at 8:04 PM  
Please add the Contoso_SalesInvoice.xltx template or indicate where to locate it. Thanks.

Page view tracker