Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Export entire sheet as image

Hello all

I already read subjects on how ot export objects or sheet to images but I still have an issue.

I have build a very High sheet that I would like to overall export to images (even what is belo my scroll bar).

Trying to execute  ActiveDocument.ActiveSheet.ExportBitmapToFile ExportPath & "MyFile.png" will ONLY export me the current view of the sheet.

Does anyone of you have any idea doing this.

I see that the Print Sheet is doing it pretty well. SO I'm wondering if we (you) can find a solution.

thanks in advance.

Jerome

Tags (2)
6 Replies
chandashok
Contributor III

Export entire sheet as image

Hi jejetator

     i tried out your problem, Hope we can not export the full page image in qlikview using the ExportBitMapToFIle.

using below macro i tried out to reduce the sheet zoom level and fit the all object within one sheet and export it.

But default the qlikview which take the constant zoom for the exportbitmaptofile function.

sub export

ActiveDocument.ActiveSheet.FitZoomToWindow

ActiveDocument.GetApplication.WaitforIdle

ActiveDocument.ActiveSheet.ExportBitmapToFile "C:\sample.jpg"

End sub

other solution ,

Using the macro you first sent the exported sheet into FitZoomToWindow level and using copy the sheet into clipboard and paste anyone file and save it .

Regards

Ashok

Not applicable

Export entire sheet as image

Hi

1st one was really good idea, but not working . unfortunate.

I don't really understand your 2nd one and How to implement

Can you light me?

regards

chandashok
Contributor III

Re: Export entire sheet as image

Hi

     Here i attached the qv files which describes you the issue in qlikview to export the full sheet.

     Here i use the zooming option and used the ActiveDocument.ActiveSheet.CopyBitmapToClipboard script

     but its also not working

     Refer the attached qv file

Not applicable

Re: Export entire sheet as image

Thanks

So, no solution as of now.

I manage to do something using the Print Sheet to PDF but really hard to automize.

Talk to you next week for new fresh ideas

Not applicable

Re: Export entire sheet as image

hi jejetator,

can you share the macro sheet to pdf

mvaugusto
Contributor

Re: Export entire sheet as image

it works !

Thanks

Community Browser