主题：关于打印出现的问题

 上传例子说明问题，什么情况下的事？

 我测试了一下，正常是没有你说的问题的。

 

 上传具体例子。

1、模板

 

 

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

点击浏览该文件:采购合同.xls

 

2、代码

 

DataTables("采购订单").Save
DataTables("采购单明细表").Save
Dim Book As New XLS.Book(ProjectPath & "Attachments\采购合同.xls")
Dim fl As String = ProjectPath & "Reports\采购合同.xls"
Dim App As New MSExcel.Application
Book.Build() '生成细节区
Book.Save(fl) '保存工作簿
Dim Wb As MSExcel.WorkBook = App.WorkBooks.Open(fl)
Dim Ws As MSExcel.WorkSheet = Wb.WorkSheets(1)
Dim Rg As MSExcel.Range = Ws.Cells
'Rg.EntireRow.AutoFit  '自动调整行高
App.Visible = True

规定，或者你不放 FooterRow

 看楼上代码

DataTables("采购订单").Save
DataTables("采购单明细表").Save
Dim Book As New XLS.Book(ProjectPath & "Attachments\采购合同.xls")
Dim fl As String = ProjectPath & "Reports\采购合同.xls"
Book.Build() '生成细节区
Book.Save(fl) '保存工作簿
Dim App As New MSExcel.Application
try
    Dim Wb As MSExcel.WorkBook = app.WorkBooks.open(fl)
    Dim rg As MSExcel.Range
    Dim Ws = wb.WorkSheets(1)
    Dim tempWs = wb.WorkSheets.Add
    For Each rg In ws.UsedRange
        If rg.MergeCells Then
            rg.WrapText = True
            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 = 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
            End If
        End If
    Next
    'Rg.EntireRow.AutoFit  '自动调整行高
    app.DisplayAlerts = False
    tempWs.Delete
    app.visible = True
catch ex As exception
    msgbox(ex.message)
    app.quit
End try

 

 图片，不会自动变换位置，你放在哪里，最后就在哪里。

 跟你说了啊，图片不能根据内容改变位置啊，你放在哪里，最后就在哪里。

 测试了一下，即便用动态插入图片的方式也很麻烦，建议你这样做

 

 http://www.foxtable.com/help/topics/1845.htm

 

 汗，你写到模板你里面去啊。