问题描述
我有 SQL Server 2014,我正在尝试通过 URL 访问来访问我的报告.据我了解,Excel 格式应该给我一个支持无限行数的 XLSX 文件.但是,在查看我的日志文件后,我注意到对于超过 65536 行的任何报告,我得到了最大的行错误.在调查之后,我发现任何时候我通过 URL 请求格式为 EXCEL 的报告时,它们都会生成一个 XLS 文件而不是 XLSX.如果我从 Visual Studio 中运行报告并导出为 EXCEL,它们生成的结果就像 XLSX.有人知道如何解决这个问题吗?
I have SQL Server 2014 and I'm trying to access my reports via the URL access. As I understand, the Excel format should be giving me an XLSX file which supports an unlimited number of rows. However, after looking at my log files I noticed that I was getting maximum row errors for any reports with more then 65536 rows. After looking into this I discovered that any time I request the reports via URL with format as EXCEL, they generate a XLS file instead of XLSX. If I run the reports out of Visual Studio and export as EXCEL, they generate just fine as XLSX. Anyone have any idea how to fix this issue?
推荐答案
找到了这个问题的解决方案,所以我想我会在这里回答,以防其他人遇到这个问题.Microsoft 网站上列出的 URL 访问支持格式列表此处显示了以下列表:HTML4.0、MHTML、IMAGE、EXCEL、WORD、CSV、PDF、XML 和 NULL
Found the solution to this problem so I figured I'd answer it here in case anyone else runs into this problem. the list of supported formats for URL access listed on Microsoft's website here shows the following list: HTML4.0, MHTML, IMAGE, EXCEL, WORD, CSV, PDF, XML, and NULL
但是,它没有列出实际生成 XLSX 文件的文件.该格式为EXCELOPENXML.他们为什么不列出这种格式超出了我的理解.也许我找错了地方.
It does not, however, list the one that actually generates an XLSX file. That format is EXCELOPENXML. Why they don't list this format is beyond me. Perhaps I was looking in the wrong places.
这篇关于当格式为 EXCEL 时,SSRS 2014 URL 访问总是生成 XLS 而不是 XLSX的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!