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.
have you actually tried it, because it just gives me "Variable Spreadsheetformatcellrange undefined" do you know if that is a bug?
ReplyDelete