Different dates Formats and Decimals

[Balaji Muniraja <ba...@db.com>]

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: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org