主题：Foxtable内容显示及Excel报表导出的内容显示问题

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:工艺书(配料中心).xls

Dim App As New MSExcel.Application
try
    Dim Wb As MSExcel.WorkBook = app.WorkBooks.open("C:\Users\dv rrxaI600 007\Downloads\excel工艺书3.xls")
    Dim Ws = wb.WorkSheets(1)
    Dim rg As MSExcel.Range = ws.UsedRange
    Dim tempWs = wb.WorkSheets.Add
    Rg.WrapText = True
    Rg.EntireRow.AutoFit  '自动调整行高
    msgbox(ws.UsedRange.columns.count)
    For Each rg In ws.UsedRange
        If rg.MergeCells Then
            Dim tempCell As MSExcel.Range
            Dim width As Double = 0
            Dim tempCol
            For Each tempcol In rg.MergeArea.Columns
                width = width + tempcol.ColumnWidth
            Next
            tempWs.Columns(1).WrapText = True
            tempWs.Columns(1).ColumnWidth = iif(width>10, width-10, width)
            tempWs.Columns(1).Font.Size = rg.Font.Size
            tempWs.Cells(1, 1).Value = rg.Value
            tempWs.Cells(1, 1).RowHeight = 0
            tempWs.Cells(1, 1).EntireRow.Activate
            tempWs.Cells(1, 1).EntireRow.AutoFit
            If (rg.RowHeight < tempWs.Cells(1, 1).RowHeight) Then
                Dim tempHeight As Double
                Dim tempCount As Integer
                tempHeight = tempWs.Cells(1, 1).RowHeight
                tempCount = rg.MergeArea.Rows.Count
                For Each addHeightRow As object In rg.MergeArea.Rows
                   
                    If (addHeightRow.RowHeight < tempHeight / tempCount) Then
                        addHeightRow.RowHeight = tempHeight / tempCount
                    End If
                    tempHeight = tempHeight - addHeightRow.RowHeight
                    tempCount = tempCount - 1
                Next
                rg.WrapText = True
            End If
        End If
    Next
    app.DisplayAlerts = False
    tempWs.Delete
    app.visible = True
catch ex As exception
    msgbox(ex.message)
    app.quit
End try

谢谢老师，换行的问题已经解决了；现在就是导出的速度特别的慢；虽然模版里已经有<end>标识符，可为什么还是慢呢？

1、现在弹出的列是多少？255？还是多少？弹出18才是正常的。

2、把tempWs.Cells(1, 1)改成 Dim cell = tempWs.Cells(1, 1)

Dim App As New MSExcel.Application
try
    Dim Wb As MSExcel.WorkBook = app.WorkBooks.open("C:\Users\dv rrxaI600 007\Downloads\excel工艺书3.xls")
    Dim Ws = wb.WorkSheets(1)
    Dim rg As MSExcel.Range = ws.UsedRange
    Dim tempWs = wb.WorkSheets.Add
    Rg.WrapText = True
    Rg.EntireRow.AutoFit  '自动调整行高
    msgbox(ws.UsedRange.columns.count)
    Dim tempCell As MSExcel.Range = tempWs.Cells(1, 1)
    For Each rg In ws.UsedRange
        If rg.MergeCells Then
           
            Dim width As Double = 0
            Dim tempCol
            For Each tempcol In rg.MergeArea.Columns
                width = width + tempcol.ColumnWidth
            Next
            tempWs.Columns(1).WrapText = True
            tempWs.Columns(1).ColumnWidth = iif(width>10, width-10, width)
            tempWs.Columns(1).Font.Size = rg.Font.Size
            tempcell.Value = rg.Value
            tempcell.RowHeight = 0
            tempcell.EntireRow.Activate
            tempcell.EntireRow.AutoFit
            If (rg.RowHeight < tempcell.RowHeight) Then
                Dim tempHeight As Double
                Dim tempCount As Integer
                tempHeight = tempcell.RowHeight
                tempCount = rg.MergeArea.Rows.Count
                For Each addHeightRow As object In rg.MergeArea.Rows
                   
                    If (addHeightRow.RowHeight < tempHeight / tempCount) Then
                        addHeightRow.RowHeight = tempHeight / tempCount
                    End If
                    tempHeight = tempHeight - addHeightRow.RowHeight
                    tempCount = tempCount - 1
                Next
                rg.WrapText = True
            End If
        End If
    Next
    app.DisplayAlerts = False
    tempWs.Delete
    app.visible = True
catch ex As exception
    msgbox(ex.message)
    app.quit
End try

你模板设置有问题。替换为11楼的模板。

如果还是不行，做个具体的例子发上来测试和优化。

我用以下代码分别直接在命令窗口中通过更改路径的方法测试了模版与生成的报表，发现问题如下（附模版+报表）：

模版的列数为20列（含两个标签列），打开模版时间为25秒；

生成的Excel报表列数为255列，打开报表时间为60~80秒；

Dim App As New MSExcel.Application
try
    Dim Wb As MSExcel.WorkBook = app.WorkBooks.open("D:\reports\311-17(办单号)工艺书.xls")
    Dim Ws = wb.WorkSheets(1)
    Dim rg As MSExcel.Range = ws.UsedRange
    Dim tempWs = wb.WorkSheets.Add
    Rg.WrapText = True
    Rg.EntireRow.AutoFit  '自动调整行高
    output.show(ws.usedrange.columns.count)
    Dim tempCell As MSExcel.Range = tempWs.Cells(1, 1)
    For Each rg In ws.UsedRange

        output.show(Date.now)       
        If rg.MergeCells Then
            Dim width As Double = 0
            Dim tempCol
            For Each tempcol In rg.MergeArea.Columns
                width = width + tempcol.ColumnWidth
            Next
            tempWs.Columns(1).WrapText = True
            tempWs.Columns(1).ColumnWidth = iif(width>10, width-10, width)
            tempWs.Columns(1).Font.Size = rg.Font.Size
            tempcell.Value = rg.Value
            tempcell.RowHeight = 0
            tempcell.EntireRow.Activate
            tempcell.EntireRow.AutoFit
            If (rg.RowHeight < tempcell.RowHeight) Then
                Dim tempHeight As Double
                Dim tempCount As Integer
                tempHeight = tempcell.RowHeight
                tempCount = rg.MergeArea.Rows.Count
                For Each addHeightRow As object In rg.MergeArea.Rows
                   
                    If (addHeightRow.RowHeight < tempHeight / tempCount) Then
                        addHeightRow.RowHeight = tempHeight / tempCount
                    End If
                    tempHeight = tempHeight - addHeightRow.RowHeight
                    tempCount = tempCount - 1
                Next
                rg.WrapText = True
            End If
        End If
    Next
    app.DisplayAlerts = False
    tempWs.Delete
    app.visible = True
catch ex As exception
    msgbox(ex.message)
    app.quit
End try

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:工艺书(配料中心).xls

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:311-17(办单号)工艺书.xls

　你重新弄模板吧，无法找到你怎么设置的模板出的问题。

　我直接拷贝模板粘贴生成一个新的sheet测试没问题。

谢谢有点甜老师这样耐心的指导；上传例字实在是不方便；我放弃了；

我决定更改模版，不用合并单元格的了；但是打印的时候有个小问题，就是我在Excel里正常显示是完整的，但是在打印预览或直接打印出来的时候，有部分列最后的几个字为什么自动到下一行了，导至打印出来不完整，有没有什么解决办法？

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:br1706-03176(办单号)工艺书.xls