> therefore how would you translate this formatting stated above
<cfscript>
outFile = createObject("java", "java.io.File").init( "e:\temp\excel\test.xls"
);
workBook=createObject("java","jxl.Workbook").createWorkbook(outFile);
labelObj=createObject("java","jxl.write.Label");
numberObj=createObject("java","jxl.write.Number");
////////////////////////////////////////////////
sheet = workBook.createSheet("First Sheet", 0);
thisLabel=labelObj.init(0,0,"happy happy gizmo");
sheet.addCell(thisLabel);
thisNumber=numberObj.init(0, 1, 3.1459);
sheet.addCell(thisNumber);
////////////////////////////////////////////////
NumberFormats = createObject("java", "jxl.write.NumberFormats");
WritableCellFormat = createObject("java", "jxl.write.WritableCellFormat");
Number = createObject("java", "jxl.write.Number");
DateFormat = createObject("java", "jxl.write.DateFormat");
DateTime = createObject("java", "jxl.write.DateTime");
Calendar = createObject("java", "java.util.Calendar");
NumberFormat = createObject("java", "jxl.write.NumberFormat");
integerFormat = WritableCellFormat.init( NumberFormats.INTEGER );
number2 = Number.init( 0, 4, 3.141519, integerFormat );
sheet.addCell( number2 );
floatFormat = WritableCellFormat.init( NumberFormats.FLOAT );
number3 = Number.init( 1, 4, 3.141519, floatFormat );
sheet.addCell( number3 );
// note, # signs are escaped/doubled for CF
fivedps = NumberFormat.init("##.##########");
fivedpsFormat = WritableCellFormat.init( fivedps );
number4 = Number.init( 2, 4, 3.141519, fivedpsFormat );
sheet.addCell( number4 );
// Get the current date and time from the Calendar object
now = Calendar.getInstance().getTime();
customDateFormat = DateFormat.init( "dd MMM yyyy hh:mm:ss" );
dateFormat = WritableCellFormat.init( customDateFormat );
dateCell = DateTime.init( 0, 6, now, dateFormat );
sheet.addCell( dateCell );
////////////////////////////////////////////////
workbook.write();
workbook.close();
WriteOutput("Done");
</cfscript>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:305069
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
