doc.core_properties.subject 方法
时间: 2023-06-19 22:03:34 浏览: 50
`doc.core_properties.subject` 方法用于获取或设置文档的主题。在 Microsoft Office 文档中,主题是指文档的主题或概述。该方法返回一个字符串,表示文档的主题。如果文档没有设置主题,则返回空字符串。如果要设置文档的主题,可以将一个字符串作为参数传递给该方法。例如,以下代码将文档的主题设置为 "My Document":
```
from docx import Document
doc = Document()
doc.core_properties.subject = "My Document"
```
在此示例中,我们创建了一个新的空白文档,并将其主题设置为 "My Document"。要注意的是,必须在保存文档之前设置文档的主题,否则更改将不会生效。
相关问题
doc.core_properties.keywords方法
`doc.core_properties.keywords` 是一个属性,用于访问文档对象的关键字属性。这个属性返回一个字符串,其中包含逗号分隔的关键字列表。
以下是使用 `doc.core_properties.keywords` 属性的示例代码:
```python
from docx import Document
# 创建一个空的 Word 文档对象
document = Document()
# 设置文档的关键词属性
document.core_properties.keywords = 'Python, Docx, Word'
# 获取文档的关键词属性
keywords = document.core_properties.keywords
print(keywords) # 输出:Python, Docx, Word
```
在上面的代码中,我们首先创建了一个空的 Word 文档对象。然后,使用 `document.core_properties.keywords` 属性设置文档的关键词属性为“Python, Docx, Word”。最后,我们获取文档的关键词属性,并将其输出到控制台。
请简化sql: select d.document_id , d.workflow_order_id,e.handle_result, d.workflow_id ,d.process_id -- ,e.workflow_id as workflow_id2 from (select doc.document_id , wo.workflow_order_id,wo.workflow_id,doc.process_id from document doc inner join workflow_order wo on doc.document_id = wo.object_id where doc.document_id = 1476093058673315842 and wo.workflow_id in( SELECT CASE WHEN process_id IN (1, 2) THEN 1470275488528011266 WHEN process_id IN (3, 4) THEN 1470275525786034178 END AS workflow_id FROM document WHERE document_id = 1476093058673315842 ) and wo.status != 3 )as d inner join (select wo.workflow_order_id,wr.handle_result,wr.workflow_id from workflow_record wr inner join workflow_order wo on wo.workflow_order_id = wr.workflow_order_id where wo.workflow_order_id in ( select wo.workflow_order_id from document doc inner join workflow_order wo on doc.document_id = wo.object_id where doc.document_id = 1476093058673315842 and wo.workflow_id in( SELECT CASE WHEN process_id IN (1, 2) THEN 1470275488528011266 WHEN process_id IN (3, 4) THEN 1470275525786034178 END AS workflow_id FROM document WHERE document_id = 1476093058673315842 ) and wo.status != 3 ) ) as e on d.workflow_order_id = e.workflow_order_id ;
简化后的SQL语句如下:
```
SELECT d.document_id, d.workflow_order_id, e.handle_result, d.workflow_id, d.process_id
FROM (
SELECT doc.document_id, wo.workflow_order_id, wo.workflow_id, doc.process_id
FROM document doc
INNER JOIN workflow_order wo ON doc.document_id = wo.object_id
WHERE doc.document_id = 1476093058673315842
AND wo.workflow_id IN (
SELECT CASE
WHEN process_id IN (1, 2) THEN 1470275488528011266
WHEN process_id IN (3, 4) THEN 1470275525786034178
END AS workflow_id
FROM document
WHERE document_id = 1476093058673315842
)
AND wo.status != 3
) AS d
INNER JOIN (
SELECT wo.workflow_order_id, wr.handle_result, wr.workflow_id
FROM workflow_record wr
INNER JOIN workflow_order wo ON wo.workflow_order_id = wr.workflow_order_id
WHERE wo.workflow_order_id IN (
SELECT wo.workflow_order_id
FROM document doc
INNER JOIN workflow_order wo ON doc.document_id = wo.object_id
WHERE doc.document_id = 1476093058673315842
AND wo.workflow_id IN (
SELECT CASE
WHEN process_id IN (1, 2) THEN 1470275488528011266
WHEN process_id IN (3, 4) THEN 1470275525786034178
END AS workflow_id
FROM document
WHERE document_id = 1476093058673315842
)
AND wo.status != 3
)
) AS e ON d.workflow_order_id = e.workflow_order_id;
```