Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview API - ActiveSheet.ExportBitmapToFile

Hi everybody,

I have created a vba .net program that handle qlikview through API.

This program export each objet of qlikview file to bmp file.

Everything work fine on my PC (under XP), but when i have put it in a windows 2008 server 64bit, my image exported have a grey background

(in mu xp it was white).

I don't understand why the same program and the same version of qlikview don't make the same result.

______________________________________________

sheetObjects = QvDoc.ActiveSheet.GetSheetObjects()
nbObjects = UBound(sheetObjects)
Console.WriteLine(ControlChars.Tab + "Number of object " + nbObjects.ToString)
For indexObject = LBound(sheetObjects) To UBound(sheetObjects)
QvDoc.GetApplication.WaitForIdle() REM I see this in some post but non change in my case
Threading.Thread.Sleep(3000) REM I see this in some post but non change in my case

objectName = (sheetObjects(indexObject).GetObjectId().ToString().Split(""))(1)
Console.WriteLine(ControlChars.Tab + ControlChars.Tab + objectName)
sheetObjects(indexObject).ExportBitmapToFile(pathToImage + objectName + ".bmp")
ConvertBMP(pathToImage + objectName + ".bmp", ImageFormat.Jpeg)
Next indexObject

______________________________________________

Help !

2 Replies
Not applicable
Author

The grey background appear only when i put transparency on my graph.

Do you know why ?

Not applicable
Author

Hello, I am experiencing a similar problem with Windows 2008 and Office automation (Excel): thread http://community.qlik.com/forums/t/38562.aspx

Any help would be great!