回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我有一个JSON需要转换成Excel。
我正在使用Python3.8和xlsxwriter库。
下面是示例JSON</p>
<pre><code>{
"companyId": "123456",
"companyName": "Test",
"companyStatus": "ACTIVE",
"document": {
"employee": {
"employeeId": "EM1567",
"employeeLastName": "Test Last",
"employeeFirstName": "Test Fist"
},
"expenseEntry": [
{
"allocation": [
{
"allocationId": "03B249B3598",
"journal": [
{
"journalAccountCode": "888",
"journalPayee": "EMPL",
"journalPayer": "COMP",
"taxGuid": [
"51645A638114E"
]
},
{
"journalAccountCode": "999",
"journalPayee": "EMPL",
"journalPayer": "EMPL",
"taxGuid": [
"8114E51645A63"
]
},
],
"tax": [
{
"taxCode": "TAX123",
"taxSource": "SYST"
},
{
"taxCode": "TAX456",
"taxSource": "SYST"
}
]
}
],
"approvedAmount": 200.0,
"entryDate": "2020-12-10",
"entryId": "ENTRY9988"
}
],
"report": {
"currencyCode": "USD",
"reportCreationDate": "2020-12-10",
"reportId": "ACA849BBB",
"reportName": "Test Report",
"totalApprovedAmount": 200.0
}
},
"id": "c71b7d756f549"
}
</code></pre>
<p>我现在的代码是:
<a href="https://repl.it/@tonyiscoming/jsontoexcel" rel="nofollow noreferrer">https://repl.it/@tonyiscoming/jsontoexcel</a></p>
<p>我试过用熊猫</p>
<pre><code>import pandas as pd
df = pd.json_normalize(data, max_level=5)
df.to_excel('test.xlsx', index=False)
</code></pre>
<p>结果呢
<a href="https://i.stack.imgur.com/jfQSS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jfQSS.png" alt="enter image description here"/></a></p>
<p>我尝试使用json\u excel\u转换器</p>
<pre><code>from json_excel_converter import Converter
from json_excel_converter.xlsx import Writer
conv = Converter()
conv.convert(data, Writer(file='test.xlsx'))
</code></pre>
<p>结果呢
<a href="https://i.stack.imgur.com/UhNdu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UhNdu.png" alt="enter image description here"/></a></p>
<p>这是我的期望
<a href="https://i.stack.imgur.com/8Fbms.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8Fbms.png" alt="enter image description here"/></a></p>
<p>有人能帮我处理这个案子吗?非常感谢你</p>