We are using CFSPREADSHEET to read data from an outputted excel spreadsheet and then we want to create a new single worksheet spreadsheet based on the query from the old one (Which has 10 worksheets that we don't want to share with the user).
Reading isn't a big deal:
<cfspreadsheet action="read" src="cells\tool.xlsx" sheetname="Export" rows="1-80" columns="1-55" query="Output">
But is there a simple/quick way to do the write part of this? We were looping through the output but that seems to take forever.