This project is read-only.

NPOI generating big files

Aug 18, 2010 at 7:48 PM

Hi all!

I'm having a problem using NPOI to generate Excel files. Before I started to use NPOI, I was using the interop lib and a certain excel was generated with 1.5mb. Now, with NPOI, the same excel has 2.23mb. In that case it is not a problem, but I'm generating some files with 50mb!

What I do is:

FileStream fs = new FileStream(path, FileMode.Open, FileAccess.Read);
				HSSFWorkbook npoiWb = new HSSFWorkbook(fs, true);
				HSSFSheet npoiSheet = npoiWb.GetSheetAt(0);
HSSFRow row = npoiSheet .CreateRow(i);
HSSFCell cell = row.CreateCell((short)j);

Is something wrong?