private void MenuItem_Click(object sender, RoutedEventArgs e)
{
System.Data.DataTable datatable = new System.Data.DataTable();
Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
try
{
//lz 路徑選擇
excelApp.Visible = false;
Workbook excelWB = excelApp.Workbooks.Add(System.Type.Missing);
Worksheet excelWS = (Worksheet)excelWB.Worksheets[1];
Range celulas = null;
celulas = excelWS.get_Range("A1", System.Type.Missing);
excelWS.Cells[1, 1] = "";
excelWS.Cells[1, 2] = "控制柜名稱";
excelWS.Cells[1, 3] = "控制柜分類";
excelWS.Cells[1, 4] = "時間";
excelWS.Cells[1, 6] = "工作模式";
excelWS.Cells[1, 8] = "報警狀態";
excelWS.Cells[1, 10] = "輸入電壓";
excelWS.Cells[1, 11] = "輸出電壓";
excelWS.Cells[1, 12] = "輸出電流";
excelWS.Cells[1, 13] = "一路";
excelWS.Cells[1, 14] = "二路";
for (int i = 0; i < dsResult.Tables[0].Rows.Count; i++)
{
for (int j = 0; j < dsResult.Tables[0].Columns.Count; j++)
{
celulas.get_Offset(i + 1, j).Cells.Value2 = dsResult.Tables[0].Rows[i][j].ToString();
}
}
excelApp.ActiveWorkbook.RefreshAll();
excelApp.Workbooks.Application.ActiveWorkbook.RefreshAll();
SaveFileDialog a = new SaveFileDialog();
a.Filter = "Excel 工作簿 (*.xls)|*.xls";
a.ShowDialog();
excelWB.SaveAs(a.FileName, XlSaveAction.xlSaveChanges, false, false, XlSaveAsAccessMode.xlNoChange);
excelWB.Close(false, null, null);
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show("導出失敗:" + ex.Message);
}
excelApp.Quit();
System.Windows.Forms.MessageBox.Show("導出成功!");
btnExcel.DataContext = "";
HistoryWorkingDataGrid.DataContext = null;
}
導出的Excel文件為什么有密碼呢?
- 1 回答
- 0 關注
- 750 瀏覽
添加回答
舉報
0/150
提交
取消