public void ImportExcelMethodHandler(Object obj, ImportExcelArgs ev)
{
#region 实现...
ExcelAccess excel = new ExcelAccess();
excel.Open();
excel.MergeCells(1, 1, 1, this._body.Cols); //合并单元格写标题，并设置字体
excel.SetFont(1, 1, 1, this._body.Cols, this._title.Font);
excel.SetCellText(1, 1, 1, this._body.Cols, this._title.Text);
//打印网格及网格线
excel.SetCellText((System.Data.DataTable) this.DataSource, 3, 1, true);
System.Windows.Forms.FileDialog fileDlg = new System.Windows.Forms.SaveFileDialog();
fileDlg.AddExtension = true;
fileDlg.DefaultExt = ".xls";
//fileDlg.InitialDirectory = System.IO.Directory.GetCurrentDirectory();
fileDlg.Title = "保存到Excel文件";
fileDlg.Filter = "Microsoft Office Excel 工作簿(*.xls)|*.xls|模板(*.xlt)|*.xlt";
if (fileDlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
if (excel.SaveAs(fileDlg.FileName, true))
{
System.Windows.Forms.MessageBox.Show("数据成功保存到Excel文件！", "GoldPrinter", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
}
}
fileDlg.Dispose();
excel.Close();
#endregion
}
