订阅本文为【C#合并多个结构一样的Excel】的汉字拼音对照版显示拼音
合he并bing代dai码ma如ru下xia：using System;
using System.Collections.Generic;
using System.Text;
using System.Reflection;
using Excel = Microsoft.Office.Interop.Excel;
namespace ConsoleApplication20
{
//添tian加jia引yin用yong-COM-MicroSoft Excel 11.0 Object Libery
class Program
{
static void Main(string[] args)
{
//M为wei表biao格ge宽kuan度du标biao志zhi（Excel中zhong的de第diM列lie为wei最zui后hou一yi列lie），3为wei表biao头tou高gao度du
MergeExcel.DoMerge(new string[]
{
@"E:\excel\类lei型xingA\公gong司siA.xls",
@"E:\excel\类lei型xingA\公gong司siB.xls"
},
@"E:\excel\类lei型xingA\合he并bing测ce试shi.xls", "M", 3);
MergeExcel.DoMerge(new string[]
{
@"E:\excel\类lei型xingB\统tong计ji表biaoA.xls",
@"E:\excel\类lei型xingB\统tong计ji表biaoB.xls"
},
@"E:\excel\类lei型xingB\合he并bing测ce试shi.xls", "I", 4);
}
}
public class MergeExcel
{
Excel.Application app = new Microsoft.Office.Interop.Excel.ApplicationClass();
//保bao存cun目mu标biao的de对dui象xiang
Excel.Workbook bookDest = null;
Excel.Worksheet sheetDest = null;
//读du取qu数shu据ju的de对dui象xiang
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>
/// 打da开kai工gong作zuo表biao
/// </summary>
/// <param name="fileName"></param>
void OpenBook(string fileName)
{
bookSource = app.Workbooks._Open(fileName, Missing.Value, Missing.Value, Missing.Value, Missing.Value
, Missing.Value, Missing.Value, Missing.Value, Missing.Value
, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
sheetSource = bookSource.Worksheets[1] as Excel.Worksheet;
}
/// <summary>
/// 关guan闭bi工gong作zuo表biao
/// </summary>
void CloseBook()
{
bookSource.Close(false, Missing.Value, Missing.Value);
}
/// <summary>
/// 复fu制zhi表biao头tou
/// </summary>
void CopyHeader()
{
Excel.Range range = sheetSource.get_Range("A1", _columnEnd + _headerRowCount.ToString());
range.Copy(sheetDest.get_Range("A1",Missing.Value));
_currentRowCount += _headerRowCount;
}
/// <summary>
/// 复fu制zhi数shu据ju
/// </summary>
void CopyData()
{
int sheetRowCount = sheetSource.UsedRange.Rows.Count;
Excel.Range range = sheetSource.get_Range(string.Format("A{0}", _headerRowCount + 1), _columnEnd + sheetRowCount.ToString());
range.Copy(sheetDest.get_Range(string.Format("A{0}", _currentRowCount + 1), Missing.Value));
_currentRowCount += range.Rows.Count;
}
/// <summary>
/// 保bao存cun结jie果guo
/// </summary>
void Save()
{
bookDest.Saved = true;
bookDest.SaveCopyAs(_destFile);
}
/// <summary>
/// 退tui出chu进jin程cheng
/// </summary>
void Quit()
{
app.Quit();
}
/// <summary>
/// 合he并bing
/// </summary>
void DoMerge()
{
bool b = false;
foreach (string strFile in _sourceFiles)
{
OpenBook(strFile);
if (b == false)
{
CopyHeader();
b = true;
}
CopyData();
CloseBook();
}
Save();
Quit();
}
/// <summary>
/// 合he并bing表biao格ge
/// </summary>
/// <param name="sourceFiles">源yuan文wen件jian</param>
/// <param name="destFile">目mu标biao文wen件jian</param>
/// <param name="columnEnd">最zui后hou一yi列lie标biao志zhi</param>
/// <param name="headerRowCount">表biao头tou行xing数shu</param>
public static void DoMerge(string[] sourceFiles, string destFile, string columnEnd, int headerRowCount)
{
new MergeExcel(sourceFiles, destFile, columnEnd, headerRowCount).DoMerge();
}
}
}【原文】
