public void ToDataTableTest() { DataTable dt = new WorkbookDataAdapter(new HSSFWorkbook(new FileStream(@"C:\npoitest.xls",FileMode.Open,FileAccess.Read))) .AddOnRowAdapt(c => { bool result = true; return result; }).ToDataTable(); Console.WriteLine(DataTableUtil.ToString(dt)); }
public void ToDataTableTest() { DataTable dt = new WorkbookDataAdapter(new HSSFWorkbook(new FileStream(@"C:\npoitest.xls", FileMode.Open, FileAccess.Read))) .AddOnRowAdapt(c => { bool result = true; return(result); }).ToDataTable(); Console.WriteLine(DataTableUtil.ToString(dt)); }
public void ToListTest() { IList<SysProduct> products = new WorkbookDataAdapter(new HSSFWorkbook(new FileStream(@"C:\npoitest.xls", FileMode.Open, FileAccess.Read))) .SetColumnNameMapping(ExcelColumnAttribute.GetColumnNameMapping(typeof(SysProduct))) .AddOnRowAdapt(c => { bool result = true; var record = (SysProduct)c.DataRow; return result; }).ToList<SysProduct>(); foreach (var item in products) { Console.WriteLine(item.ProductCode+"|"+item.ProductName); } }
public void ToListTest() { IList <SysProduct> products = new WorkbookDataAdapter(new HSSFWorkbook(new FileStream(@"C:\npoitest.xls", FileMode.Open, FileAccess.Read))) .SetColumnNameMapping(ExcelColumnAttribute.GetColumnNameMapping(typeof(SysProduct))) .AddOnRowAdapt(c => { bool result = true; var record = (SysProduct)c.DataRow; return(result); }).ToList <SysProduct>(); foreach (var item in products) { Console.WriteLine(item.ProductCode + "|" + item.ProductName); } }
public void Test() { string filePath = @"C:\Users\zwb\Desktop\cartype.xlsx"; using (var fs = new FileStream(filePath, FileMode.Open)) { var dt = new WorkbookDataAdapter(new XSSFWorkbook(fs)) //.SetColumnNameMapping(dic) .AddOnRowAdapt(c => { return(true); }).ToDataTable(); DbAccessor dba = DbAccessor.Get(); foreach (DataRow dr in dt.Rows) { foreach (DataColumn dc in dt.Columns) { //if (dc.ColumnName.ToUpper() == "STATUS" || dc.ColumnName.ToUpper()== "BELONGTTYPE") //{ // dr[dc.ColumnName] = Int16.Parse(dr[dc.ColumnName].ToString()); //} if (string.IsNullOrEmpty(dr[dc.ColumnName].ToString())) { dr[dc.ColumnName] = DBNull.Value; } } } dt.TableName = "Biz_Cartype"; dba.BulkWriteToServer(dt); Console.WriteLine(); } }