Problem in MS Excel Support for opening files.

Sandy Adriano
Sandy Adriano used Ask the Experts™
How do you make a compatible referencing for Office libraries to work with Office 2010 and above while using  Visual Basic? I am using MS office object libraries. I also reference MS Excel Object Library. Will that be a problem?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Dirk StraussSenior Full Stack Developer
Distinguished Expert 2017

I have always used EPPlus for any development involving Excel. Refer to this thread export to excel not working c# windows forms application on Experts Exchange. Have a look at the EPPlus Wiki for examples on how to implement it. Also worth reading is the old CodePlex site.

For reference, see How To Create An Excel File (Development) Using EPPlus .NET Library (C#) - Part One

Using EPPlus will ensure that your application continues to work with Excel files, irrespective of where your application is running.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial