Duration: 23 minutes
Summary: In this video, this example shows how we can export a collection to an Excel spreadsheet. The collection is made of Employee objects (name, position, and salary). In this example, we are using Windows forms. We create a button on the form that when clicked will export the employees to the Excel spreadsheet. The example shows how we can create an application and a worksheet. We will see how to add the cells, rows, headers, and how to format the data before the display.
Methodology of the development of example: Good coding standard and simplified design.
Technology Used: C# 4.0
Keywords: C#, System, List, EventArgs, Form, object, Excel, Application, WorkSheet, Cells, XlRangeAutoFormat.