0

I tried to create an excel sheet using NPOI. I hit on an exception. After inspecting it and searching internet I came to know that the maximum columns an excel sheet can hold is 16384. Is there anyway to increase this limit. Because the data I have to put is more than this limit.

Note: I am using NPOI,c#,Excel 2010.

prabhakaran
  • 5,126
  • 17
  • 71
  • 107
  • Oh no, don't make that many columns. You need to find another solution. Please share why you need more than 16,384 columns as I'm genuinely curious. – Mikael Nov 26 '20 at 06:35
  • One of the teams in our company gave us a data in binary format and asked us to put it in excel format in format they provided. Now when I wrote the code I hit on this issue. – prabhakaran Nov 26 '20 at 07:29
  • 3
    Current versions of Excel are limited to 16384 columns. You can't change that – chris neilsen Nov 26 '20 at 08:58
  • 1
    Just add another sheet when you reach limit of record in one sheet. – Hassan Monjezi Nov 26 '20 at 10:12

0 Answers0