Changing OleDb connection

Jan 8, 2014 at 9:08 PM
I need NPOI to do what I would think is a simple task, but I am finding nothing documented on how to do this, Google is failing me. I need NPOI to open an Excel file and change the OleDB connection, that is all. I know I can do this through Interop but from what I hear, I want to stay away from Interop at all cost. Plus I also hear you have to install it on the server, which may be a huge roadblock from my employer.
Jan 9, 2014 at 10:33 PM
I don't understand what you mean. What's the relationship between Excel, NPOI and OleDB? If you read/write Excel via NPOI, there is no need to use OleDB connection. Please clarify.
Jan 9, 2014 at 11:09 PM
I figured out a different way of handling the issue, basically something like what you mentioned.