Infragistics自带导出控件UltraGridExcelExporter,用此控件可以轻松的将UltraWinGrid中的数据导出到excel文件中,而且格式可以自定。
/// <summary>
/// 导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnExp_Click(object sender, EventArgs e)
{
if (this.grdCKTZ == null || this.grdCKTZ.Rows.Count == 0)
{
this.label2.Text = "请先查询后导出";
return;
}
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "Execl files (*.xls)|*.xls";
saveFileDialog.FilterIndex = 0;
saveFileDialog.RestoreDirectory = true;
saveFileDialog.FileName = "能耗查询表";