2020年6月26日
Convert XLSX file to DataTable via NPOI
摘要： static DataTable ReadExcelConvertToDataTable(string xlsxFileName) { DataTable dt = new DataTable(); try { IWorkbook book; using (FileStream fs = new F 阅读全文
posted @ 2020-06-26 19:51 FredGrit 阅读(134) 评论(0) 推荐(0) 编辑
C# NPOI read excel files include xls and xlsx
摘要： 1.Install-package npoi; 2.Add necessary namespace as below. using System.IO;using System.IO.Compression;using NPOI.HSSF.UserModel;using NPOI.SS.UserMo 阅读全文
posted @ 2020-06-26 18:33 FredGrit 阅读(256) 评论(0) 推荐(0) 编辑
C# write stream to local file
摘要： Write the current to the local file. static void CopyStream(Stream stream, string destPath) { using (var fileStream = new FileStream(destPath, FileMod 阅读全文
posted @ 2020-06-26 18:14 FredGrit 阅读(180) 评论(0) 推荐(0) 编辑