Sunday, August 1, 2010

ColdFusion SpreadSheet enhancement in 9.0.1

ColdFusion 9.0.1 also adds few enhancements for interacting with spreadsheets. There is significant performance improvement over formatting large number of rows and columns. Also added was a neat function to format a group of cells.

SpreadsheetFormatCellRange

Example: 

SpreadSheetFormatCellRange(spreadSheetVar,{bold='true',color='red',fontsize='15'},2,2,10,20);

This will format rows 2 to 10 and columns 2 to 20.

2 comments: