Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2969
  • Last Modified:

Jakarta POI Autosize

I've created an Excel-sheet with the Jakarta POI API. I now want to autosize my columns, but I can't find a function in the API that can autosize my columns. The only thing I found is setColumnWidth. Can anybody point me out to an autosize-function in the POI-API.

Thank you.
0
VosJ
Asked:
VosJ
  • 2
1 Solution
 
girionisCommented:
AFAIK you cannot do it. The reason behind this is the lack of good font metrics. You will have to find the length of the data manualyl and set the size of the column. Check the POI mailing list, the subject has been discussed in the apst several times.
0
 
VosJAuthor Commented:
It was not the answer I hoped for, but unfortunately it seems to be the correct one. So you earned the points. Thanks.
0
 
girionisCommented:
Thank you for accepting, glad I was of help :)
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now