5 Replies Latest reply on Feb 8, 2011 5:56 AM by emmim44

    Remove extra empty rows from excel - cfspreadsheet

    emmim44 Level 1

      Hi all,

      I am testing an excel file reader, and the spreasheet tag brings the empty rows as well. How would I prevent empty rows?

       

      I have 10 rows in excel once I run the this tag it brings 60 more rows(empty rows), and the rowcound becomes 70..

       

       

      <cfspreadsheet action="read"

       

       

      src="#form.UPLOADFILE#"

       

       

      query="myQuery">

       

       

      <cfdump var="#myQuery#">