Jakarta POI Autosize

Posted on 2004-11-17
Last Modified: 2008-03-17
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.
Question by:VosJ
    LVL 35

    Accepted Solution

    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.
    LVL 1

    Author Comment

    It was not the answer I hoped for, but unfortunately it seems to be the correct one. So you earned the points. Thanks.
    LVL 35

    Expert Comment

    Thank you for accepting, glad I was of help :)

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Java Flight Recorder and Java Mission Control together create a complete tool chain to continuously collect low level and detailed runtime information enabling after-the-fact incident analysis. Java Flight Recorder is a profiling and event collectio…
    Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
    Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…
    This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now