0 Replies Latest reply: Apr 10, 2013 9:28 AM by Micael Leal RSS

    Click sheet object value in QlikView with C#

      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