I want to know 2 more things in this
1. How make text bold
2. How to merge 2 cells
>> 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;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317204
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
