user12031119
2020-12-16 04:36:27
Presuming your excel file has a header record, what you should do is first read the excel file into a query object. From there, you can then export the query object into a csv by writing the file using a <cfoutput> loop.
<cfspreadsheet action="read" src="c:\bin\Nov_sales.xlsx" query="qryExcel">
<cfoutput query="qryExcel">
<cfset line = "#col1#,#col2#,#col3#,#col4#,#col5#">
<cffile action="append" file="c:\bin\Nov_sales.csv" output="#line#">
</cfoutput>
热门帖子
热门github
6