Skip to main content

Add Excel graph to DS form

  • July 11, 2012
  • 1 reply
  • 0 views

How can you add an Excel graph to a DS form to be able to change the values and for the graph to be updated automatically

I think there is an option with OLE2 controls but I am not sure how to update the values.

Another option would be to use ACTIVEX (I think)

Thank You

1 reply

Chris Glazier
Forum|alt.badge.img+2
  • Moderator
  • 3697 replies
  • July 11, 2012

How can you add an Excel graph to a DS form to be able to change the values and for the graph to be updated automatically

I think there is an option with OLE2 controls but I am not sure how to update the values.

Another option would be to use ACTIVEX (I think)

Thank You

Take a look at the Dialog System Example for OLE in the folder: C:\\Program Files (x86)\\Micro Focus\\Net Express 5.1\\Examples\\Dialog System\\DSOLE.

If you run this demo and press the delete object button and then insert object you can choose the program that you want to link.to.

If you  use Create from file and check the Link option you can select an Excel spreadsheet to open and then any changes to it will be reflected in the Dialog System screen.

In the Dialog System documentation look under Dialog System Extensions-->DSOLE.