//url:文件保存路径
// dt:数据源DataTable
private void GetDataDownLoad(string url, DataTable dt)
{
Workbook wk = new Workbook();
wk.Worksheets.Clear();
Worksheet sheet = wk.Worksheets.Add("Sheet页名称");
Cells cell = sheet.Cells;
//设置某列(A1举例)为时间格式
Style st = cell["A1"].GetStyle();
st.Custom = "yyyy-MM-dd";
cell["A1"].SetStyle(st);
cell.ImportDataTable(dt, true, 0, 0);
try
{
wk.Save(url);
MessageBox.Show("导出成功!", "提示");
return;
}
catch (Exception)
{
MessageBox.Show("导出失败!", "提示");
return;
}
}