delphiand microsoft office（delphiand微软办公）（27页）.docVIP

Delphi and Microsoft Office:Automating Excel and WordCopyright ? 1997 by Charlie CalvertHere is the examples.zip file. IntroductionSystem RequirementsGetting Started with Delphi and ExcelCreating Excel Automation ObjectsUnderstanding Excel Automation ObjectsFinding the Constants used in ExcelStoring and Accessing Data in an Excel WorksheetWorking with Columns and Range AttributesCreating a ChartCopying Data from Excel to WordAutomation Inside WordMailing a DocumentSummary The goal of this two-part paper is to get you up to speed automating Excel and Word from a Delphi application. Most of the text will focus on Excel, but you will find that if you understand Excel automation, that you need only a few hints to get started automating Word. If you are primarily interested in Word, I ask you to patiently read through the material on Excel, as almost all of it applies to Word. You can use Delphi to fully control virtually all the features of Excel and Word. There is very little that you can do from inside Excel or Word that you cannot also automate from outside Excel or Word. In other words, both Excel and Word can be fully controlled from Delphi applications using OLE Automation. For the most part the act of controlling Excel or Word from a Delphi application is not terribly challenging. Whatever difficulty there is comes not from Delphis side of the equation, but from the innate complexity of the Excel and Word object hierarchies. Not that I find the hierarchies unreasonable, but they do encapsulate sufficient complexity to require a significant period of study. In particular, these automation classes give you rather detailed control over Word and Excel. Since these are complex applications, the interface to them also needs to be complex if it is not to be considered under powered. The purpose of this paper is to unscramble that hierarchy and show its underlying structure. This paper is divided into two parts. The first part shows automating Word and