Free Support Forum -

Convert just a part of a Worksheet to image

I need to convert to image just a part of a worksheet, from A1 to C25 so I can get in the same image two different charts. I need a PNG of what is marked in red in the following picture. Unfortunately Chart.toimage() just retrieves a small part of the worksheet. How do I set the area that I want to copy?

Thank you

Jorge Obregón


Please try this code using the latest version:

<a href="">Aspose.Cells for Java v7.0.1.5</a>
<br><br><font size="2" face="Courier New"><font color="#FF0000"><BLOCKQUOTE><div>Please also make sure, you have all the <b>additional java libraries</b> required by <b>Aspose.Cells for Java V7.0.0 and later</b>. You can download them from the major version: <a id="ctl00_ctl01_bcr_ctl00___ctl00_Entrylisting1___Entries_ctl01_Name" href="">Aspose.Cells for Java 7.0.1</a><br><br>Or you can download them separately from this link: 

<a href="">Additional Java Libraries For V7.0.0 and Later</a></div></BLOCKQUOTE></font> <br></font><br>It will convert your desired range into image.<br><br><b>Java</b><br><div class="csharpcode">

String path = “F:\Shak-Data-RW\Downloads\Report_2011-9-2_10-5-28.xlsx”;

Workbook workbook = new Workbook(path);

Worksheet worksheet = workbook.getWorksheets().get(0);

//Apply different Image / Print options.

ImageOrPrintOptions options = new ImageOrPrintOptions();


SheetRender sr = new SheetRender(worksheet, options);

sr.toImage(0, path + “.out.jpeg”);