CODEWITHSUNDEEP
c#asp.netexcel
Pinchas K
Pinchas K

Reputation: 1571

Processing an excel sheet with password

I have a web app which lets the user select the excel spreadsheet and does some processing against tables on sql server, adds new col. to sheet. in C#. sorry my bad, not using Interop but using DevExpress to process. they have a feature to process excel sheets. but it's not working on the password protected ones/ I am getting now excels with password protected how can i have the c# be told to ignore password?

Upvotes: 2

Views: 1099

Answers (1)

Bryan Crosby
Bryan Crosby

Reputation: 6554

As Jetti has said, you should not use Office interop in a server environment. There are many reason for that and they are listed by Microsoft here. Instead, try something like OOXML (free) or Aspose (commercial).

Upvotes: 1

Related Questions