Please create two workbooks manually using Ms-Excel.
One should be the input workbook and the other should be output workbook. We will investigate how to create an output workbook from input workbook programmatically using Aspose.Cells for Java and provide you a code example.
The reply which you have sent is not related to my question. Please check. Thanks.
Please find my requirement in the screen shot attached.
Worksheet sheet = book.getWorksheets().getSheet(0);
Chart chart = sheet.getCharts().getChart(0);
Legend legend = chart.getLegend();
Thank you. Could you please tell one more thing?
In your excel sheet which contains chart, the background is blank or white. Looks like all the cells in the sheet are merged. How can we do that?
Thank you very much.