private void uiBtnExport_Click(object sender, EventArgs e)
{
#region 导出Excel
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
using (SaveFileDialog saveFileDialog = new SaveFileDialog())
{
saveFileDialog.Filter = "Excel files (*.xlsx)|*.xlsx";
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
string path = saveFileDialog.FileName;
using (var package = new ExcelPackage())
{
var sheet = package.Workbook.Worksheets.Add(DateTime.Today.ToString("yyyy-MM-dd"));
sheet.Cells["A1"].LoadFromDataTable(ds.Tables[0], true);
package.SaveAs(path);
}
}
}
#endregion
其中ds.Tables[0]为DataTable数据