read write excel file on server

views:

answers:

+1 Q:

read write excel file on server

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

+1 A:

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

gandjustas 2010-09-23 19:31:13

Hi, thanks for the tip, but because I need to open encrypted files. OpenXML is not an option

muek 2010-09-25 21:09:51

+1 A:

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 Stratton 2010-09-23 19:31:51

+1 A:

OpenXml and Syncfusion XlsIO

HTH

Avatar 2010-09-23 19:33:04

+1 A:

Try Aspose Cells.

Best Library I know.

gsharp 2010-09-23 19:42:38

Passed 1º test. Lets try a harder one

muek 2010-09-23 23:00:21

2º test passed, but it's very expensive

muek 2010-09-25 21:26:22

everything has its price ;-)

gsharp 2010-09-26 06:52:31

Had you tried SmartXLS For .Net?

It is easy to use(support most Excel features) and not expensive.

liya 2010-09-25 09:05:18

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 2010-09-26 17:57:47

ansaurus

tags:

views:

answers:

read write excel file on server

related questions