GemBox Software - .NET Components for Reading/Writing Excel files and Compound Document files  
Search gemboxsoftware.com:    
    
 
 
 
 
  FAQ
  Bugs & Features
  Articles


Excel Automation/Interop Issues (C#, VB.NET)


Excel Automation is an option when creating/reading Excel files (XLS, CSV, XLSX) from C# or VB.NET application, but it has many drawbacks.

Issues when using Excel automation (or Excel interop) from .NET are:

Requires a license for Microsoft Excel on every client machine.
Requires that all client machines have the same version of Microsoft Excel installed.
When using automation, Excel is loaded in the background, taking few MB and loading a large number of files and DLLs.
Microsoft Excel was designed as UI application and because of that API is very slow. Generating a single worksheet with 200 rows and 100 columns takes 239.4 seconds on our test machine.
Microsoft doesn't recommend using Excel automation (or any Office interop) on the server: http://support.microsoft.com/kb/257757


We are proud that our Excel .NET component is one of the best alternatives for Excel automation (Excel interop).

GemBox.Spreadsheet Free comes free of charge while GemBox.Spreadsheet Professional is a commercial version (licensed per developer). Find more information about supported features.


















© GemBox Software. All rights reserved.