does anyone know how to access the time object so i can format it with the time
hh:mm:ss
i am doing the date as follows:
DateFormat = createObject("java", "jxl.write.DateFormat");
DateTime = createObject("java", "jxl.write.DateTime");
customDateFormat = DateFormat.init( "dd/mm/yyyy-hh:mm:ss");
dateCellFormat = WritableCellFormat.init(customDateFormat);
cellData = DateTime.init(q2-1,q3,currentData,dateCellFormat);
sheet.addCell(cellData);
but cannot work out to see set it to the time
thanks
> when i say below, there seems to have been 2 threads for this one
> subject... the other is http://www.houseoffusion.
> com/groups/cf-talk/thread.cfm/threadid:56346
>
>
> > hi
> >
> > you showed me the way to add specific cell formats below, but i was
>
> > just wondering whether anyone knew how to set full column formats
> > using this jexcel
> >
> > thanks
> >
> > richard
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305473
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
