Solved

Jakarta POI - HSSF (used to created/edit MS Excel files)

Posted on 2006-06-22
3
829 Views
Last Modified: 2012-06-22
I've been using the HSSF java API ( http://jakarta.apache.org/poi/hssf/index.html ) to create/edit MS Excel files and need some help doing a couple things.  I've looked through their documentation but have been unable to find how to do a couple things:

1. Setting the format of cells (such as currency, number w/ decimal placess, etc...)

2. Adjusting the column width (both using the auto-fit feature of excel and also specifying a value of the width).

Any help is appreciated.

Thanks
0
Comment
Question by:mgcIT
  • 2
3 Comments
 
LVL 14

Accepted Solution

by:
hoomanv earned 500 total points
Comment Utility
0
 
LVL 18

Author Comment

by:mgcIT
Comment Utility
I saw that and have been using it, but could not find examples of the specific items listed above..

thanks
0
 
LVL 18

Author Comment

by:mgcIT
Comment Utility
ok nevermind... I looked again at that file and found what I was looking for... Thanks
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
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 one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

762 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

5 Experts available now in Live!

Get 1:1 Help Now