private DataTable ExcelToTable(string filePath)
{
DataTable dt = null;
if (string.IsNullOrEmpty(filePath))
{
return(dt);
}
if (filePath.ToLower().EndsWith("xls"))
{
dt = NpoiHelper.GetInstance().ImportFromExcel(filePath, "0", 0);
}
else if (filePath.ToLower().EndsWith("xlsx"))
{
dt = NpoiHelper.GetInstance(false).ImportFromExcel(filePath, "0", 0);
}
return(dt);
}
public Form1()
{
InitializeComponent();
list.Add(new TestData {
Name = "zhangshan", Age = 40, Birthday = DateTime.Now
});
list.Add(new TestData {
Name = "lisi", Age = 28, Birthday = DateTime.Now
});
list.Add(new TestData {
Name = "wangwu", Age = 36, Birthday = DateTime.Now
});
list1.Add(new ComplexData {
Name = "zhangshan", Age = 40, Birthday = DateTime.Now, Detail = new Detail {
Tel = "02885394654", HomeAddr = new Address {
CommonAddr = "黄河村", PostNo = "610048"
}
}
});
DataTable dt = new DataTable("TestTable");
dt.Columns.Add("Name");
dt.Columns.Add("Age");
dt.Columns.Add("Birthday");
DataRow dr = dt.NewRow();
dr[0] = "zhangshan";
dr[1] = 50;
dr[2] = DateTime.Now;
dt.Rows.Add(dr);
NpoiHelper.GetInstance().ExportToExcel(dt);
//NpoiHelper.GetInstance().ExportToExcel<TestData>(list);
//NpoiHelper.GetInstance().ExportToExcel<ComplexData>(list1);
//string file = AppDomain.CurrentDomain.BaseDirectory + "excel.xls";
//NpoiHelper.GetInstance().ImportFromExcel(file,"0",0);
}