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為表格寬度標(biāo)志(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\統(tǒng)計表A.xls",
@"E:\excel\類型B\統(tǒng)計表B.xls"
},
@"E:\excel\類型B\合并測試.xls", "I", 4);
}
}
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為表格寬度標(biāo)志(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\統(tǒng)計表A.xls",
@"E:\excel\類型B\統(tǒng)計表B.xls"
},
@"E:\excel\類型B\合并測試.xls", "I", 4);
}
}