Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Export of charts to Excel

Hello!

tell me how you can export the graph as a picture, but with a transparent background. I borrowed the code, where there is a part:

if (not objSource is nothing) then

if (pasteMode = "image") then

Call objSource.CopyBitmapToClipboard()

else

Call objSource.CopyTableToClipboard(true) '// default & fallback

end if

Set objCurrentSheet = objExcelDoc.Sheets(sheetName)

objExcelDoc.Sheets(sheetName).Range(sheetRange).Select

objExcelDoc.Sheets(sheetName).PasteSpecial DataType=wdPasteBitmap

and in the excel it is loaded so:

Безымянный12.png

and I need it without a white background:

Безымянный321.png

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

Re: Export of charts to Excel

I don't think that is possible because a picture will always have a defined background - each pixel has an assigned color. As a workaround you could export the data to excel and creating with them the graph there.

- Marcus