如何将数据导出到Excel并中合并单元格

2005-04-19 09:05:26 327 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

EasyPoi-导出动态表头-自动新增序号-数据合并单元格需求背景：动态导出表头，特定表头下数据记录一样的需要合并单元格。在导出的首列加上导出序号。解决方案：使用EasyPoi 的map 方式来实现。直接贴代码。 EasyPoi文档地址：风铃开源文档-旧版 public static void main(String[] args) { try { List<ExcelExportEntity> colList = new ArrayList<ExcelExportEntity>() 阅读详情

这是我现在的代码，如何讲部门那一列内容一样的单元格合并？

Dim uExcel As Excel.Application
Dim uExcelBook As Excel.Workbook
Dim intI As Integer
Dim intFgRow As Integer
If fgEmployee.Rows > 1 Then
Set uExcel = New Excel.Application
uExcel.Visible = False
uExcel.SheetsInNewWorkbook = 1

Set uExcelBook = uExcel.Workbooks.Add
With uExcel.Rows(1).Font
.Name = "宋体"
.Size = 9
.ColorIndex = 3
End With
uExcel.ActiveSheet.Rows.HorizontalAlignment = xlVAlignCenter
uExcel.ActiveSheet.Rows.VerticalAlignment = xlVAlignCenter

uExcel.Columns(1).ColumnWidth = 9
uExcel.ActiveSheet.Cells(1, 1).Value = "序号"

For intFgRow = 1 To intColsCount
uExcel.Columns(intFgRow + 1).ColumnWidth = 11
uExcel.ActiveSheet.Cells(1, intFgRow + 1).Value = "部门"
Next

uExcel.Columns(intColsCount + 2).ColumnWidth = 40
uExcel.ActiveSheet.Cells(1, intColsCount + 2).Value = "员工"

uExcel.Columns(intColsCount + 3).ColumnWidth = 40
uExcel.ActiveSheet.Cells(1, intColsCount + 3).Value = "合计"

End If
For intI = 1 To fgEmployee.Rows - 1
With uExcel.Rows(intI + 1).Font
.Name = "宋体"
.Size = 9
.ColorIndex = 1
End With
For intFgRow = 1 To fgEmployee.Cols - 1
uExcel.ActiveSheet.Cells(intI + 1, intFgRow).Value = Trim(fgEmployee.TextMatrix(intI, intFgRow))
Next
Next
uExcelBook.SaveAs (strFileName)
uExcel.Quit
uExcel.DisplayAlerts = True
Set uExcel = Nothing
Set uExcelBook = Nothing

...全文