PostText 属性 (Excel)QueryTable.PostText property (Excel)

返回或设置用于向 web 服务器中输入数据以从 web 查询返回数据的 post 方法的字符串。Returns or sets the string used with the post method of inputting data into a web server to return data from a web query. 读/写 StringRead/write String.

语法Syntax

表达式PostTextexpression.PostText

_表达式_一个代表查询表对象**** 的变量。expression A variable that represents a QueryTable object.

说明Remarks

Microsoft Excel 包含示例 web 查询, 您可以通过使用写字板或其他文本编辑器更改 HTML 代码来修改这些查询。Microsoft Excel includes sample web queries that you can modify by changing the HTML code by using WordPad or another text editor. 查询示例在 Microsoft Office 的安装文件夹的“Queries”文件夹中。You can find these samples in the Queries folder where you installed Microsoft Office.

如果使用用户界面导入数据, 则会将来自 web 查询或文本查询的数据作为一个查询表**** 对象导入, 而将所有其他外部数据作为**ListObject** 对象导入。If you import data by using the user interface, data from a web query or a text query is imported as a QueryTable object, while all other external data is imported as a ListObject object.

如果使用对象模型导入数据, 则必须将来自 web 查询或文本查询的数据作为查询表导入****, 而所有其他外部数据均可作为ListObject或查询表导入。 ****If you import data by using the object model, data from a web query or a text query must be imported as a QueryTable, while all other external data can be imported as either a ListObject or a QueryTable.

PostText 属性仅适用于 QueryTable 对象。The PostText property applies only to QueryTable objects.

支持和反馈Support and feedback

有关于 Office VBA 或本文档的疑问或反馈?Have questions or feedback about Office VBA or this documentation? 请参阅 Office VBA 支持和反馈,获取有关如何接收支持和提供反馈的指南。Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.