Users must have the ability to download a copy of the information in your application's table(s) in an Excel workbook to work with outside of your application. For example, prospective buyers of a life insurance policy may download a workbook in the popular desktop spreadsheet application, Microsoft Excel 97 (or a later version). The workbook could be a spreadsheet containing "What If?" scenarios illustrating for their age, gender, and class rating what their expected returns would be based on variables such as asset allocations and market growth assumptions. This helps them to independently evaluate the suitability of a particular life insurance product for their goals in the comfort of their own home.
Use the WebGrid control with the WebGrid Excel Exporter component on your Web page. Add a means of triggering a download request of the Microsoft Excel workbook (.xls) file (e.g., a Button click event handler). Call the Export method on the WebGrid Excel Exporter component to generate an .xls file from the contents bound in the WebGrid control at that time.
The Infragistics.Excel library that accompanies WebGrid Excel Exporter provides an object model around the contents of the Microsoft Excel workbook, which allows you to manipulate select contents of the workbook users download.