随笔分类 - NPOI
摘要:public class NPOIHelper { public static MemoryStream Export(DataTable dtSource, string strHeaderText, string strFileName) { string fileExt = Path.GetE
阅读全文
摘要:var ext = Path.GetExtension(filename).ToLower(); using (FileStream fs = File.OpenRead(filename)) { IWorkbook wk; if (ext.Contains("xl...
阅读全文
摘要:/// <summary> /// NPOI帮助类 /// </summary> public class NPOIHelper { public static MemoryStream Export(DataTable dtSource, string strHeaderText, string
阅读全文
摘要:/// /// Excel转换DataTable /// /// 文件的绝对路径 /// DataTable public static DataTable ExcelInput(string FilePath) { //第一行一般为标题行。 Da...
阅读全文