Excel转Markdown (pandas)
环境
Python 3.7.4
conda 4.7.12
pandas==1.0.1
实现代码
import pandas as pd
if __name__ == "__main__":
excel = pd.read_excel('./Bilibili.xlsx')
with open("./Bilibili.md", "w", encoding='utf-8') as file:
excel.to_markdown(file)
输入数据
![](https://img-blog.csdnimg.cn/20201024220518527.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0NDg2NDM5,size_16,color_FFFFFF,t_70#pic_center)
输出结果
![](https://img-blog.csdnimg.cn/20201024220539508.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0NDg2NDM5,size_16,color_FFFFFF,t_70#pic_center)
最后
- 由于博主水平有限,不免有疏漏之处,欢迎读者随时批评指正,以免造成不必要的误解