Is it possible to draw graphs in an Excel file from PowerBuilder? I create tables with data in Excel from PowerBuilder, but how can I build charts or pies based on this data? I saw that classes ExcelPieChart, ExcelBarChart, enum eChartType in C# are used for this purpose, is it possible to use them or something similar in PowerBuilder?
Thank you.
- Mikhael Botvinik
- PowerBuilder
- Tuesday, 31 October 2023 16:40 PM UTC
- Page :
- 1
There are no replies made for this question yet.
However, you are not allowed to reply to this question.
However, you are not allowed to reply to this question.
I'm already using OLE:
oleobject ole_sheet
oleobject ole_excel
ole_excel.ConnectToNewObject('excel.application')
ole_excel.Application.WorkBooks.Open(ls_full_path)
ole_sheet = ole_excel.application.workbooks(1).worksheets(1)
ole_sheet.Activate
etc.
But how can I access the ExcelPieChart and ExcelBarChart classes? Or is there some other way to draw graphs? Maybe there is an example somewhere?
Thank you.
https://learn.microsoft.com/en-us/office/vba/api/excel.chart.oleobjects