擅长:python、mysql、java
<p>请检查以下解决方案</p>
<p><a href="https://i.stack.imgur.com/VlaNV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VlaNV.png" alt="enter image description here"/></a></p>
<p><a href="https://i.stack.imgur.com/OtO2A.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OtO2A.png" alt="enter image description here"/></a></p>
<p>希望这就是你想要的</p>
<pre><code>ss = [{'TABSCHEMA': 'OP', 'TABNAME': 'T1', 'COLNO': 9, 'COLNAME': 'ACD'},
{'TABSCHEMA': 'OPE', 'TABNAME': 'T1', 'COLNO': 8, 'COLNAME': 'AC_CD'},
{'TABSCHEMA': 'OPEW', 'TABNAME': 'T2', 'COLNO': 7, 'COLNAME': 'AC_ID'}]
import json
import pandas as pd
df = pd.io.json.json_normalize(ss)
df.to_excel(‘excel_filename.xlsx’)
</code></pre>
<p>更新输入后:</p>
<p><a href="https://i.stack.imgur.com/v7iWX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/v7iWX.png" alt="enter image description here"/></a></p>