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
