How can columns be set to 'autosize' in Excel documents created with NPOI?

excel npoi
Yellowfog picture Yellowfog · Jun 30, 2010 · Viewed 24.2k times · Source

NPOI is a .NET port of the Java POI project, which allows one to read and write Microsoft Excel documents (as well as other Office formats). NPOI 1.2.2 has introduced support for 'autosizing' columns, whereby the column is set to the width of the widest cell entry in the column. However, there are many reports that this does not work. So is it possible?

Answer

Yellowfog picture Yellowfog · Jun 30, 2010

I've posted this just to answer it, so as to provide a record. It is possible to make columns autosized using NPOI, but you have to add all the data in columns, rather than in rows. Once all the cells have been added to a column @ columnIndex you then call 

mySheet.AutoSizeColumn(columnIndex)

and move to the next column. I have found no other way to make this functionality work.

Related questions

How to read file using NPOI

I found NPOI is very good to write Excel files with C#. But I want to open, read and modify Excel files in C#. How can I do this?

Read More
Trying to create a new .xlsx file using NPOI and write to it

Edit: I'm trying to write a small console application that will read in lines from an excel spreadsheet, parse the lines and write the fielded data to a new excel file. I'm using .NET and the NPOI library. I finally …

Read More
Does NPOI have support to .xlsx format?

Will NPOI DLL recognize .xlsx file? Currently I'm using NPOI 1.2.5 version DLL for Microsoft Excel 97-2003, but I need to access Excel sheets of extension .xlsx also. Will NPOI support the above? Code snippet: static void Main(string[] args) { XSSFWorkbook …

Read More