In this article, I have provided a examples to export datatable to excel in c# in ASP.NET web-application using data from SQL server database and have used OpenXML/ClosedXML & InterOp.
In this article, I have provided sample code to convert comma separated string into list using C# or convert string array into list in C# console application.