0 Replies Latest reply on Nov 26, 2013 10:19 AM by user197912

    read a spreadsheet and replace spaces


      I am using a cfspreadsheet tag to read excel file. Since, I am using QoQ, the file import errors out since the header row has spaces in it?


      How do we read the header row specifically and replace spaces and save the file before moving forward? Thanks


      <cfspreadsheet action="read" src="c:\WellRecords.xls" query="qryRecords" headerrow="1" sheetname="1">