topic Re: excel export macro - resolution issues? in QlikView

excel export macro - resolution issues?

Fri, 25 May 2012 11:05:21 GMT

Hi everyone,

I have created a macro where i export a number of objects as images to an excel document. This works fine but the image clarity is not what i would like it to be. is there a way to improve the reosolution of these images? i know we can export the underlying data but that is not what is required.

I am using the copybitmaptoclipboard function, is there any other option?

Thanks in advance

Re: excel export macro - resolution issues?

paola_valenti — Tue, 22 Nov 2016 17:01:37 GMT

I have exactly the same problem: if I copy with macro using ".CopyBitmapToClipboard", image is grainy!

Have you ever find any solution?

Re: excel export macro - resolution issues?

m_woolf — Tue, 22 Nov 2016 18:43:35 GMT

https://community.qlik.com/docs/DOC-8966#comment-39627

Re: excel export macro - resolution issues?

Frank_Hartmann — Tue, 22 Nov 2016 21:06:24 GMT

instead of using Shapes.Paste method try using Shapes.PasteSpecial(1)

hope this helps

Re: excel export macro - resolution issues?

paola_valenti — Thu, 24 Nov 2016 12:07:57 GMT

It works wonderfully!!

Could you please explain in few words the difference between Paste and PasteSpecial and the meaning of (1) parameter?

Re: excel export macro - resolution issues?

Frank_Hartmann — Thu, 24 Nov 2016 13:55:03 GMT

.Shapes.PasteSpecial(DataType)

0 - Default

1 - Bitmap

2 - Enhanced Metafile

3 - Metafile Picture

4 - GIF

5 - JPG

6 - PNG

7 - Paste Text

8 - HTML

9 - RTF

10 - OLE Object

11 - Paste Shape

hope this helps!

Re: excel export macro - resolution issues?

paola_valenti — Thu, 24 Nov 2016 14:20:45 GMT

Yes, it helps a lot! Thanks