topic Re: copy sheet object from one sheet to another in QlikView

copy sheet object from one sheet to another

Wed, 28 Dec 2011 10:35:49 GMT

Hi QV experts,

How do I copy object from one sheet to another sheet using QV API. Please suggest.

Thanks in advance

Re: copy sheet object from one sheet to another

johnw — Wed, 28 Dec 2011 17:46:35 GMT

The attached example is from version 9 - perhaps there is a better way in version 10 or 11. It exports the object to an xml file, then imports to create another chart. I got the basic code from Rob Wunderlich, and then worked from there. The attached example also does more than you asked for, and doesn't put the export/import in the same macro, as I wanted to export once, then import many times. Hopefully the comments are sufficient to figure out what you need and don't need from the example.

copy sheet object from one sheet to another

Thu, 29 Dec 2011 06:30:58 GMT

Hi John,

Thank you for your reply. My requirement is to copy charts(more than 1 type like combo,straight table etc) from sheet1 to sheet2, sheet3 and so on. Export import will help me to do this, but the challenge is "How do I identify(Object id) the equivalent chart from sheet -1 say Straight table chart with Object ID CH01 in sheet2 and sheet3 and so on. I just need to know how do I get hold of object ID 's

Thanks in advance

Re: copy sheet object from one sheet to another

Thu, 29 Dec 2011 12:29:50 GMT

I can't understand ur requirement clearly but as per my understanding am giving one solution. To copy a sheet object from one sheet to another,first select the sheet object which u want to copy then right click on that object and select clone,after selecting clone,detach that object,then drag and drop that object to the sheet which u want to show and in that sheet attach that object. if u right click on the object u ll get the clone,attach and detach option. hope this s ur need.

Warm Regards,

Arun Prasadh.N.

Re: copy sheet object from one sheet to another

johnw — Thu, 29 Dec 2011 17:32:20 GMT

padmasali wrote:
...How do I identify(Object id) the equivalent chart from sheet -1 say Straight table chart with Object ID CH01 in sheet2 and sheet3 and so on. I just need to know how do I get hold of object ID 's...

The example I gave shows one way to identify the newly-added chart ID. It's annoyingly complicated, and there should be a better way, but I couldn't find one in version 9. Maybe there's something easier in version 10 or 11.

Edit: Here's the relevant section of the macro code:

objects = sheet.GetSheetObjects 'get array of objects on sheet before adding new chart

beforeMax = ubound(objects)

dim objectIDBefore(100) 'runs slightly faster if first set up a simple array

for j = 0 to beforeMax

objectIDBefore(j) = objects(j).GetObjectID

sheet.CreateObjectFromXMLPropertiesFile "DynamicChartBase.xml" 'chreate chart from XML file

objects = sheet.GetSheetObjects 'get array of objects now on the sheet

for i = beforeMax + 1 to 0 step -1 'for each object now on the sheet

objectID = objects(i).GetObjectID

for j = 0 to beforeMax 'check all objects that WERE on the sheet

if objectIDBefore(j) = objectID then 'if the object was already on the sheet

j = 9999 'exit the inner loop

end if

if j < 9999 then 'if the object is new

set chart = objects(i) 'get a handle to the object

i = 0 'and exit the outer loop

end if

chartVariable.SetContent objectID,false 'store the new chart's ID

copy sheet object from one sheet to another

rwunderlich — Thu, 29 Dec 2011 19:35:47 GMT

I've always found that the new object is added to the head of the sheet object collection.

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

-Rob

Re: copy sheet object from one sheet to another

johnw — Thu, 29 Dec 2011 19:46:50 GMT

Ah, yes, I remember that now. I'm trying to refresh my memory of our conversations regarding this and why I'm not using it, and found this old thread:

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

John: "set chart = sheetObjects(uBound(sheetObjects))

This appears to always give me the new chart. But does anyone know if I can count on that?"

Rob: "It almost always works for me, but like you I've never seen any doc that promises it will continue to work. The only time I've seen the ubound technique not work is if a doc is saved with a 9+ version, it will not work if used with 8.5."

John: "OK. Since it doesn't seem to be documented, and the functionality here has changed over time, we can't count on the ubound() technique continuing to work in the future. Also, it would be nice to have a template that works for earlier versions of QlikView for people who haven't upgraded. I'll implement a loop to compare before and after to get the right ID, and post when I have that working."

So I guess my conclusion would be use the ubound() technique if you want something simple that will likely work just fine and you're on at least version 9. Loop if you want to be sure it will keep working. Mind you, QlikTech could change functionality for something used in the loop just like they cound change how objects are added, so even the loop isn't a guarantee.

copy sheet object from one sheet to another

rwunderlich — Thu, 29 Dec 2011 20:15:33 GMT

I'll agree that your solution is more robust. Thanks for digging that up.

-Rob

Re: copy sheet object from one sheet to another

Thu, 18 Apr 2013 12:08:32 GMT

padmasali wrote:
Hi QV experts,
How do I copy object from one sheet to another sheet using QV API. Please suggest.
Thanks in advance

I do it like that:

works in v 11

function copyChart () {
       // Get reference on existing Object
       refChart = ActiveDocument.GetSheetObject("MY_CHART");
      // Create Empty Object, doesnt matter which type to create
       newChart = ActiveDocument.GetSheetByID("SH26").CreateBarChart();
       // Get properties of existing Object
      cp = refChart.GetProperties();
      // Set ID of new object, otherwise it will create linked object
      cp.GraphLayout.Frame.ObjectId = newChart.GetObjectId();
      // Set Properties of New Chart
      newChart.SetProperties(cp);
}

Best regards,
Ruslan