Upgrading NPOI. Need Help.

Aug 1, 2014 at 2:05 AM
Windows Server 2008 R2. IIS 7. Visual Studio 2012.

I am using a older version of NPOI. But I am not sure what version or how to tell. However, my current (old) version has there files in my Bin folder:

NPOI.DDF.dll
NPOI.dll
NPOI.HPSF.dll
NPOI.HSSF.dll
NPOI.POIFS.dll
NPOI.Util.dll

Version 2.0 has the files:

ICSharpCode.SharpZipLib.dll
NPOI.dll
NPOI.OOXML.dll
NPOI.OOXML.XML
NPOI.OpenXml4Net.dll
NPOI.OpenXml4Net.XML
NPOI.OpenXmlFormats.dll
NPOI.XML

Do I just replace the old files with these?

Second question. In my VBA code I have:

'Libraries needed for the NPOI Excel worksheet creation
Imports NPOI.HSSF.UserModel
Imports NPOI.HSSF.UserModel.HSSFCellStyle
Imports NPOI.HPSF
Imports NPOI.HSSF.Util
Imports NPOI.POIFS.FileSystem

What do I replace these with using the new version of NPOI?

Is there anything else I need to do to utilize the new version and to remove the old version from my web site?

Thanks for the help.
Coordinator
Aug 4, 2014 at 6:41 AM
After replacement with the new version, you have to change some code because interfaces are changed.