VWD 2008 Express. Visual basic.
I am now creating Excel workbooks in my VB code behind thanks to a suggestion that I use NPOI (http://npoi.codeplex.com/). I have downloaded version 1.2.2 for Net 2.0 from this site, as it claims that the "AutoSizeColumn" function is fixed in this version. However, it does not work at all for me. The following is the code I use:
'Format the columns
For I = 0 To NCol - 1
xlWorkSheet.AutoSizeColumn(I)
Next
The result is the same as when I do not use AutoSizeColumn at all, namely squished columns. Anyone familiar with this product and why this feature may not be working when it is advertised to work? Thanks for the help.
...
Go to the complete details ...