Saving the Qlikview Document in Excel

[#1]

Hi,

I am new to qlikview, I am currently learning with the trail version.

My report contains a single sheet. I am not able to save all the charts and tables in a single excel sheet. But able to save those individually, by selecting the XL icon from each of the object.

I wanted to know if we could same all these charts and tables in one single excel sheet, like the way we do in Business Objects tool.

Request you to let me know the same.

Regards,

Vinay

[IAMDV]

Hi Vinay,

Welcome to QV Community.

I doubt if we have an option like that... however you can write VB script to get this task done. I am sure there are some good examples of the VB Script Code. QV follows the below naming convention, while exporting the data to Excel.

TB03_20110426_102808

TB03 is the object id, 20110426 is YYYYMMDD followed by time stamp.

I hope this helps!

Good luck.

[#3]

see this

http://community.qlik.com/media/p/168157.aspx

[#4]

Thanks Muncho. For the link. I shall download the sample and find out how to go about.

[neetu_singh]

Hi,

You can use this macro for sending multiple object into single sheet of excel.

sub xport2xl()
iRow = 1
set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True

set xlWB = xlApp.Workbooks.Add
set xlSheet = xlWB.Worksheets(1)
set obj = ActiveDocument.getsheetobject(ChartName)

xlSheet.Activate
xlSheet.Cells.Clear

set txt = ActiveDocument.GetSheetObject("CH01")
txt.CopytableToClipboard TRUE
xlSheet.Cells(iRow,1).Select
xlSheet.Paste

while not (isempty(xlSheet.Cells(iRow,1)))
iRow = iRow+2
wend

set txt1 = ActiveDocument.GetSheetObject("CH02")
txt1.CopytableToClipboard TRUE
xlSheet.Cells(iRow,1).Select
xlSheet.Paste

end sub

Regards

Neetu Singh