为什么Web Query不在Microsoft Excel 2010中突出显示我的表？ [英] Why is Web Query not highlighting my table in Microsoft Excel 2010?
问题描述
我希望使用Excel的Web查询功能，让用户可以访问不断变化的数据集。
I am looking to use Excel's Web Query feature to give users access to constantly changing datasets.
为什么不直接将ODBC连接到数据库？好吧，我正在处理的几个服务器上有几个数据库。为了避免授予用户不同级别的复杂ODBC访问权限，并避免培训这些用户如何使用ODBC访问他们需要的数据，我想我会创建一个简单的Web应用程序，用于输出用户在干净的HTML中需要的数据表。
Why not ODBC straight to the database? Well, there are several databases on several servers that I'm dealing with. To avoid granting users varying levels of complicated ODBC access, and to avoid then training those users on how to use ODBC to access the data they need, I thought I'd create a simple web app that outputs the data the users need in clean HTML tables.
创建页面之后，我遇到了以下问题。
After creating the pages though, I'm having the following problem.
小黄色选择箭头仅出现在页面的左上角，而不是出现在每个表格的旁边。如果我使用左上角的选择箭头导入，当我只想要输出表时，会导入整个页面。
The little yellow selection arrow is only appearing in the top-left corner of the page, and not alongside each table. If I import using the top-left selection arrow, the entire page is imported when I only really want the "Output" table.
是否有必须使用的特定设置在标记HTML表格以与Excel的Web查询工具兼容时？
Are there specific settings that must be used when marking up an HTML table to be compatible with Excel's Web Query tool?
推荐答案
我将我的代码与另一个网页的代码进行了比较表格在Web Query中正确突出显示的位置。通过一些反复试验，我发现了问题。
I compared my code with the code of another webpage where the tables were highlighting properly in Web Query. Through some trial and error, I found the problem.
在我的网页的< head> 部分，我有以下元标记。
In the <head> section of my webpage, I had the following meta tag.
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
如果包含此选项，则Web查询表选择选项会中断。基于消失的Bootstrap圆角，我猜测Web Query正在使用某种IE兼容模式，而上面的元标记会破坏它。
Turns out when this is included, the Web Query table selecting option breaks. Based on the disappearing Bootstrap rounded corners, I'm guessing Web Query is using some sort of IE Compatibility Mode, and the above meta tag breaks it.
这篇关于为什么Web Query不在Microsoft Excel 2010中突出显示我的表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
