i just manged to find it out:
DateFormat = createObject("java", "jxl.write.DateFormat");
DateTime = createObject("java", "jxl.write.DateTime");
customDateFormat = DateFormat.init( "hh:mm:ss");
dateCellFormat = WritableCellFormat.init(customDateFormat);
cellData = DateTime.init(q2-1,q3,currentData,dateCellFormat,true); // true
gets it to process it as a time
sheet.addCell(cellData);
> 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:305488
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
