</cftry> ---- NumberFormat Syntax NumberFormat(num, mask); NumberFormat(123456789.99, ",") Excel cfspreadsheet syntax depends on the action attribute value: 注意 Read 和 Write 的参数有些不同, Write 的时候不需要 src 这样的参数 Read <cfspreadsheet ="row number" name="text" query="query name" rows="range" sheet="number" sheetname="text"> Update <cfspreadsheet filepath" format="csv" name="text" password="password" query="query name" sheetname="text"> Write <cfspreadsheet --- write and download---> <cfspreadsheet action="write" filename="/report.xls" sheetname="Declaration
--- Write to server ---> <cfspreadsheet action="write" filename="/report.xlsx" sheetname="Declaration