Create Excel and save it to server

[tims4831424]

Hi all,

i create a xsl file with:

<cfcontent type="application/vnd.ms-excel" >
<cfheader name="Content-Disposition" value="filename=fehlmenge2.xls">

But the browser wat everytime to download the file.

i want to make a shedule cfm site and save the file to the server... 

but how can i say save as to server not open in browser?

Kindly regards.

thorsten

[George____]

My guess is that you're generating an HTML table and passing that to the browser with an xls extension.    These aren't excel files and if you look at them in notepad, you'll see it's just HTML.   If you want a true xls or xlsx file use spreadsheetnew.   xlsx files will be smaller in size.   You can also use cfspreadsheet if you want xls.

Lots of examples online, but this is one I found quickly:

https://blog.mattclemente.com/2019/10/11/til-generating-xlsx-files-with-coldfusion.html

If you really want to save an HTML content then just surround the table with cffile.   Make sure you specify a full path for the filename or it might not save where you expect it to.

<cffile action="write" file="#filename#">

    your html table

</cffile>

[tims4831424]

<cfcontent type="application/vnd.ms-excel" >
<cfheader name="Content-Disposition" value="filename=fehlmenge2.xls">

Are genrating an excel... if i show the page the excel file will automatically download.. and i can open it normal in excel.

but i want to genrate on a sheduler the excel files . in couse of that i donwt want to download the file by load the page.. 

i know cfspreadsheet. But the simple way to genrate an excel by a table wth cfcontent and cfheader is simpler...

[BKBK · Accepted solution]

Let's say,

1.  our location is the webroot.

2.  the name of the page that generates the Excel sheet is generateExcel.cfm. That is,

<!--- generateExcel.cfm --->
<!--- Send the contents, consisting of Excel binary data, to page output --->
<cfcontent type="application/vnd.ms-excel" >
<cfheader name="Content-Disposition" value="inline;filename=fehlmenge2.xls">

Then a possible solution is to create a new CFM page, say, saveExcel.cfm. This page GETs the Excel contents by HTTP and saves it at a location on the server:

<!--- saveExcel.cfm --->
<!---
The page generateExcel.cfm generates Excel content. The current page gets the binary content and saves it to a location on the ColdFusion server.
 --->
<cfhttp url="http://localhost:8500/generateExcel.cfm" method="get" getasbinary="yes" charset="utf-8">
<cffile action="write" file="C:\ColdFusion2021\cfusion\wwwroot\docs\ExcelDoc.xls" output="#cfhttp.filecontent#">
Excel file saved to server.

[tims4831424]

Fine i think thats the solution.....

But now a have the next problem.

My site is with letsencrypt ssl... i get anytime the message:

connection failure.....

If i try cfhttp with for example google.de all is ok...

Kindly regards

thorsten

[EddieLotter]

It would be better to mark @BKBK 's response as the answer to this thread's problem and start a new thread with your new problem, otherwise this thread will become confusing for people looking for answers to similar problems.