Multiple objects to single excel sheet

[#1]

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 

next

set oXL=Nothing

end sub

*/

Any comments are very much welcome, thanks!

[#2]

Go through below link..

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

It may helps you.

Karthik

[#3]

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

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

regards-bika

[#4]

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.

[#5]

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

[rajni_batra]

HI Jayson,

Did you get any solution for your problem ??

I have same kind of requirement.

Regards,

Rajni Batra

[venkatbza]

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

Thanks,

venkat