Highlighted

CFCONTENT

New Here ,
Jul 28, 2016

Copy link to clipboard

Copied

The code is no longer worked on some Chrome/IE browsers. It will open Excel but nothing loads.

<cfheader name="Content-Disposition" value="inline; filename=Report.xls">

<cfcontent type="application/vnd.msexcel">

Views

1.0K

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

CFCONTENT

New Here ,
Jul 28, 2016

Copy link to clipboard

Copied

The code is no longer worked on some Chrome/IE browsers. It will open Excel but nothing loads.

<cfheader name="Content-Disposition" value="inline; filename=Report.xls">

<cfcontent type="application/vnd.msexcel">

Views

1.0K

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Jul 28, 2016 0
Advocate ,
Jul 28, 2016

Copy link to clipboard

Copied

If "nothing loads" then you're probably not emitting anything that Excel can interpret.

I use this type of scenario for certain reports and it works in Chrome, IE 11 and Chrome under Windows 10.

To troubleshoot, comment out the two lines that you showed and then browse to the page. What do you see in your Web browser?

Cheers

Eddie

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 28, 2016 0
Community Beginner ,
Jul 29, 2016

Copy link to clipboard

Copied

I am using Coldfusion 11 Standard and this exact same thing started happening about a week ago with me. MS Excel will open but nothing loads.  if i open the same .xls file with Open Office or even MS Word it will actually display the data.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 29, 2016 0
New Here ,
Jul 29, 2016

Copy link to clipboard

Copied

I used the bottom example as a test. Remove the two lines and the table shows up on the page but not in MS Excel.

<cfheader name="Content-Disposition" value="inline; filename=acmesalesQ1.xls">

<cfcontent type="application/vnd.msexcel">

<table border="2">

<tr><td>Month</td><td>Quantity</td><td>$ Sales</td></tr>

<tr><td>January</td><td>80</td><td >$245</td></tr>

<tr><td>February</td><td>100</td><td>$699</td></tr>

<tr><td>March</td><td>230</td><td >$2036</td></tr>

<tr><td>Total</td><td>=Sum(B2..B4)</td><td>=Sum(C2..C4)</td></tr>

</table>

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 29, 2016 0
LEGEND ,
Jul 29, 2016

Copy link to clipboard

Copied

Swap out your CFCONTENT with the following, and let me know if it works.

<cfcontent type="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet">

HTH,

^_^

UPDATE:  Upon further viewing of the thread, so far, I am curious.  I've never tried using a table to populate an Excel sheet.  I've always dropped to CFSCRIPT and used the SpreadsheetNew() function.  If you use SpreadsheetSetCellValue(), you get granular control over data and format, and can do some pretty spiffy stuff.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 29, 2016 0
Adobe Community Professional ,
Jul 30, 2016

Copy link to clipboard

Copied

WolfShade wrote:

Swap out your CFCONTENT with the following, and let me know if it works.

  1. <cfcontenttype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet">

That looks like the one for XLSX files.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 30, 2016 0
New Here ,
Jul 29, 2016

Copy link to clipboard

Copied

Unfortunately, it didn't work. This issue just started this week. It was working fin before.

The reason why using a table is to populate is the user has two options to view report: Browser or Excel.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 29, 2016 0
Adobe Community Professional ,
Jul 30, 2016

Copy link to clipboard

Copied

cpham wrote:

Unfortunately, it didn't work. This issue just started this week. It was working fin before.

I can imagine that the problem started only recently. The cause is likely to be Microsoft Office's security update of July 12, 2016.

One workaround to enable you to view the contents of the Excel file is as follows:

Go to

Excel Options => Trust Center => Trust Center Settings => Protected View

=> Uncheck the checkbox "Enable Protected View for files originating from the Internet".

Warning:

Use the suggestion I have given here at your own risk. Microsoft put the security settings in place for a reason.

This workaround is only a temporary solution, to be used for connections you trust. Return the settings to their most secure level afterwards.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 30, 2016 1
Adobe Community Professional ,
Jul 30, 2016

Copy link to clipboard

Copied

Alternative solution

<cfscript>

//Create a new Spreadsheet object

mySheet = SpreadsheetNew();

//Insert row data to sheet, with each row starting at column 1.

SpreadsheetAddRow(mySheet,"Month,Quantity,$ Sales",1,1);

SpreadsheetAddRow(mySheet,"January,80,$245",2,1);

SpreadsheetAddRow(mySheet,"February,100,$699",3,1);

SpreadsheetAddRow(mySheet,"March,230,$2036",4,1);

SpreadsheetAddRow(mySheet,"Total,=Sum(B2..B4),=Sum(C2..C4)",5,1);

</cfscript>

<!--- Write the spreadsheet to a file, replacing any existing file. --->

<cfspreadsheet action="write" filename="#expandpath('acmeFile.xls')#" overwrite="yes" name="mySheet">

<cfheader name="Content-Disposition" value="inline; filename=acmeFile.xls">

<cfcontent type="application/vnd.ms-excel" file="#expandpath('acmeFile.xls')#" deletefile="yes">

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 30, 2016 1
Adobe Community Professional ,
Jul 30, 2016

Copy link to clipboard

Copied

cpham wrote:

The code is no longer worked on some Chrome/IE browsers. It will open Excel but nothing loads.

<cfheader name="Content-Disposition" value="inline; filename=Report.xls">

<cfcontent type="application/vnd.msexcel">

The correct MIME type for XLS files is application/vnd.ms-excel.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 30, 2016 0
New Here ,
Aug 03, 2016

Copy link to clipboard

Copied

I’ve changed the settings for Excel. And it loads.

Trust Center> Trust Center Settings > Protected View. Unchecked -  Enable Protected View for files originating from the Internet.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Aug 03, 2016 0
Advocate ,
Aug 03, 2016

Copy link to clipboard

Copied

That is what BKBK​ said in a previous post, but it's worth heeding his bolded warning. It's also worth noting that if this is not an internal app then you have no control over your external users' computer settings.

Cheers

Edde

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Aug 03, 2016 1