3

I would like to know your libraries recommendations to read and write Excel applications on ASP .NET website.

I have tried GemBox and NPOI, because they don't required Excel to be installed on the server, but they have some limitations on handling Excel files that are marked to read only.

Any good and stable libraries that you recomend

muek
  • 1,080
  • 2
  • 16
  • 36
  • 1
    "limitations on handling Excel files that are marked to read only" - could you elaborate on this, please? – Will A Sep 23 '10 at 19:29
  • If you try to open Excel file that have any kind of password in your excel, for open or for change, you will not be able to use GemBox. I have tried and receive a message saying: 'file is not a valid OLE2 Compound File ....' – muek Sep 23 '10 at 20:35
  • The recent versions of GemBox.Spreadsheet support any password protection on the XLSX file and workbook or worksheet protection on the XLS file. Also, you can even detect if the file is encrypted with `XlsxLoadOptions.IsEncrypted` static method. – Mario Z May 22 '20 at 10:18

5 Answers5

4

OpenXml and Syncfusion XlsIO

HTH

Prince Ashitaka
  • 8,623
  • 12
  • 48
  • 71
3

SyncFusion is pretty stable. I've never used them in an ASP.NET app, but I've used their controls in WinForms apps, and they are supposed to be safe for ASP.NET.

It's not free, though.

David
  • 72,686
  • 18
  • 132
  • 173
3

Try Aspose Cells.

Best Library I know.

gsharp
  • 27,557
  • 22
  • 88
  • 134
2

As David suggested, may be you could try Syncfusion XlsIO, they seem to have a seperate method to read and process readonly excel files.

http://help.syncfusion.com/ug_83/Reporting/XlsIO/ASP.NET/default.htm?turl=Documents%2Fworkbook.htm

Karthik Mahalingam
  • 1,071
  • 8
  • 10
1

OpenXML SDK for xlsx files http://www.microsoft.com/downloads/details.aspx?FamilyId=C6E744E5-36E9-45F5-8D8C-331DF206E0D0

gandjustas
  • 1,925
  • 14
  • 12
  • Hi, thanks for the tip, but because I need to open encrypted files. OpenXML is not an option – muek Sep 25 '10 at 21:09