Export to Excel - Course C# 4.0 – Lesson 11 | .net courses

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.