此主题相关图片如下：控制图片高度，宽度超出excle报表单元格.jpg

[&图片1, 39,12,-1,290]控制图片高度，宽度超出excle报表单元格

[&图片1, 39,12,290,-1] 控制图片宽度，高度超出excle报表单元格

怎么解决图片在单元格中饱满不能太小，又不跑出单元格外面？

此主题相关图片如下：控制图片宽度，高度超出excle报表单元格.jpg

根据单元格的宽高设置图片的宽高，参考

Dim App As New MSExcel.Application
Dim Wb As MSExcel.WorkBook = App.WorkBooks.Open("d:\\test.xls")
Dim Ws As MSExcel.WorkSheet = Wb.WorkSheets(1)
Dim Rng As MSExcel.Range
Dim Pic As MSExcel.shape

For Each Pic In ws.shapes
    On Error Resume Next
   
    rng = pic.TopLeftCell
    With Pic
        If .Height / .Width > rng.Height / rng.Width Then
            .Height = rng.Height - 5
            .Top = rng.Top + 2.5
            .Left = rng.Left + (rng.Width - .Width) / 2
            .Placement = 1
        Else
            .Width = rng.Width - 5
            .Left = rng.Left + 2.5
            .Top = rng.Top + (rng.Height - .Height) / 2
            .Placement = 1
        End If
    End With
Next
App.Visible = True

老师，这个代码添加在哪个事件里呢？

我用的是excle模板作报表按钮下面的代码：

Dim Book As New XLS.Book(ProjectPath & "Attachments\\会签版现况一致.xlsx")
Dim fl As String = ProjectPath & "Reports\\会签版现况一致.xlsx"

Dim Sheet As XLS.Sheet = Book.Sheets(0)
\'Sheet(3,9).Value = "<列值 = # " & Date.Today & "#>"  \'写入打印条件
\'Sheet(46,10).Value = "<列值 = \'0\'>"  \'写入打印条件
Sheet(8,10).Value = "<列值 = \'0\'>"  \'写入打印条件

Book.Build() \'生成报表
Book.Save(fl)
Dim Proc As New Process
Proc.File = fl
Proc.Start()

Dim Book As New XLS.Book(ProjectPath & "Attachments\\会签版现况一致.xlsx")
Dim fl As String = ProjectPath & "Reports\\会签版现况一致.xlsx"

Dim Sheet As XLS.Sheet = Book.Sheets(0)
\'Sheet(3,9).Value = "<列值 = # " & Date.Today & "#>"  \'写入打印条件
\'Sheet(46,10).Value = "<列值 = \'0\'>"  \'写入打印条件
Sheet(8,10).Value = "<列值 = \'0\'>"  \'写入打印条件

Book.Build() \'生成报表
Book.Save(fl)

Dim App As New MSExcel.Application
Dim Wb As MSExcel.WorkBook = App.WorkBooks.Open(fl)
Dim Ws As MSExcel.WorkSheet = Wb.WorkSheets(1)
Dim Rng As MSExcel.Range
Dim Pic As MSExcel.shape

For Each Pic In ws.shapes
    On Error Resume Next
   
    rng = pic.TopLeftCell
    With Pic
        If .Height / .Width > rng.Height / rng.Width Then
            .Height = rng.Height - 5
            .Top = rng.Top + 2.5
            .Left = rng.Left + (rng.Width - .Width) / 2
            .Placement = 1
        Else
            .Width = rng.Width - 5
            .Left = rng.Left + 2.5
            .Top = rng.Top + (rng.Height - .Height) / 2
            .Placement = 1
        End If
    End With
Next
App.Visible = True

上面代码没效果的，图片还是跑出单元格（多行单元格合并的单元格）外面。

[&图片1, 39,12,-1,290]

[&图片1, 39,12,290,-1]

单元格里，上面的代码是否要调整？

不，可，能。上传实例测试。

图片跑出单元格，项目，老师请下载帮忙看看

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

点击浏览该文件:图片跑出单元格.rar