creating multiple sheets using Coldfusion SpreadsheetWrite and cfscript
<p>I'd like to create a single excel file with two sheets using CF9, SpreadsheetWrite and cfscript.  Something like:</p>

<pre><code>var data= spreadsheetNew( 'data' );
var key= spreadsheetNew( 'key');
spreadsheetAddRow( data, dataInfo );
spreadsheetAddRow( key, keyInfo );      
spreadsheetWrite( data, filePath );
spreadsheetWrite( key, filePath );
</code></pre>

<p>I don't find documentation that explains how to combine multiple sheets in one file. Here's what I find. </p>

<p><a href="http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSe9cbe5cf462523a0-7b585809122c5a12c54-7fff.html" rel="nofollow">http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSe9cbe5cf462523a0-7b585809122c5a12c54-7fff.html</a></p>

<p>It states that one can 'Write multiple sheets to a single file.' but whether that means more than one sheet at a time is not clear.  You can accomplish this using tags but I need to use cfscript.</p>

<pre><code>&lt;cfspreadsheet action="update"  filename = "filePath" sheetname = "key" &gt; 
</code></pre>

<p>How does one write the above tag-based call using cfscript?</p>