Android Question B4A Excel Library add image

mike1967

Active Member
Licensed User
Longtime User
Hello, in order to add image to a sheet i use :

B4X:
AddImage(sheet1, File.OpenInput(File.DirAssets, "addetti.png"), 14,riga,1,1)


Sub AddImage(wb As WritableSheet, bmp As InputStream, col As Double, row As Double, _
   width As Double, height As Double)
    Dim wi As JavaObject
    wi.InitializeNewInstance("jxl.write.WritableImage", Array(col, row, width, height, Bit.InputStreamToBytes(bmp)))
    Dim jo As JavaObject = wb
    jo.RunMethod("addImage", Array(wi))
End Sub

but the image not is added. If i change to :
B4X:
AddImage(sheet1, File.OpenInput(File.DirAssets, "addetti.png"), 14,riga,2,1)
th image is added but i will witdh 1 column,height 1 row. Where i Wrong ? Thanks in advance
 
Top