read write excel file on server

I开发者_Python百科 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

OpenXml and Syncfusion XlsIO

HTH

Try Aspose Cells.

Best Library I know.

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.

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

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