Aspose.Cell for java Using SmartMarkers And Json DataSource

@abdullah240
Please check the attached
23.12.1.zip (7.5 KB)

generated by inner hot fix 23.12.1.
We will include this fix into next release version 24.1.

Hi @simon.zhao,

When will this fix be released?

We want to test it out to see if it fits our requirements as soon as possible.

Thanks

@abdullah240,

We plan to release Aspose.Cells v24.1 in the second week of January, 2024 (The exact date is not final as releases are published once ready). You will be notified when the next version is published.

The issues you have found earlier (filed as CELLSJAVA-45705) have been fixed in Aspose.Cells for Java 24.1.

Hi Aspose Team,

Thanks for the update. We are able to generate an excel file using Json data source using smart markers.

We have two questions.

  1. We are able to read array of objects, but how can we read nested objects such as the below using smart markers?

{
“object”: {
“object1”: {
“name”: “John Doe”
}
}
}

  1. We would like to know how can we generate charts, graphs or tables using smart markers and json data source.

Thanks

@abdullah240
Thanks for your feedback and details. We will evaluate your issue further and get back to you soon.

We have added a new issue(CELLSJAVA-45824) for this qustion, we will check it soon.

@abdullah240
Please create chart in Excel and the data source of chart bases on smart makers. See attached tempate file and codes :
chart.zip (11.4 KB)

We have supported the feature. The enhancement/fix will be included in an upcoming release (Aspose.Cells v24.2) that we plan to release in the first half of February 2024. You will be notified when the next version is released.

The issues you have found earlier (filed as CELLSJAVA-45824) have been fixed in Aspose.Cells for Java 24.2.

Hi Aspose Team,

what is the different between the free version vs licensed version of Aspose.cell for Java?

@abdullah240,

Please note, a free version can simply become licensed version (as source Download/library is the same) when you use a valid license and set in code prior using any other APIs of the component. Here are some key differences between the free version and the licensed version:

  1. The free version may impose restrictions on the number of files you can process (read/write) within a certain time period of your application life cycle. The licensed version typically removes these limitations, allowing you to work to process unlimited files without restrictions.
  2. The free version may have limited features compared to the licensed version. The licensed version do not pose any restrictions regarding features or other capabilities.
  3. With a licensed version, you usually get access to technical support from the Aspose team, including assistance with any issues you encounter and guidance on how to use the API effectively. Moreover, you can avail/receive regular updates and bug fixes to ensure compatibility with the latest Java versions and Excel file formats. These benefits may not be available with the free version.
  4. The free version may have more restrictive licensing terms compared to the licensed version. For example, the free version might require you to display/print a watermark on every output files or include attribution to Aspose.Cells in your application.
  5. While the free version may be suitable for testing purpose only, the licensed version is typically required for commercial use. This ensures compliance with licensing agreements and provides access to additional features and support tailored for enterprise applications.

Please see the documents on Evaluations and Licensing for your complete reference.

Hope, this helps a bit.