python 使用openpyxl将数据:[{"name":"li","age":18},{"name":"wang","age":24}] 写道Excel文件中 字典key为表头,表头字体为粗体。保存文件名test放到D:\
时间: 2023-08-14 19:03:36 浏览: 33
要使用openpyxl将数据写入Excel文件中,可以按照以下步骤进行操作:
1. 首先,导入openpyxl库并创建一个工作簿对象:
```python
import openpyxl
wb = openpyxl.Workbook()
```
2. 创建一个工作表对象,并设置表头字体为粗体:
```python
ws = wb.active
header_font = openpyxl.styles.Font(bold=True)
ws.append(\["name", "age"\])
for cell in ws\[1\]:
cell.font = header_font
```
3. 将数据写入工作表中:
```python
data = \[{"name": "li", "age": 18}, {"name": "wang", "age": 24}\]
for item in data:
ws.append(\[item\["name"\], item\["age"\]\])
```
4. 保存文件到指定路径:
```python
save_path = "D:\\test.xlsx"
wb.save(save_path)
```
这样,数据就会被写入Excel文件中,字典的key作为表头,并且表头字体为粗体。文件将保存在D盘的test.xlsx文件中。
#### 引用[.reference_title]
- *1* [010 python数据结构与算法:算法概论;时间复杂度](https://blog.csdn.net/qq_34539676/article/details/106865325)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insert_down28v1,239^v3^insert_chatgpt"}} ] [.reference_item]
- *2* *3* [python编程入门之二:必备基础知识](https://blog.csdn.net/weixin_35503004/article/details/113987334)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insert_down28v1,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]