topic Re: send to excel option for document/user report in QlikView

send entire report to excel

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

Inside a .qvw document, I have created a document report. (Reports --> Edit Reports)

Is there any option to send this report to excel?

Regards,

Anju

Re: send to excel option for document/user report

Thu, 07 Mar 2013 08:34:18 GMT

Is there any way to send the entire report to an excel sheet?

Re: send to excel option for document/user report

Fri, 08 Mar 2013 11:51:29 GMT

Hi All,

This is the code I used.

I got the basic code from this post by Miguel Angel Baeyens

http://community.qlik.com/message/319277#319277.

sub test

'Set the path where the excel will be saved

filePath = "C:\Test.xls"

'Create the Excel spreadsheet

Set excelFile = CreateObject("Excel.Application")

excelFile.Visible = true

'Create the WorkBook

Set curWorkBook = excelFile.WorkBooks.Add

'Create the Sheet

'first chart object

Set curSheet = curWorkBook.WorkSheets(1)

'loop

chartArray = Array("CH06","CH09", "CH10")

usedRows=0

For Each chart In chartArray

Set i = ActiveDocument.GetSheetObject(chart)

chartCaption = i.GetCaption.Name.v

curSheet.Cells(usedRows+1, 1)=chartCaption

i.CopyTableToClipboard true

curSheet.Cells(usedRows+3, 1).Select

curSheet.Paste

usedRows=curSheet.UsedRange.Rows.Count+3 --->function to get the first unused row

'loop end

excelFile.Visible = true

'Save the file and quit excel

curWorkBook.SaveAs filePath

curWorkBook.Close

excelFile.Quit

'Cleanup

Set curWorkBook = nothing

Set excelFile = nothing

end sub

Regards,

Anju

Re: send to excel option for document/user report

Anonymous — Tue, 18 Jun 2013 10:25:47 GMT

Hi,

Thanks for the code.

I am getting following error.

Object required: 'i'

and

Paste method of Worksheet class failed

Can you share me the qvw file itself.

thanks.

Re: send to excel option for document/user report

Tue, 18 Jun 2013 10:53:53 GMT

Hi Saurabh,

Did you paste the entire macro?

Re: send to excel option for document/user report

Anonymous — Tue, 18 Jun 2013 11:30:25 GMT

Yes.

I had to comment '-->function to get the first unused row

I get the error as Copy to Clipboard failed. And "Object required 'i'"

I cannot share the qvw as it has customer data. I will try and see if I can share the qvw.

Re: send to excel option for document/user report

Anonymous — Tue, 18 Jun 2013 11:57:06 GMT

Please find attached the qvw.

Let me know if you can solve the error.

Re: send to excel option for document/user report

Wed, 19 Jun 2013 06:39:59 GMT

the problem is with this line..

chartArray = Array("CH06","CH09", "CH10")

CH06...etc are names of sheet objects...the qvw you shared does not have them.

So,

in your case..the statement should be..

chartArray = Array("CH01","CH02", "TB01").

Hope this helps.

Regards,

Anju

Re: send to excel option for document/user report

Anonymous — Wed, 19 Jun 2013 06:44:06 GMT

Sorry to have not included that in code which I shared.

I had done that correction after which I got the "Copy to Clipboard failed" and above two errors also.

There is no consistency in the error, that is, sometimes I get them and sometimes I dont...

What other parameters can affect Qlikview performance?

Re: send to excel option for document/user report

Wed, 19 Jun 2013 07:33:34 GMT

pls share your file

Re: send to excel option for document/user report

Anonymous — Wed, 19 Jun 2013 08:11:24 GMT

PFA the latest version of qvw.

I have done following changes below:

1. Document properties > Security > Macro override security checkbox ticked.

http://community.qlik.com/thread/67941

2. User Preferences>Export tab allowed export for Charts and Tables.

http://community.qlik.com/message/354207

Now the only error I am getting is "Copy to clipboard Fail"

The Logical solution seems is to add a delay for every chart and also to clear the clipboard after every paste.

I am exploring options to do the same using VbScript.

Let me know if you can help solve this problem.

Thanks a ton for all the help till now.

Regards,

Saurabh Pandit

Re: send to excel option for document/user report

schivet — Wed, 17 Sep 2014 08:56:30 GMT

Hello Saurabh,

Did you find a solution to clear the clipboard?

Thanks

Stéphane

Re: send to excel option for document/user report

Anonymous — Thu, 18 Sep 2014 19:57:38 GMT

Hi Stephane,

I don't remember now as its a old post. I will try and work on the app over weekend and let you know if I can find a solution.

Cheers,

Saurabh

Re: send to excel option for document/user report

schivet — Fri, 19 Sep 2014 13:30:58 GMT

Hi Saurabh,

I have added this comand in the module to empty the clipboard:

It did work for a few days but not we still have the problem again!

"Copy to clipboard Fail"

Hope you find something.

Thanks

Re: send to excel option for document/user report

Anonymous — Mon, 22 Sep 2014 09:41:28 GMT

If it worked after the above code then some external changes might have been done causing the re emergence of the error.

I couldn't figure out a solution though.

Re: send entire report to excel

schivet — Mon, 22 Sep 2014 10:27:17 GMT

ok, thank you!