CODEWITHSUNDEEP
mulemule-studioanypoint-studio
Dwight Cavalcanti
Dwight Cavalcanti

Reputation: 1

XLS to CSV using Mulesoft

I have an XLS file, and i need to convert the data of it for CSV. The problem is: Seems like the newer versions of the Mule-studio does not support Excel files.

What's the better way to handle the data inside of it, since the dataMapper is not available anymore (and it used to work with xls files...)

Thanks in advance.

Upvotes: 0

Views: 1796

Answers (2)

FerMelon
FerMelon

Reputation: 93

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.

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

Upvotes: 1

Niranjan Dash
Niranjan Dash

Reputation: 16

What I suggest is to Convert the excel file to JSON through java code and then convert the JSON to CSV. I know this is a work around but its limitation of mule too.

Upvotes: 0

Related Questions