blocks|key|3322403|text|我不相信你可以对用户隐藏它。这些类型的警告是浏览器外部的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3322404|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I don't believe you can hide it from the user. Those kinds of warnings are external to your browser.

blocks|key|339855|text|如果您不想寻找解决方案，而只是想解决问题，请在您的注册表中插入此键以禁止通知：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|339856|HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security“ExtensionHardening”=dword:00000000|339857|您可以通过执行以下操作来完成上述操作：|339858|339859|打开注册表(开始并运行HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\12.0\EXCEL\SECURITY|ordered-list-item|339860|Right+->+regedit.exe)|339861|Navigate+to+HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\12.0\EXCEL\SECURITY|339862|Right在右侧窗口中单击并选择新建->+DWORD|339863|键入“ExtensionHardening”作为名称(不带引号)|339864|验证数据是否具有值“0”|339865|339866|entityMap^0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|G|3|H|5|I|7|10|8|@]|9|@]|A|$]]|$1|J|3|K|5|I|7|11|8|@]|9|@]|A|$]]|$1|L|3|M|5|I|7|12|8|@]|9|@]|A|$]]|$1|N|3|O|5|I|7|13|8|@]|9|@]|A|$]]|$1|P|3|Q|5|I|7|14|8|@]|9|@]|A|$]]|$1|R|3|S|5|I|7|15|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|16|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|V|$]]

If you don’t want to look for a solution, but just want to solve the problem, insert this key in your registry to suppress the notification:

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security]
“ExtensionHardening”=dword:00000000

You can accomplish the above by doing the following:

<ol>
<li>Open your Registry (Start -> Run -> regedit.exe)</li>
<li>Navigate to HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\12.0\EXCEL\SECURITY</li>
<li>Right click in the right window and choose New -> DWORD</li>
<li>Type “ExtensionHardening” as the name (without the quotes)</li>
<li>Verify that the data has the value “0″</li>
</ol>

blocks|key|3322490|text|此问题是由扩展硬化功能导致的，您可以在here中找到有关该功能的更多信息|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3322491|我在我的项目中经常遇到这个问题，就像Jon所说的，关闭扩展硬化是每个客户端用户必须完成的事情。|3322492|不幸的是，上面的链接还指出，至少在Office+14之前，不会对此代码进行预期的更改。|3322493|entityMap|0|LINK|mutability|MUTABLE|url|https://web.archive.org/web/20090615225051/http://blogs.msdn.com/vsofficedeveloper/pages/Excel-2007-Extension-Warning.aspx^0|J|4|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]]]

This problem results from a feature called Extension Hardening, and you can find more information about it <a href="https://web.archive.org/web/20090615225051/http://blogs.msdn.com/vsofficedeveloper/pages/Excel-2007-Extension-Warning.aspx" rel="nofollow noreferrer">here</a>

I've run into this problem a lot in my projects, and like Jon said, turning off Extension Hardening is something that will have to be done by each client side user.

Unfortunately, the link above also states that there are no expected changes to this code until at least Office 14.

blocks|key|339886|text|该消息表明文件内容和文件扩展名不匹配。因此，要么是XLSX文件，要么是服务器上的当前文件以某种方式损坏了。我建议尝试使用ZIP工具打开该文件。如果可以，那么它实际上是一个XLSX格式的文件。然后，您可以通过重命名该文件来修复警告。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|339887|如果不是这样，那么说明文件发生了一些问题。|339888|但是，无论哪种方式，抑制警告都不能解决您的问题。下次病毒出现并要求客户打开nakedgrls.gif.exe时，最好不要弄乱安全设置。|offset|length|style|CODE|339889|entityMap^0|0|0|11|H|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@$F|O|G|P|H|I]]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

The message suggests that the file contents and the file extension don't match. So either it's an XLSX file or the current file on the server is broken in some way. I suggest to try to open the file with a ZIP tool. If that works, it's really an XLSX-format file. Then you can fix the warning by renaming the file.

If that's not the case, something happened to the file.

But either way, suppressing the warning is not a solution to your problem. The next time a virus comes along and asks your customers to open <code>nakedgrls.gif.exe</code>, you better didn't mess with the security settings.

blocks|key|343353|text|如果您正在使用方便的cfcontent技巧将其输出为excel文件，请考虑使用cfx_query2excel，它将编写真正的excel文件，应该可以帮助您克服这个问题。这是一个Java库，值得一试。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|343354|祝你好运。|343355|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

If you're using the handy cfcontent trick to output as an excel file, consider using cfx_query2excel, it will write real excel files that should get you past this. It's a Java library and was worth it.

Best of luck.

blocks|key|341036|text|如果未指定文件扩展名，则可能会将其命名为内容类型为“.cfm+/vnd-excel”的应用程序文件，从而导致此警告。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|341037|尝试在文件输出开始之前添加以下内容：|341038|<cfheader+name="Content-Disposition"+value="attachment;filename=myexcelfile.xls">
<cfcontent+type="application/ms-excel"+reset="true">|code-block|syntax|javascript|341039|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

If you are not specifying the file extension, it is probably getting named as a .cfm file with the content type as "application/vnd-excel" which causes this warning.

Try adding this before the file output begins:

<pre><code>&lt;cfheader name="Content-Disposition" value="attachment;filename=myexcelfile.xls"&gt;
&lt;cfcontent type="application/ms-excel" reset="true"&gt;
</code></pre>

blocks|key|3109644|text|我也有同样的问题，客户也在抱怨。我已经用谷歌搜索了很多次，但是没有成功。最后，我使用cfspreadsheet创建了电子表格，我知道它需要额外的工作，而不是直接通过HTML创建，但它删除了警告。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3109645|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I had same kind of issue and client complaining about it. I had done much googling but no luck. Finally I have created spreadsheet using cfspreadsheet, I know it require additional work than directly creating through HTML but it remove warning.

blocks|key|338623|text|对于旧的Excel格式(.xls)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|338624|假设您使用以下语法创建电子表格对象：|338625|<cfset+sheet+=+SpreadsheetNew()+/>+|code-block|syntax|javascript|338626|您可以使用下面的代码来创建下载：|338627|<cfheader+name="content-disposition"+value="attachment;filename=my_spreadsheet.xls">
<cfcontent+type="application/vnd.ms-excel"+variable="#spreadsheetReadBinary(sheet)#"+reset="true">|338628|对于较新的Excel格式(.xlsx)|338629|使用以下语法创建电子表格对象：|338630|<cfset+sheet+=+SpreadsheetNew("",+"true")+/>|338631|并使用此命令创建下载：|338632|<cfheader+name="content-disposition"+value="attachment;filename=my_xml_spreadsheet.xlsx">
<cfcontent+type="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"+variable="#spreadsheetReadBinary(sheet)#"+reset="true">|338633|多亏了Raymond+Camden+(他的示例是用旧的格式创建电子表格--我更新了新的格式并使用稍有不同的MIME值)。|offset|length|338634|entityMap|0|LINK|mutability|MUTABLE|url|http://www.raymondcamden.com/index.cfm/2011/7/12/One-more-I-swear-this-is-it-follow-up-to-my-CFSpreadSheet-Example^0|0|0|0|0|0|0|0|0|0|0|3|E|0|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|19|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1A|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|1B|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|1C|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|1D|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1E|8|@]|9|@]|A|$]]|$1|Q|3|R|5|F|7|1F|8|@]|9|@]|A|$G|H]]|$1|S|3|T|5|6|7|1G|8|@]|9|@]|A|$]]|$1|U|3|V|5|F|7|1H|8|@]|9|@]|A|$G|H]]|$1|W|3|X|5|6|7|1I|8|@]|9|@$Y|1J|Z|1K|1|1L]]|A|$]]|$1|10|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]]|11|$12|$5|13|14|15|A|$16|17]]]]

<h2>For the old Excel format (.xls)</h2>

Assuming you create your spreadsheet object with this syntax:

<pre><code>&lt;cfset sheet = SpreadsheetNew() /&gt; 
</code></pre>

You would use this to create the download:

<pre><code>&lt;cfheader name="content-disposition" value="attachment;filename=my_spreadsheet.xls"&gt;
&lt;cfcontent type="application/vnd.ms-excel" variable="#spreadsheetReadBinary(sheet)#" reset="true"&gt;
</code></pre>

<h2>For the newer Excel format (.xlsx)</h2>

Create your spreadsheet object with this syntax:

<pre><code>&lt;cfset sheet = SpreadsheetNew("", "true") /&gt;
</code></pre>

And use this to create the download:

<pre><code>&lt;cfheader name="content-disposition" value="attachment;filename=my_xml_spreadsheet.xlsx"&gt;
&lt;cfcontent type="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" variable="#spreadsheetReadBinary(sheet)#" reset="true"&gt;
</code></pre>

Thanks to <a href="http://www.raymondcamden.com/index.cfm/2011/7/12/One-more-I-swear-this-is-it-follow-up-to-my-CFSpreadSheet-Example" rel="nofollow">Raymond Camden</a> for the bulk of this (his example was for creating the spreadsheet in the older format -- I updated for the newer format and use slightly different MIME values).

I have a web page which links to an Excel 2007 worksheet. It is a <code>.xls</code> file and not <code>.xlsx</code> file. When I click on the link I get the usual dialog box to either open/save the Excel file. On clicking 'Open', I get the following warning message-

<blockquote>
 The file you are trying to open,
 'filename.xls' is in a different
 format than specified by the file
 extension. Verify that the file is not
 corrupted and is from a trusted source
 before opening the file. Do you want
 to open the file now?
</blockquote>

Can I some how suppress this warning message programmatically (i.e. to hide it or prevent it from showing up?) I'm using ColdFusion for web development.

How to suppress the file corrupt warning at Excel download?

服务器

Java

我有一个链接到Excel2007工作表的网页。它是一个.xls文件，而不是.xlsx文件。当我点击链接时，我会看到通常的对话框，打开/保存Excel文件。单击“打开”时，我收到以下警告消息-您正在尝试打开的文件，'filename.xls‘的格式与文件扩展名指定的格式不同。在打开该文件之前，请确认该文件未损坏且来源可信...

问如何抑制Excel下载时的文件损坏警告？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何抑制Excel下载时的文件损坏警告？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何抑制Excel下载时的文件损坏警告？
EN