Excel Add-In for SharePoint

Build 20.0.7695

Pictures

Create, update, delete, and query documents in a picture library.

Columns

Name Type ReadOnly Description
ID [KEY] String True

The ID of the document. The format of the ID is: List|ItemID.

List String False

The name of the list the document belongs to.

LinkFileName String False

The filename of the document on the server.

ImageCreateDate Date False

The date the picture was taken.

Description String False

The description associated with the document.

Keywords String False

The keywords associated with the document.

CheckedOutUser String False

The user the document is checked out to.

Author String False

The user that created the item.

Editor String False

The last user that modified the item.

Modified Date False

The date that the document was modified.

Created Date False

The date that the document was created.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
CAMLQuery String

The query to be used while listing the list items.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7695