=av in xce11/10/2022 ![]() ![]() procedure TForm1. This allowed to work on the chart directly. := 'New Chart Title' Īlso note, I don't know the implication of the parameter that's passed to Select.Īnother option that works is to let go of type safety after some point (where it doesn't work anymore) and rely on VBA examples found on MS documentation (which does not match signatures with that of generated type library). Procedure TForm1.Button1Click(Sender: TObject) Note that I have office 14 which doesn't have AddChart2, so I used AddChart. The difference is to select the chart to be able to refer to it through ActiveChart. Vcl.Controls, Vcl.Forms, Vcl.Dialogs, Vcl.StdCtrls, ComObj, Excel_TLB Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics, The Microsoft Object Model documentation for ChartTitle says that this is the correct property.( )Īdditional Info: I did generate my own type library, Excel_TLB, and I have that in my USES clause. I can't even find any way to READ the existing title, let alone change it. I cannot find any way to change my Title. ![]() If Comemnt out above line, this AVs as well RawDataSheet := oExcel.ActiveSheet as _Worksheet Excel makes it easy to review and analyze data, budgets more while you view and edit workbooks attached to email messages. Sheets can easily be checked, edited and shared on the go. The Excel spreadsheet app lets you create, view, edit, and share your files with others quickly and easily. Get the handle to the active Sheet, and insert some dummy data Microsoft Excel: View, Edit, & Create Spreadsheets. Add a New Workbook, with a single sheet OExcel := CreateOleObject('Excel.Application') as ExcelApplication procedure TForm1.Button1Click(Sender: TObject) Here is a working sample that shows the problem. When I google, the closest thing I can find mentions that I need to select the Chart and/or Chart title before I change it. This should be a simple property change, but I keep getting AV errors. It has a default title, so I want to change that. I am using Delphi Seattle to build and display a Chart in Excel (2013). ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |