Hello, everyone! Hope you guys are doing well. Today, In this article, I will explain, How to create an Excel file from the object of the list in C#. So let’s start it. For this, I have installed the latest version of the ArrayToExcel NuGet package.
Code
using ArrayToExcel; using System.Collections.Generic; namespace ListToExcel { class Program { static void Main(string[] args) { List<Student> students = new List<Student>() { new Student(){ Id = 1, Name="Chand"}, new Student(){ Id = 2, Name="Nishant"}, new Student(){ Id = 3, Name="Shailja"}, new Student(){ Id = 4, Name="Umang"}, new Student(){ Id = 5, Name="Prince"}, new Student(){ Id = 6, Name="Krishna"} }; byte[] ExcelData = students.ToExcel(); string Filename = @"D:\List_To_PDF.xls"; System.IO.File.WriteAllBytes(Filename, ExcelData); } public class Student { public int Id { get; set; } public string Name { get; set; } } } }