C#合并多个结构一样的Excel

1. 合并代码如下：
4. usingSystem;
5. usingSystem.Collections.Generic;
6. usingSystem.Text;
7. usingSystem.Reflection;
8. usingExcel=Microsoft.Office.Interop.Excel;
9. namespaceConsoleApplication20
10. {
11. //添加引用-COM-MicroSoftExcel11.0ObjectLibery
12. classProgram
13. {
14. staticvoidMain(string[]args)
15. {
16. //M为表格宽度标志（Excel中的第M列为最后一列），3为表头高度
17. MergeExcel.DoMerge(newstring[]
18. {
19. @"E:/excel/类型A/公司A.xls",
20. @"E:/excel/类型A/公司B.xls"
21. },
22. @"E:/excel/类型A/合并测试.xls","M",3);
23. MergeExcel.DoMerge(newstring[]
24. {
25. @"E:/excel/类型B/统计表A.xls",
26. @"E:/excel/类型B/统计表B.xls"
27. },
28. @"E:/excel/类型B/合并测试.xls","I",4);
29. }
34. }
35. publicclassMergeExcel
36. {
38. Excel.Applicationapp=newMicrosoft.Office.Interop.Excel.ApplicationClass();
39. //保存目标的对象
40. Excel.WorkbookbookDest=null;
41. Excel.WorksheetsheetDest=null;
42. //读取数据的对象
43. Excel.WorkbookbookSource=null;
44. Excel.WorksheetsheetSource=null;
47. string[]_sourceFiles=null;
48. string_destFile=string.Empty;
49. string_columnEnd=string.Empty;
50. int_headerRowCount=1;
51. int_currentRowCount=0;
53. publicMergeExcel(string[]sourceFiles,stringdestFile,stringcolumnEnd,intheaderRowCount)
54. {
56. bookDest=(Excel.WorkbookClass)app.Workbooks.Add(Missing.Value);
57. sheetDest=bookDest.Worksheets.Add(Missing.Value,Missing.Value,Missing.Value,Missing.Value)asExcel.Worksheet;
58. sheetDest.Name="Data";
60. _sourceFiles=sourceFiles;
61. _destFile=destFile;
62. _columnEnd=columnEnd;
63. _headerRowCount=headerRowCount;
65. }
66. ///
67. ///打开工作表
68. ///
69. ///
70. voidOpenBook(stringfileName)
71. {
72. bookSource=app.Workbooks._Open(fileName,Missing.Value,Missing.Value,Missing.Value,Missing.Value
73. ,Missing.Value,Missing.Value,Missing.Value,Missing.Value
74. ,Missing.Value,Missing.Value,Missing.Value,Missing.Value);
75. sheetSource=bookSource.Worksheets[1]asExcel.Worksheet;
76. }
77. ///
78. ///关闭工作表
79. ///
80. voidCloseBook()
81. {
82. bookSource.Close(false,Missing.Value,Missing.Value);
83. }
84. ///
85. ///复制表头
86. ///
87. voidCopyHeader()
88. {
89. Excel.Rangerange=sheetSource.get_Range("A1",_columnEnd+_headerRowCount.ToString());
90. range.Copy(sheetDest.get_Range("A1",Missing.Value));
91. _currentRowCount+=_headerRowCount;
92. }
93. ///
94. ///复制数据
95. ///
96. voidCopyData()
97. {
98. intsheetRowCount=sheetSource.UsedRange.Rows.Count;
99. Excel.Rangerange=sheetSource.get_Range(string.Format("A{0}",_headerRowCount+1),_columnEnd+sheetRowCount.ToString());
100. range.Copy(sheetDest.get_Range(string.Format("A{0}",_currentRowCount+1),Missing.Value));
101. _currentRowCount+=range.Rows.Count;
102. }
103. ///
104. ///保存结果
105. ///
106. voidSave()
107. {
108. bookDest.Saved=true;
109. bookDest.SaveCopyAs(_destFile);
110. }
111. ///
112. ///退出进程
113. ///
114. voidQuit()
115. {
116. app.Quit();
117. }
118. ///
119. ///合并
120. ///
121. voidDoMerge()
122. {
123. boolb=false;
124. foreach(stringstrFilein_sourceFiles)
125. {
126. OpenBook(strFile);
127. if(b==false)
128. {
129. CopyHeader();
130. b=true;
131. }
132. CopyData();
133. CloseBook();
134. }
135. Save();
136. Quit();
137. }
138. ///
139. ///合并表格
140. ///
141. ///源文件
142. ///目标文件
143. ///最后一列标志
144. ///表头行数
145. publicstaticvoidDoMerge(string[]sourceFiles,stringdestFile,stringcolumnEnd,intheaderRowCount)
146. {
147. newMergeExcel(sourceFiles,destFile,columnEnd,headerRowCount).DoMerge();
148. }
149. }
151. }