Office XML

Office XML

Delphi library for processing Excel .xlsx documents.
  • create or modify Excel Workbook .xlsx files
  • Microsoft Office installation is not required
  • uses Microsoft Open XML SDK and ClosedXML libraries
  • Microsoft .NET Framework 4.5 or higher required
  • available for Delphi 7 - 10.4
  • royalty free distribution in applications

Download and order

Order Office XML library $80 USD (license for one developer)
Order Office XML multi-license $240 USD (license for all developers in company)
Order Office XML year upgrades $40 USD (registered users only)
Order Office XML year upgrades multi-license $120 USD (registered multi-license users only)


How can I solve "Project Demo.exe raised exception class $C0000090 with message 'floating point invalid operation at 0x07a2376a'." error message?
Switch off floating point exceptions using this code:
Set8087CW(Get8087CW or $3F);
How can I open existing .xlsx file?
Use XLWorkbookClass class:
  WorkbookClass: XLWorkbookClass;
  Workbook: XLWorkbook;
  WorkbookClass := CoXLWorkbookClass.Create;
  Workbook := WorkbookInstance.Create_5('example.xlsx');
How can I set workbook properties?
Workbook.Properties.Title := 'Title';
Workbook.Properties.Subject := 'Subject';
How can I set worksheet protection?
  Worksheet: IXLWorksheet;
  Protection: IXLSheetProtection;
  Protection := Worksheet.Protect_3('password');
  Protection.SelectLockedCells := False;
  Protection.SelectUnlockedCells := False;
How can I solve "Class not registered." error message?
  • Create manifest file yourapplicationname.exe.manifest (change yourapplicationname accordingly to the name of your application):
  • <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestVersion="1.0">
      <assemblyIdentity version="" processorArchitecture="*" name="yourapplicationname" type="win32"/>
          <assemblyIdentity type="win32" name="Microsoft.Windows.Common-Controls" version=""
            publicKeyToken="6595b64144ccf1df" language="*" processorArchitecture="*"/>
          <assemblyIdentity name="Winsoft.OfficeXML" version="" publicKeyToken="c2371442b2cedf55" processorArchitecture="msil"/>
  • Embed yourapplicationname.exe.manifest file to your application: Select Delphi menu Project/Options.../Application. Change Manifest File combobox to Custom and select yourapplicationname.exe.manifest file in Custom manifest edit box.
  • Instead of embedding yourapplicationname.exe.manifest file to your application, you can comment "{$R *.res}" line in yourapplicationname.dpr file and use external yourapplicationname.exe.manifest file:
  • // {$R *.res}

Related links