Guest User

Untitled

a guest
Oct 23rd, 2018
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. <cfscript>
  2. mySheet = spreadSheetNew("My Sheet");
  3. spreadSheetAddRow(mySheet, "'Col. A','Col. B','Col. C'");
  4. for(i=1; i <= RandRange(1, 100); i++){
  5. spreadSheetAddRow(mySheet, "'Row A#i#','Row B#i#','Row C#i#'");
  6. }
  7. spreadSheetFormatRow(mySheet, {bold = true, fontsize = 24}, 1);
  8. spreadSheetFormatRows(mySheet, {fontsize = 16}, "2-#mySheet.rowcount#");
  9. cfheader(name = "Content-Disposition", value = 'inline; fileName="test.xls"');
  10. cfcontent(type="application/vnd.ms-excel", variable="#spreadSheetReadBinary(mySheet)#");
  11. </cfscript>
  12. <cfoutput>2-#mySheet.rowcount#</cfoutput>
Add Comment
Please, Sign In to add comment