Skip to main content
Participant
November 26, 2013
Question

read a spreadsheet and replace spaces

  • November 26, 2013
  • 0 replies
  • 326 views

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">


This topic has been closed for replies.