Question

java后端将json数据导入导出成Excel格式

{"controls":[{"id":"CONTROL387A96F9","name":"战略先导","type":"label","left":0,"top":32,"width":100,"height":46,"drag":true,"resize":true},{"id":"CONTROLDDE04C55","name":"业务主线","type":"label","left":0,"top":123,"width":100,"height":48,"drag":true,"resize":true},{"id":"CONTROL1B29D622","name":"企业管理","type":"label","left":0,"top":222,"width":100,"height":298,"drag":true,"resize":true},{"id":"CONTROLD0992E81","name":"1.0战略发展","type":"processCourse1","left":127,"top":33,"width":262,"height":45,"drag":true,"resize":true,"img":"processCourse1.png"},{"id":"CONTROL51EB9A5B","name":"2.0资本运营","type":"processCourse1","left":414,"top":34,"width":329,"height":43,"drag":true,"resize":true,"img":"processCourse1.png"},{"id":"CONTROLB66D9186","name":"3.0市场","type":"business1","left":130.296875,"top":124,"width":100,"height":50,"drag":true,"resize":true,"img":"business1.png"},{"id":"CONTROL3DFDE37D","name":"4.0销售","type":"business2","left":238.296875,"top":123,"width":100,"height":50,"drag":true,"resize":true,"img":"business2.png"},{"id":"CONTROLA7541E26","name":"7.0采购","type":"business2","left":544.296875,"top":119,"width":100,"height":50,"drag":true,"resize":true,"img":"business2.png"},{"id":"CONTROLC183F7FA","name":"6.0研发","type":"business2","left":440.296875,"top":121,"width":100,"height":50,"drag":true,"resize":true,"img":"business2.png"},{"id":"CONTROL4F5DB666","name":"5.0服务","type":"business2","left":341.296875,"top":122,"width":100,"height":50,"drag":true,"resize":true,"img":"business2.png"},{"id":"CONTROLE483664C","name":"8.0生产","type":"business3","left":637.296875,"top":118,"width":100,"height":50,"drag":true,"resize":true,"img":"business3.png"},{"id":"CONTROL239EB4C8","name":"9.0产品管理","type":"processCourse1","left":148,"top":224,"width":398,"height":43,"drag":true,"resize":true,"img":"processCourse1.png"},{"id":"CONTROLA1FEC18B","name":"10.0行政管理","type":"processCourse1","left":148,"top":291,"width":391,"height":43,"drag":true,"resize":true,"img":"processCourse1.png"},{"id":"CONTROL3E1E9A35","name":"11.0财政管理","type":"processCourse1","left":146,"top":363,"width":388,"height":43,"drag":true,"resize":true,"img":"processCourse1.png"},{"id":"CONTROL0AF2E164","name":"12.0人力资源","type":"processCourse1","left":145,"top":453,"width":387,"height":45,"drag":true,"resize":true,"img":"processCourse1.png"}],"lines":[],"swimlanes":[]}

这个是json数据，我想导出和导入excel格式

Answer 1

你用第三方的exceljar包 和第三方的 json jar一起用不就可以转换了？

追问

不明白，不会用