Click sheet object value in QlikView with C#

Mon, 26 Jan 2026 16:26:21 GMT

Hello,

I'm writing an export mechanism for QlikView which allows to export objects from QlikView to PowerPoint and to generated an update everytime according to the object in QlikView. ( company wants it for PowerPoint )

This is all done in C#.

But, the issue is, that in QlikView, I always write in all my documents ( min 50 docs, means 50 copy paste code ... and adapt ) in Editor Module following code:

Set pptApp = CreateObject("powerpoint.application")

clearAll

Set ProductValues = ActiveDocument.Fields("Product").GetPossibleValues

For i = 0 To ProductValues.Count - 1

clearAll

Call selectField("Product", ProductValues.Item(i).Text)

Set ReleaseValues = ActiveDocument.Fields("Release").GetPossibleValues

For j = 0 To ReleaseValues.Count - 1

clearAll

Call selectField("Product", ProductValues.Item(i).Text)

Call selectField("Release", ReleaseValues.Item(j).Text)

Set PriceValues = ActiveDocument.Fields("Price").GetPossibleValues

For k = 0 To PriceValues.Count - 1

And do any kind of manipulation with the columns/rows of my table in QlikView. But how can I access the same thing with C#?

Because I can check which type is my chart/table with

qlikviewitem.ItemType

I was thinking about returning the SheetObject and do something like:

for(int i=0;i<=qlikviewitem.SheetObject.DbGetTableData().rowcount;i++)

{

for(int i=0;i<=qlikviewitem.SheetObject.DbGetTableData().columncount;i++)

{

//reset all clicks in order to do next click event

//click this [i,j] position

}

Exporting the object works fine(Table/Chart/etc)

item.SheetObject.CopyTableToClipboard(true)

Copy it and paste it later in my Word/Excel/PowerPoint with C#

Clipboard.SetText(item);

ppApp.ActiveWindow.View.PasteSpecial();

But as mentioned, I want to simulate the click event on each columns/rows, to copy always the new chart which is in relation with the currently selection in my table.

I don't find anything in the OCX documentation about this, only the modification for text, but not the click event.

I hope, I could give enough details about my issue.

Thanks.

Mike

topic Click sheet object value in QlikView with C# in QlikView

Click sheet object value in QlikView with C#