I am trying to get a picture of a selected area of a worksheet I just generated using the XL plugin from MBS. To do that, I am using the GetPicture method but can’t make it work.
I wanted to know if people have already used the GetPicture method of XLSheetMBS in the MBS plugins?
dim book as new XLBookMBS(true) book.SetKey(kLicenseXL_name, kLicenseXL_serial) book.RgbMode = true //Create sheet dim sheetName as string = "table_report" dim sheet as XLSheetMBS = book.AddSheet(sheetName) dim rowTop as integer = 0 dim colLeft as integer = 0 dim rowBottom as integer = 10 dim colRight as integer = 10 dim width as integer = CTYPE(me.getWidth(sheet),Integer) // Methods that retrieves the pixels size of the selected area (Width) dim height as integer = CTYPE(me.getHeight(sheet),Integer) // Methods that retrieves the pixels size of the selected area (Height) dim offSetX as integer = 0 dim offSetY as integer = 0 dim index as integer= 0 dim workbookPictureIndex as integer = sheet.GetPicture(index,rowTop,colLeft,rowBottom,colRight,width,height,offSetX,offSetY) msgbox book.ErrorMessage
Note: I don’t know what to put as index, I tried various integer but it’s not working.
the error message returns “ok” but workbookPictureIndex returns -1.
Do someone already succeeded in taking a screenshot from an excel sheet?