最近用ｄｅｖｅｘｐｒｅｓｓ做ｅｘｃｅｌ　ｅｘｐｏｒｔ，发现ｄｅｖｅｘｐｒｅｓｓ对ｃｅｌｌ　ｍｅｒｇｅ的ｃａｓｅ支持不是很好，没办法，只要调用ｅｘｃｅｌ　ａｐｉ自己去做ｍｅｒｇｅ了。ｄｅｖｅｘｐｒｅｓｓ的ｍｅｇｅ就是对某列按顺序对相同的值进行ｍｅｒｇｅ。写了一个方法，对导出的ｅｘｃｅｌ进行ｍｅｒｇｅ，如下：

 1 

private 

void mergeCell2(

string fileName, 

int rowNumber, List<

int> columnIndex)

 2         {

 3             Microsoft.Office.Interop.Excel.Application _excelApp = 

new Microsoft.Office.Interop.Excel.Application();

 4 

 5             

try

 6             {

 7                 _excelApp.DisplayAlerts = 

false;

 8                 _excelApp.ScreenUpdating = 

true;

 9 

10 

11                 Workbook workBook = _excelApp.Workbooks.Open(fileName,

12                     XlUpdateLinks.xlUpdateLinksAlways, Type.Missing, Type.Missing, Type.Missing,

13                     Type.Missing, Type.Missing, Type.Missing, Type.Missing,

14                     Type.Missing, Type.Missing, Type.Missing, Type.Missing,

15                     Type.Missing, Type.Missing);

16 

17                 Worksheet sheet1 = workBook.Worksheets[

1] 

as Worksheet;

18 

19                 

for (

int loopClmIndx = 

0; loopClmIndx < columnIndex.Count; loopClmIndx++)

20                 {

21                     

char columnName = Convert.ToChar(Convert.ToInt32(

'

A

') + columnIndex[loopClmIndx]);

22 

23                     Range c1 = sheet1.get_Range(

string.Format(

"

{0}{1}

", columnName, 

2),

24                         

string.Format(

"

{0}{1}

", columnName, rowNumber + 

1));

25 

26                     

object[,] vv = c1.Cells.Value2 

as 

object[,];

27                     

if (vv != 

null)

28                     {

29                         

int mergeStartIndx = -

1;

30 

31                         

for (

int rowIndx = 

1; rowIndx <= vv.Length;rowIndx++)

32                         {

33                             mergeStartIndx = rowIndx;

34                             

object tempValue = vv[rowIndx, 

1];

35                             

string strTempValue = tempValue == 

null ? 

string.Empty : tempValue.ToString();

36 

37                             

while (rowIndx < vv.Length)

38                             {

39                                 

object tempNextValue = vv[rowIndx + 

1, 

1];

40                                 

string strTempNextValue = tempNextValue == 

null ? 

string.Empty : tempNextValue.ToString();

41 

42                                 

if (strTempNextValue.Equals(strTempValue))

43                                 {

44                                     rowIndx++;

45                                 }

46                                 

else

47                                 {

48                                     

break;

49                                 }

50                             }

51 

52                             

if (mergeStartIndx != rowIndx)

53                             {

54                                 Range rg = sheet1.get_Range(

string.Format(

"

{0}{1}

", columnName, mergeStartIndx+

1),

55                                      

string.Format(

"

{0}{1}

", columnName, rowIndx+

1));

56 

57                                 

if (rg != 

null)

58                                 {

59                                     rg.Merge(

false);

60                                 }

61 

62                                 Marshal.ReleaseComObject(rg);

63                             }

64                         }                       

65                     }

66                 }

67 

68                 workBook.Save();

69                 workBook.Close(

true, Type.Missing, Type.Missing);

70 

71                 Marshal.ReleaseComObject(sheet1);

72                 Marshal.ReleaseComObject(workBook);

73             }

74             

finally

75             {

76                 

if (_excelApp != 

null)

77                 {

78                     _excelApp.Quit();

79                     _excelApp = 

null;

80                     GC.SuppressFinalize(

this);

81                 }

82             }

83         }

 注意，如果ｅｘｃｅｌ的ｃｅｌｌ没有值，没有值的相邻的格子也必须合并。