python写一个读取excel文件用例通过jira接口向里面导入用例实例

首先，需要安装 openpyxl 和 jira-python 两个库：

pip install openpyxl jira

然后，按照以下步骤编写代码：

1. 导入库和模块：

import openpyxl
from jira import JIRA

2. 打开 Excel 文件：

workbook = openpyxl.load_workbook('testcases.xlsx')
worksheet = workbook['Sheet1']

3. 创建 JIRA 连接：

options = {'server': 'https://your-jira-instance-url'}
jira = JIRA(options, basic_auth=('username', 'password'))

4. 遍历 Excel 表格，读取用例信息，并创建用例实例：

for row in worksheet.iter_rows(min_row=2):
    summary, description, priority, status = [cell.value for cell in row]
    
    issue_dict = {
        'project': {'key': 'PROJECT_KEY'},
        'summary': summary,
        'description': description,
        'issuetype': {'name': 'Test Case'},
        'priority': {'name': priority},
        'status': {'name': status}
    }
    
    new_issue = jira.create_issue(fields=issue_dict)

其中，`PROJECT_KEY` 是项目的缩写，需要替换成实际项目的缩写。`summary` 是用例标题，`description` 是用例描述，`priority` 是用例优先级，`status` 是用例状态。根据需要，可以在 `issue_dict` 中添加其他字段。

5. 关闭连接：

jira.close()

完整代码示例：

import openpyxl
from jira import JIRA

workbook = openpyxl.load_workbook('testcases.xlsx')
worksheet = workbook['Sheet1']

options = {'server': 'https://your-jira-instance-url'}
jira = JIRA(options, basic_auth=('username', 'password'))

for row in worksheet.iter_rows(min_row=2):
    summary, description, priority, status = [cell.value for cell in row]
    
    issue_dict = {
        'project': {'key': 'PROJECT_KEY'},
        'summary': summary,
        'description': description,
        'issuetype': {'name': 'Test Case'},
        'priority': {'name': priority},
        'status': {'name': status}
    }
    
    new_issue = jira.create_issue(fields=issue_dict)

jira.close()