主题：[求助]Excel模板如何设置条形码图片？

空行的问题可以这么解决:

if e.DataRow isnot Nothing AndAlso e.datarow.IsNull("lot") = false then

   Dim Bar As New BarCodeBuilder
   Bar.Symbology = Barpro.Symbology.Code39
   Bar.Code = e.DataRow("Lot")
   Bar.BarRatio = 0.3
    Bar.BarHeight = 8
    bar.SaveImage(ProjectPath & "Images\BarCode.gif",300)

Else

   filesys.DeleteFile(SaveImage(ProjectPath & "Images\BarCode.gif")

end if

这样不会报错了：

If e.Book.TempLate = "SalesInvoice" Then
    If e.region = "SaleOrderDetail" Then
        If e.DataRow Is Nothing OrElse e.DataRow.IsNull("Lot") Then
            Dim img As New System.Drawing.Bitmap(1,1)
            img.Save(ProjectPath & "Images\BarCode.gif")
        Else
            Dim Bar As New BarCodeBuilder
            Bar.Symbology = Barpro.Symbology.Code39
            Bar.Code = e.DataRow("Lot")
            Bar.BarRatio = 0.3
            Bar.BarHeight = 8
            bar.SaveImage(ProjectPath & "Images\BarCode.gif",300)
        End If
    End If
End If

但是空行还是会出现条形码，这个需要等下次更新。