Question

采用“冷聚”(>SpreadSheet()”的物体,我建立了“Excel”文档,现在用户需要能够下载。

mySS = SpreadsheetNew();
format1 = StructNew();
format1.color="dark_green";
format1.size="24"; 
SpreadSheetSetCellValue(mySS, 7,2,3);
SpreadSheetFormatCell(mySS, format1, 2, 3);

基本上,我喜欢这样的东西。

<cfdownload var="#mySS#">

然而,这几乎从未如此简单。我认识到,我可以撰写文件,然后使用<代码>cfheadercfcontent。然而,尽管如此,但还是如此。我尽量避免撰写档案。

<><>Edit>/strong>

根据这一建议,我从speshak 。审判

<cfcontent variable="#mySS#"  type="application/msexcel">

and the error I got was, am I missing something?

coldfusion.excel.ExcelInfo is not a supported variable type. The variable is expected to contain binary data.

Answer 1

Alright so thanks to Raymond Camden s Post and speshak here is the final solution.

<cfheader name="Content-Disposition" value="attachment;filename=filename.xls">
<cfcontent variable="#spreadsheetReadBinary(mySS)#"  type="application/msexcel">

Answer 2

Try:

<cfcontent/2007/5>#mySS#”>

也许,你也想确定这种特性,因此浏览器知道它不是超文本。

友情链接