Copy Data from Excel and Write to New Excel with CFSPREADSHEET

Posted on 2012-09-07
Last Modified: 2012-09-07
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.
Question by:digitalwise
    LVL 51

    Accepted Solution

    Maybe I'm missing something, but if the data is already in a query - can't you just do action=write, like:

    <cfspreadsheet action="write"

    Author Closing Comment

    Thank you.   So many complicated solutions - forgetting that there was an easy one.   Geez!!  Thanks.
    LVL 51

    Expert Comment

    Yeah, sometimes all we need is a second set of eyes :)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    This article  is about submitting  form through  ColdFusion.Ajax.submitForm to the action page and send a response back in JSON format which later can be decoded using ColdFusion.JSON.decode. By this way you can avoid the usual page refresh for subm…
    PROBLEM: How to add your own buttons to the bottom toolbar with paging info ( result count ). While creating a cfgrid, I ran into an issue where I wanted to embed my own custom buttons where the default ones ( insert / delete / etc… ) are for aes…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now