topic Re: Export image to Excel in QlikView

Export image to Excel

Thu, 05 Sep 2013 06:05:41 GMT

I want to export the bar Graph to Excel

I have used the following code

set obj = ActiveDocument.GetSheetObject("Chart ID")

obj.CopyBitmapToClipBoard

XLSheet.Range("A1").Select

XLDoc.Sheets("Sheet1").Paste

but the problem is it stops at "Copy" Command and worse is Macro does not showed any Error.

Re: Export image to Excel

Thu, 05 Sep 2013 06:08:54 GMT

try this hope this helps you

Sub ExportGraph()
Dim vSheet
Set XLApp = CreateObject("Excel.Application")
XLApp.Visible = TRUE
Set XLDoc = XLApp.Workbooks.Add
vSheet = ""
vSheet = "Sheet1"
ActiveDocument.GetSheetObject("CH26").CopyBitmapToClipboard 'Copy the charts
XLDoc.Sheets(vSheet).Range("A" & 1).Select
XLDoc.Sheets(vSheet).Paste

Set XLDoc = Nothing
Set XLApp = Nothing

End Sub

Re: Export image to Excel

Thu, 05 Sep 2013 06:13:51 GMT

It stops "ActiveDocument.GetSheetObject("CH26").CopyBitmapToClipboard " here only

does not showed any error

Re: Export image to Excel

markodonovan — Thu, 05 Sep 2013 08:33:49 GMT

Hi Avadhoot,

Try this macro to export a bitmap to excel:

Sub ExportBitmap()

Set Doc = ActiveDocument

Set obj = Doc.GetSheetObject("CH27")

Set XLApp = CreateObject("Excel.Application")

XLApp.Visible = True

'Create a new excel worksheet

Set XLDoc = XLApp.Workbooks.Add

obj.CopyBitmapToClipboard

XLDoc.Worksheets(1).Paste

End Sub

Thanks

Mark

http://practical-qlik.com

https://twitter.com/PracticalQlik

http://practical-qlikview.tumblr.com

Re: Export image to Excel

Thu, 05 Sep 2013 09:54:43 GMT

No it gives same error...................

Re: Export image to Excel

markodonovan — Thu, 05 Sep 2013 09:58:08 GMT

Hi Avadhoot,

Try pressing Ctrl+Shift+M and change the module security to the same as the screenshot to see if this solves the problem.

Mark

http://practical-qlik.com

https://twitter.com/PracticalQlik

http://practical-qlikview.tumblr.com

Re: Export image to Excel

Thu, 05 Sep 2013 10:02:30 GMT

Nop.... pop up is not viewed

But I updated "Requested module security" and "Current local security" to "System access" and "Allow system access" already....

Re: Export image to Excel

Thu, 05 Sep 2013 10:04:51 GMT

Sorry Mark ..

The pop up was thr

n I tried as u said

but its no use..

Re: Export image to Excel

Thu, 05 Sep 2013 10:17:51 GMT

Did you find in which line error execution failed?

write difference msg box on different lines to find the line of execution failed..

Karthik

Re: Export image to Excel

Thu, 05 Sep 2013 10:25:27 GMT

Vishwa's macro working simply. Make sure you are changed chart ID correctly

Karthik