You really ought to be looking outside of CF for transfers of large
datasets, especially into Excel. Have you tried using SSIS (SQL Server
Integration Services) for this? It's really not that difficult to do and
it'll handle millions of rows easily...
--
Jeff
Original Message
Ive actually become quite fond of CF's Spreadsheet functions, though I prefer
to use the script versions as I find them more flexible when dealing with large
datasets, formatting content for reports and working with multiple sheets:
Thank you. I am not using SpreadSheetWrite function to write to a file. I
am storing all the sheets in a variable and using cfheader and cfcontent to
prompt the user to save or download. Do you think this is a preferred
option?
On Tue, Jul 1, 2014 at 2:17 PM, Jon Clausen
ThatÂs really your call. The way youÂre doing it is the Âold-schoolÂ
method and used to be the standard for spreadsheet delivery. With CF9+, I find
working directly with the spreadsheet object allows me to avoid jumping through
a bunch of hoops to sanitize the cell input - especially
4 matches
Mail list logo