topic Re: Multiple objects to single excel sheet in QlikView

Multiple objects to single excel sheet

Wed, 31 Jul 2013 03:15:32 GMT

Hi,

Please help on this, i want to export multiple table box like this :

and i want to export it unto excel file in a "single sheet" like this :

Currrently i'm able to pass this multiple tables into multiple sheets like this:

With these macros :

sub launchXL

set oXL=CreateObject("Excel.Application")

oXL.visible=True

oXL.Workbooks.Add

aSheetObj=Array("tblPeople","tblResponsiveness")

for i=0 to UBound(aSheetObj)

oXL.Sheets.Add

Set oSH = oXL.ActiveSheet

oSH.Range("A1").Select

Set obj = ActiveDocument.GetSheetObject(aSheetObj(i))

obj.CopyTableToClipboard True

oSH.Paste

sCaption=obj.GetCaption.Name.v

set obj=Nothing

oSH.Rows("1:1").Select

oXL.Selection.Font.Bold = True

oSH.Cells.Select

oXL.Selection.Columns.AutoFit

oSH.Range("A1").Select

oSH.Name=left(sCaption,30)

set oSH=Nothing

set oXL=Nothing

end sub

Any comments are very much welcome, thanks!

Re: Multiple objects to single excel sheet

Wed, 31 Jul 2013 04:56:26 GMT

Go through below link..

http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/

It may helps you.

Karthik

Re: Multiple objects to single excel sheet

Wed, 31 Jul 2013 06:04:49 GMT

pls check..hope it will help u...

http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/

regards-bika

Re: Multiple objects to single excel sheet

Thu, 01 Aug 2013 03:04:57 GMT

Hi,

Thanks for your reply/s

Seems the example above only get the objects counterpart ,, the chart of the table.

Thus the object has only 1 id which is objSales i think., However in my part i want to extract 2 objects of different id, tblPeople and tblResponsiveness,, both of table box property.

Re: Multiple objects to single excel sheet

Thu, 01 Aug 2013 04:06:04 GMT

Hi,

I didn't understand your requirement clearly.

But one thing is sure, that blogs example have different object id.

1. objSalesPerRegion

2. objSalesPerRegion2

3. objSalesPerYearAndRegion

4. objTopCustomers

So as i understand, both are same requirement..

Karthik

Re: Multiple objects to single excel sheet

rajni_batra — Thu, 15 May 2014 11:06:31 GMT

HI Jayson,

Did you get any solution for your problem ??

I have same kind of requirement.

Regards,

Rajni Batra

Re: Multiple objects to single excel sheet

venkatbza — Wed, 30 Sep 2015 08:06:40 GMT

I am also facing the same issue if any one have the solution please post here

Thanks,

venkat