Import and export of charts

[anthony...@googlemail.com]

Please is it possible to import and export charts created in excel into java using jexcel? Also is all excel charts functionalities available within jexcel?

[nataliya.rybynok]

Hello,

A sample that demonstrates how to create and export Excel charts programmatically is attached to this reply. This sample is also provided as a part of the JExcel distribution archive.

In general, most of the charts functionality that is available in Excel VBA is expected to work in JExcel. However, there is no high-level API for this case, so you'll have to use the native peers. Native peers can be considered as more direct Java wrappers for the Excel object model  — that is the same object model that is available in VBA.

Please let us know if you have any further questions about this functionality.

Best regards.