Why I am here? : I have developed a small application to format the Excel files in a specific format in order to import them into another third party application. The formatting tasks includes Adding rows &
columns, rearranging the cols, removing un-necessary
words, changing the data formats, checking the duplicate row etc. I am using Microsoft.Office.Interop.Excel objects in C# to do these tasks. Everything is running fine. However, when this program runs, the user cannot work or open another Excel
workbook or Excel application. Whenever user try to open or work on another Excel file, this application is throwing an exception error. The core reason of the problem is Excel.Application object is not capable to handle
multiple instances. If the program start work on this object it expects 'exclusive access' to this object. This becoming a major issue and need to find a good solution
I have posted few questions on MSDN to get some solution, but many of them pointed NPOI
1. I am using Visual Studio 2010. Does NPOI current version supports .Net 4?
2. Most of our users having Office 2007; Does NPOI supports office 2007 and or .XLSX format files?
3. Can NPOI handle multiple instances of the Excel?
Please help me to find the answers for these question before I start to spend time on NPOI
Thanks a lot