Coldfusion (Railo 3.3.4)使用 POI 元件 寫出 XLSX 檔案
補充前一篇 Coldfusion (Railo 3.3.4) 使用 POI 元件 讀取 xls/xlsx 修改記錄 我在 POIUtility.cfc 內加入一個 Function 用來處理寫出 XLSX 格式檔案 cfc 程式碼(增加): <!--- 自訂寫出 XLSX 的 EXCEL 檔案---> < cffunction name= "WriteExcelX" access= "public" returntype= "void" output= "false" hint= "Takes an array of 'Sheet' structure objects and writes each of them to a tab in the Excel file." > <!--- Define arguments. ---> < cfargument name= "FilePath" type= "string" required= "true" hint= "This is the expanded path of the Excel file." /> < cfargument name= "Sheets" type= "any" required= "true" hint= "This is an array of the data that is needed for each sheet of the excel OR it is a single Sheet object. Each '