Reading Excel Files as a Server Process

by

There were a number of libraries that were highlighted by different users that would allow the sort of functionality required. I’ve listed them here and some of these were evaluated so where appropriate I’ve tried to put down interesting comments for comparing them. The details I’ve included are completely opinion based, however any of these libraries would probably achieve the required goal.

SpreadsheetGear.Net
(Didn’t evaluate due to high purchase cost)

Aspose.Cells
(Evaluated by a collegue. Appeared to be fairly simple to implement, performance comparable to Excel Interop).

GemBox
(Didn’t evaluate)

Excel Services
(Seems only to be included in SharePoint 2007)

Excel Mapper
(Didn’t evaluate because it requires strongly typed objects to import into which didn’t fit my requirement).

SmartXls
(Didn’t evaluate because it requires strongly typed objects to import into which didn’t fit my requirement).

ActiveXls
(Fairly easy to use, lack of Properties raises questions, they have a preference of Methods for trivial actions. Despite it’s claim of 1M records a second was out performed by cheaper FlexCel. Have decided that the help/API manual is almost useless.)

Koogra
(Didn’t evaluate due to finding no documentations/information)

FileHelpers
(Didn’t evaluate)

Flexcel
(Lowest cost solution found, good performance and was simple to implement with a close proximity to Excel Interop structure. Also received quick response to technical question from support. Probably my pick of the bunch.)

SyncFusion BackOffice
(Medium cost and had a reasonable structure. Unfortunately had more difficulty implementing and inconsistent results when running unit tests. Also received a number of ‘Attempted to read protected memory’ errors, which didn’t encourage me with purely managed library.)

More Related Contents:

  1. Elevating process privilege programmatically?
  2. How to export DataTable to Excel
  3. Format excel column to decimal doing export from c#
  4. .NET console application as Windows service
  5. How do I export to Excel?
  6. Excel Interop – Efficiency and performance
  7. How can I verify if a Windows Service is running
  8. How to install a windows service programmatically in C#?
  9. How to read file using NPOI
  10. Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE))
  11. GUI and windows service communication
  12. EPPlus number format
  13. FileSystemWatcher Fails to access network drive
  14. How to read data from excel file using c# [duplicate]
  15. How do I debug Windows services in Visual Studio?
  16. Excel interop: _Worksheet or Worksheet?
  17. Excel error HRESULT: 0x800A03EC while trying to get range with cell’s name
  18. WIX service installer overrides service Installer settings
  19. How to add data table with legend keys to a MS Chart in C#?
  20. open xml reading from excel file
  21. Start a windows service and launch cmd
  22. How can I set up .NET UnhandledException handling in a Windows service?
  23. The designer could not be shown for this file because none of the classes within it can be designed
  24. How do I get an Excel range using row and column numbers in VSTO / C#?
  25. Printing Excel using Interop
  26. How to import all the Excel sheets to DataSet in C#
  27. C#: GUI to display realtime messages from Windows Service
  28. As of today, what is the right way to work with COM objects? [duplicate]
  29. The type initializer for ‘MyClass’ threw an exception
  30. How to create Excel file using OpenXML without creating a local file?

Leave a Comment