Export entire sheet as image

[#1]

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

[Anonymous]

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

[#3]

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

[Anonymous]

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

[#5]

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

[#6]

hi jejetator,

can you share the macro sheet to pdf

[mvaugusto]

it works !

Thanks