在Anypoint Studio中使用Dataweave将Excel转换为JSON [英] Converting Excel to JSON using Dataweave in anypoint studio
问题描述
需要在Anypoint Studio中使用Dataweave将Excel转换为JSON.
Need to transform Excel to JSON using Dataweave in Anypoint Studio.
Mule Datamapper支持直接将Excel文件转换为JSON,而在DataWeave中则不支持将Excel文件转换为JSON.
Mule Datamapper supports converting Excel files to JSON directly,where as in DataWeave it won't support Excel to JSON conversion.
在一个博客中,我发现使用POI库可以做到这一点,但这是一项复杂的工作.
In a blog i found that using POI libraries we can do this but it is a bit complex work.
还有其他替代方法吗?
推荐答案
Excel (XLSX files) support for DataWeave (the data transformation processor) has been released with the new Anypoint Studio 6.1.2 version w/3.8.2 Runtime.
请在此处查看如何使用它: Excel格式在DataWeave中
Please see how to use it here: Excel format in DataWeave
And the release notes below:
https://docs.mulesoft.com/release-notes/anypoint-studio-6.1-with-3.8.2-runtime-update-site-2-release-notes
这篇关于在Anypoint Studio中使用Dataweave将Excel转换为JSON的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!