How to read a date value from the database into xl,
November 23, 2009 at 5:54 PM
Hi i've developed a utility to read date value from database to xls using jxl.jar its is running fine but the date value is not duisplaying properly in the xls file (when the mouse pouinter is kept on it,the msg shown is as follows "negative date or time is displayed as ######" Date SCANNED_DATE=rset.getDate("SCANNED_DATE"); dateFormat = new WritableCellFormat(DateFormats.FORMAT9); DateTime activation_date_index = new DateTime(9,col_num_pre+1,ACTIVATIONDATE, dateFormat, DateTime.GMT); sheet.addCell(activation_date_index); the above lines are the code where i think some more additions to be done please help me in fixing up this problem