Participating Frequently

Question

CFCONTENT

11 replies
1799 views
Translate

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

This topic is closed to new replies. Start a new post to keep the conversation going.

C

cphamAuthor

Participating Frequently

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.

Translate

EddieLotter

Inspiring

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

Translate

BKBK

Community Expert

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.

Translate

C

cphamAuthor

Participating Frequently

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.

Translate

BKBK

Community Expert

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.

Translate

WolfShade

Legend

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.

Translate

BKBK

Community Expert

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

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

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

That looks like the one for XLSX files.

Translate

EddieLotter

Inspiring

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

Translate

C

coylo

Known Participant

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.

Translate

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.