https://www.nuget.org/packages/NPOI/
ติดตั้ง
PM> Install-Package NPOI -Version 2.4.1
Program.cs
using NPOI.HSSF.UserModel; using System; using System.Data; using System.IO; namespace ConsoleApp1 { class Program { static void Main(string[] args) { HSSFWorkbook workbook = new HSSFWorkbook(); var sheet1 = workbook.CreateSheet("Sheet1"); var sheet2 = workbook.CreateSheet("Sheet2"); DataTable dt = new DataTable(); dt.Columns.Add("ชื่อ"); dt.Columns.Add("Email"); DataRow row1 = dt.NewRow(); row1["ชื่อ"] = "Jack"; row1["Email"] = "mr.phaisarn@gmail.com"; dt.Rows.Add(row1); DataRow row2 = dt.NewRow(); row2["ชื่อ"] = "Example"; row2["Email"] = "example@gmail.com"; dt.Rows.Add(row2); string fixedWidthColumn = "0-4000,1-4000,2-6000"; var exporter = new NpoiExport(fixedWidthColumn); exporter.ExportDataTableToWorkbook(dt, "Export_Data"); exporter.ExportDataTableToWorkbook(dt, "Export_Data2"); string localFullPath = AppDomain.CurrentDomain.BaseDirectory; FileStream FileStreamObject = new System.IO.FileStream(localFullPath + @"Export_Excel.xls", FileMode.Create, FileAccess.Write); FileStreamObject.Write(exporter.GetBytes(), 0, exporter.GetBytes().Length); FileStreamObject.Close(); } } }Continue reading