c#中合并中合并excel表格的方法示例表格的方法示例
有多个结构一样的Excel，带复杂表头需要合并为一个，且去掉多余的表头数据，可以用COM组件来读取每个Excel表格的Range来合并
到一个新的表格中。样例如图
有很多相同格式的表格，合并代码如下：
using System;
using System.Collections.Generic;
using System.Text;
using System.Reflection;
using Excel = Microsoft.Office.Interop.Excel;
namespace ConsoleApplication20
{
//添加引用-COM-MicroSoft Excel 11.0 Object Libery
class Program
{
static void Main( string [] args)
{
//M为表格宽度标志（Excel中的第M列为最后一列），3为表头高度
MergeExcel.DoMerge( new string [] {
@ "E:/excel/类型A/公司A.xls" ,
@ "E:/excel/类型A/公司B.xls"
},
@ "E:/excel/类型A/合并测试.xls" , "M" , 3);
MergeExcel.DoMerge( new string [] {
@ "E:/excel/类型B/统计表A.xls" ,
@ "E:/excel/类型B/统计表B.xls"
},
@ "E:/excel/类型B/合并测试.xls" , "I" , 4);
}
}
public class MergeExcel
{
Excel.Application app = new Microsoft.Office.Interop.Excel.ApplicationClass();
//保存目标的对象
Excel.Workbook bookDest = null ;
Excel.Worksheet sheetDest = null ;
//读取数据的对象
Excel.Workbook bookSource = null ;
Excel.Worksheet sheetSource = null ;
string [] _sourceFiles = null ;
string _destFile = string .Empty;
string _columnEnd = string .Empty;
int _headerRowCount = 1;
int _currentRowCount = 0;
public MergeExcel( string [] sourceFiles, string destFile, string columnEnd, int headerRowCount)
{
bookDest = (Excel.WorkbookClass)app.Workbooks.Add(Missing.Value);
sheetDest = bookDest.Worksheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value) as Excel.Worksheet;
sheetDest.Name = "Data" ;
_sourceFiles = sourceFiles;
_destFile = destFile;
_columnEnd = columnEnd;
_headerRowCount = headerRowCount;
}
/// <summary>
/// 打开工作表
/// </summary>
/// <param name="fileName"></param>
void OpenBook( string fileName)
{
评论0