private void btnExport_Click(object sender, EventArgs e)
{
saveFileDia.Title = @"请选择文件的保存位置";
saveFileDia.Filter = "Excel 97-2003 工作簿|*.xls";//Excel 工作簿|*.xlsx|
saveFileDia.FileName = @"雷达电源数据";
try
{
if (saveFileDia.ShowDialog() == DialogResult.OK)
{
Export2Excel.ExportToExcel(_powerDataDics, _sheetNameList, saveFileDia.FileName);
MessageBox.Show($@"保存Excel文件{saveFileDia.FileName}成功！", @"提示", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
catch (Exception exception)
{
CommonLogHelper.GetInstance("LogError").Error(@"数据查询窗口导出数据到Excel过程出错", exception);
MessageBox.Show(@"保存Excel文件过程出错，" + exception.Message, @"错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnExport_Click(object sender, EventArgs e)
{
saveFileDia.Title = @"请选择文件的保存位置";
saveFileDia.Filter = "Excel 97-2003 工作簿|*.xls";//Excel 工作簿|*.xlsx|
try
{
string sheetName = StationId;
string columnName = DataEnum2Titles.ToTitles(DataName);
saveFileDia.FileName = $@"{StationId}雷达{columnName}电源数据";
if (saveFileDia.ShowDialog() == DialogResult.OK)
{
Export2Excel.ExportToExcel(_powerData, columnName, sheetName, saveFileDia.FileName);
MessageBox.Show($@"保存Excel文件{saveFileDia.FileName}成功！", @"提示", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
catch (Exception exception)
{
CommonLogHelper.GetInstance("LogError").Error(@"实时数据查询窗口导出数据Excel过程出错", exception);
MessageBox.Show(@"保存Excel文件过程出错，" + exception.Message, @"错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
