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">
Retrieving data ...