Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Go through below link..
http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/
It may helps you.
Karthik
pls check..hope it will help u...
http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/
regards-bika
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.
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
HI Jayson,
Did you get any solution for your problem ??
I have same kind of requirement.
Regards,
Rajni Batra
I am also facing the same issue if any one have the solution please post here
Thanks,
venkat