關(guān)于c#操作Excel表格的代碼，網(wǎng)上一搜一堆，之前在給測繪局寫插件的時候就寫過了。下面的代碼是讓小師弟Z寫的，寫的很不錯，我拿過來直接就可以用了。從中貌似我發(fā)現(xiàn)了我之前存在的一個問題，就是相應(yīng)的資源在使用完之后沒有及時釋放掉，有時就會Excel表格報錯。查了下，少了一句代碼System.Runtime.InteropServices.Marshal.ReleaseComObject(xlapp);
下面的代碼是將DataTable中的數(shù)據(jù)輸出到Excel表格中：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52 |
private void btnExportExcel_Click(object sender, EventArgs e) { SaveFileDialog saveDlg = new SaveFileDialog(); saveDlg.DefaultExt = "xls"; saveDlg.Title = "輸出斷面表格"; saveDlg.Filter = "Excel文件(.xls)|*.xls"; if(saveDlg.ShowDialog()==DialogResult.OK) { try { string strExcelName = saveDlg.FileName; Excel.Application xlapp = default(Excel.Application); Excel.Workbook xlbook = default(Excel.Workbook); Excel.Worksheet xlsheet = default(Excel.Worksheet); xlapp = new Excel.Application(); xlapp.Visible = false; xlapp.DisplayAlerts = false; System.Object missing = Type.Missing; xlbook = xlapp.Workbooks.Add(missing); xlsheet = (Excel.Worksheet)xlbook.Worksheets[1]; for (int m = 0; m < dt.Columns.Count;m++ ) { xlsheet.Cells[1, m + 1] = dt.Columns[m].ColumnName; } for (int i = 0; i < dt.Rows.Count;i++ ) { for (int j = 0; j < dt.Columns.Count;j++ ) { xlsheet.Cells[i + 2, j + 1] = dt.Rows[i][j].ToString(); } } xlbook.SaveCopyAs(strExcelName); xlapp.Workbooks.Close(); xlapp.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(xlapp); xlsheet = null; xlbook = null; xlapp = null; MessageBox.Show("Excel導出成功"); } catch (Exception ex) { MessageBox.Show("保存出錯，原因如下："+ex.Message.ToString()); } } } |
