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();
}
}
