Read Custom format of Excel

anujgupta872003 anujgupta872003 is offline

Junior Member

Join Date: Jan 2012

Posts: 1

01-05-2012

I want to read custom date format from excel through JAVA:
Issue:

In my excel cell is of custom format MMYYYY. Which is 011900.
When i click on it It shows me 1/0/1900. I am using jxl.jar for reading excel.

When i am reading it through java it is not taking date as 0. So it is gicing me value 121899. Dont Know why??? Could you please help me. Its very critical to my project.

Thanks in adance.

Thread Tools
Show Printable Version Email this Page

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
bug while converting excel format to csv format	laritta	Software	1	08-16-2011 01:00 PM
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007	=?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=	ASP .Net	15	10-24-2007 01:34 PM
read a excel sheet using aspose.excel	sajithkahawatta	ASP .Net	3	04-19-2007 02:54 PM
Read data from special format Excel with ASP	Vanessa	ASP General	2	11-10-2005 05:27 PM
Excel _WorkBook vs. Excel.Workbook	=?Utf-8?B?SmltIEhlYXZleQ==?=	ASP .Net	1	09-29-2004 03:48 PM