This project is read-only.

NPOI generating excel with more than 256 columns

Aug 23, 2012 at 1:51 PM


We want to generate more than 256 columns in excel using NPOI. Is there any solution? Is there any licenced version of NPOI, which supports more than 256 columns?




Aug 25, 2012 at 2:26 AM

You must use xlsx instead because it's a limitation in Excel 2003 formats instead of NPOI. Even if NPOI can help you write more than 256 columns into the sheet, Excel will throw error. To generate xlsx,  you can try NPOI 2.0 alpha or EPPlus.

Sep 10, 2012 at 7:07 AM

i am using Excel 2010

i have downloaded and added NPOI 2.0

Please help me to create an excel file with more than 500 columns ( ie .xlsx file)

Sep 23, 2012 at 10:28 AM

Which namespace are you using? XSSF or HSSF? If it's HSSF, that's wrong. You shoud use XSSF instead.