I think NewtonSoft JSON is designed for the .NET platform and it is not there in Java. You may try some other options for your needs:
1). Directly import JSON data into Aspose.Cells’ object model via Workbook constructor and then save to file/streams via Workbook.Save method or other relevant overloads.
2). Import JSON data directly into Excel spreadsheet. See the data importing option in the document for your reference.
Now it’s not support setting json as data source of smart marker.
We have log it with id CELLSJAVA-45705. But it is not esay to implement it .
Now please use Java bean list or implement ICellsDataTable by yourself.
See document : ICellsDataTable
Thanks for the updates, how long should we expect to have this feature available?
To give you more context on what we are trying to achieve see below to see how you can help.
We are currently using the licensed Aspose.word for java product to generate pdf from word template files. We have a generic way where we can get data as json data source and we just create a template accordingly which allows us to have a generic way to keep generating documents. We are using the aspose for word placeholders to place that data in that template where we need.
Is there any way to achieve that so any excel I can generate just by creating the template and not updating the java code.
As we told you that currently Aspose.Cells for Java does not support JSON as datasource for markers. Since it is a complex feature, so it might take time. Once we have an ETA on it, we will let you know here.
Also, thanks for sharing your scenario. We will evaluate and get back to you soon.
Maybe you can check and confirm whether the data parsed and imported into cells is the expected data structure(apis mentioned by @amjad.sahi at this reply).
If it is not the expected data, we are afraid currently you have to parse the json data into proper object(ICellsDataTable or other java class) by yourself and then set it as the data source for smart markers. And because of the variety of json data and user’s requirements, maybe we cannot provide one unified way to parse the data to fit all user’s requirements.
If the imported data by those apis is the expected one, as an workaround we think you may import the json data into a temporary workbook in this way firstly, and then export data from cells by apis Cells.Export…(). At last you may set the exported data as data source for smart markers to process your templates.