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"









      <cfdump var="#myQuery#">