I am having problems in manipulating excel files in vs2005.
All I want is to get the excel files(this excel has specific design for reporting and has macros in it), read it, add data for reporting purpose, and make that file send to the client.
Now, the problems I encountered and will encounter is:
1. It has password protect, I dont know how to unprotect it. I already use sheet.Unprotect("password here") but no use.
2. Actually I cant read this using Microsoft.Interop method.
3. Call every sheets I want to be updated.
4. Update the cells with data from database(getting database data is easy of course)
5. Optional, protect it again.
6. Send it to client(downloading)
That's all I need.
Many thanks for the help.
View Complete Post