Have an amazing solution built in RAD Studio? Let us know. Looking for discounts? Visit our Special Offers page!
C++DelphiRAD Studio

Automate Excel and Word Directly From Delphi Using Office Component Suite

Microsoft Office Automation is a feature of the MS Office Component Object Model used to expose their objects to development tools that support automation. For example, Microsoft Excel may expose workbooks, worksheets, charts, and cells. A Microsoft Word might expose objects such as an application, a document, or a selection. Those exposed objects allow other application to manipulate data programmatically in Excel or Word without user intervention.

Office Component Suite is a selection of components to automate Microsoft Excel and Microsoft Word directly using Delphi and C++ Builder. Using Office Component Suite, we can read, update and manipulate Excel spreadsheets and Word documents easily. Office Component Suite is developed by WinSoft.

Installation

Office Component Suite installation is provided as an executable file. It contains documentation, a lot of sample projects, and of course the component itself. Download the installer and follow the instructions. Once installation is complete, Office Component Suite will appear as several components in the Palette. Check out the video below for a preview of the installation process.

Usage

Office Component Suite provides all necessary methods to read Excel and Word files, update them, and finally save them. There are hundreds of methods and properties exposed by the components. Thankfully WinSoft provides complete help file and more than 40+ sample projects.

In the following video we demonstrate how easy it is to do one of the most frequently used task in Excel: generate report. Professional reports usually contain charts and formatted cells to look great. This is what Office Component Suite is very good at. We can use it to open a template (that is a pre-made report in our case), and then update all necessary data on it, and then save it as a new report. All done programmatically, and it will keep all the layouts, formulas, charts in the original template. Let’s watch the video

Quick tip: Set ExcelApplication.visible:=false to prevent Excel window from capturing focus and user’s attention.

  • Works with: Delphi, C++Builder
  • Works on: Windows 32-bit, Windows 64-bit
  • Free trial available
  • Source code included in registered version
  • Royalty free distribution in applications
  • 48 sample projects available
  • Requires Microsoft Excel or Microsoft Word

Like what you see? You can get the Office Component Suite and over 100 other fantastic WinSoft components with our Enterprise Component Pack. For a limited time, when you purchase RAD Studio Enterprise or Architect Edition at special Upgrade Pricing, you will also get this package of third-party software worth over $13,000, including the full WinSoft Component Library, at NO EXTRA COST! Step up to RAD Studio 10.4.1 today!


Reduce development time and get to market faster with RAD Studio, Delphi, or C++Builder.
Design. Code. Compile. Deploy.
Start Free Trial   Upgrade Today

   Free Delphi Community Edition   Free C++Builder Community Edition

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

IN THE ARTICLES