Hello,
You can extract the values from excel sheet. Then based on the column type apply
formating to the value viz converting dates to dd-mm-yyyy etc. The formatting can be
done using the java.text api. After applying necessary formatting these values can
then be inserted into the database.
-Rahul Phadnis
--- ORIGINAL MESSAGE ---
From:[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject:Different dates Formats and Decimals
Date: 04/14/2004 08:37:53 AM
Hi ,
I am newbie to POI.
I have a requirement, where i need to read each row in the Excel File and upload
those rows in to the Oracle Database. I am using the following code to do that. But
before reading the Excel file using the Java Programs, i need to 1) Format the Date
Columns to (CUSTOM-> dd-mm-yyyy) , number colums to Number and no decimal places and
there are cases where columns in the Excel will be empty (it will be in General
Format). If i convert it to Text and run the program then it will work properly.
What i wanted to know is , Is there any way
1) To read without modifying the format for the Date values in the Excel Sheet.
2) If the Excel Column is of General Type and try to read a String Value
successfully.
Many thanks in Advance.
Regards,
Balaji.M,
Institutional Client Group(IT),
Deutsche Bank [/], London,
Office : +44(0)20754 55426
--
This e-mail may contain confidential and/or privileged information. If you are not the
intended recipient (or have received this e-mail in error) please notify the sender
immediately and destroy this e-mail. Any unauthorized copying, disclosure or
distribution of the material in this e-mail is strictly forbidden.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
All the kung fu in the world isn't any help when it comes to women. - Jet Li
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
