读书人

导出到Excel遇到的有关问题

发布时间: 2011-12-30 23:30:45 作者: rapoo

导出到Excel遇到的问题
怎么合并单元格阿
Dim range As Range = DirectCast(worksheet.Cells._Default(row, col), Range)
range.Select()
range.Value2 = Value.ToString
range.Style = StyleName
range.Columns.EntireColumn.AutoFit()
range.Borders.Weight = DirectCast(2, XlBorderWeight)
range.Borders.LineStyle = DirectCast(1, XlLineStyle)
range.Borders.ColorIndex = DirectCast(-4105, XlColorIndex)

[解决办法]
range.Merge(Type.Missing);

读书人网 >C#

热点推荐