Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <cfscript>
- mySheet = spreadSheetNew("My Sheet");
- spreadSheetAddRow(mySheet, "'Col. A','Col. B','Col. C'");
- for(i=1; i <= RandRange(1, 100); i++){
- spreadSheetAddRow(mySheet, "'Row A#i#','Row B#i#','Row C#i#'");
- }
- spreadSheetFormatRow(mySheet, {bold = true, fontsize = 24}, 1);
- spreadSheetFormatRows(mySheet, {fontsize = 16}, "2-#mySheet.rowcount#");
- cfheader(name = "Content-Disposition", value = 'inline; fileName="test.xls"');
- cfcontent(type="application/vnd.ms-excel", variable="#spreadSheetReadBinary(mySheet)#");
- </cfscript>
- <cfoutput>2-#mySheet.rowcount#</cfoutput>
Add Comment
Please, Sign In to add comment