Microsoft Excel is a powerful tool for data analysis, reporting, and visualization. However, there are times when you need to share Excel sheets in a format that doesn’t require the recipient to have MS Excel installed. On the other hand, as a developer, you can not embed the Excel workbooks or worksheets directly into your web or desktop applications. One common way in such cases is converting Excel sheets to images. In this blog post, we will explore how to convert Excel sheets to images in Java using a popular Java Excel library.
- Excel to Image Converter API
- Convert Excel Files to Image
- Additional Options for Excel to Image Conversion
- Get Free License
Java Excel to Image Converter API
In order to convert Excel XLSX or XLS files to image formats, we’ll use Aspose.Cells for Java API. It is a powerful spreadsheet manipulation API that provides high-quality conversion of worksheets into PNG, JPEG, BMP, and other popular image formats. Aspose.Cells for Java can be downloaded as JAR or installed using the following Maven configurations.
<repository>
<id>AsposeJavaAPI</id>
<name>Aspose Java API</name>
<url>https://repository.aspose.com/repo/</url>
</repository>
<dependency>
<groupId>com.aspose</groupId>
<artifactId>aspose-cells</artifactId>
<version>21.2</version>
</dependency>
Aspose.Cells for Java supports conversion of Excel files to the following image formats:
Convert Excel XLSX to Image in Java
The following are the steps along with API references to convert a worksheet into a PNG image.
- Load the Excel file using the Workbook class.
- Create an instance of ImageOrPrintOptions class.
- Set output image type using ImageOrPrintOptions.setImageType(ImageType) method.
- Get the worksheet you want to convert into a Worksheet object.
- Create a SheetRender object and initialize it with Worksheet and ImageOrPrintOptions objects.
- Convert the worksheet and save the image file using SheetRender.toImage(int, String) method.
The following code sample shows how to convert an Excel XLSX file to image using Java.
Excel File
Converted PNG
Additional Options for Excel to Image Conversion
Aspose.Cells for Java also provides additional options to customize XLSX to image conversion. For example, you can specify the style for gridlines, render one image per sheet, and so on. The ImageOrPrintOptions class is used to set these options. The following code sample shows how to use ImageOrPrintOptions class in Excel to image conversion.
Online Excel to Image Converter
We also provide a free Excel to image converter tool, which is based on Aspose.Cells for Java. It is a web-based tool and you can use it from any device only having an internet connection.
Get Free Excel to Image Converter
You can get a free temporary license and try converting Excel sheets to images without evaluation limitations.
Conclusion
In this article, you have learned how to convert Excel files to PNG, JPEG, BMP, or other image formats using Java. Furthermore, you have seen how to customize Excel to image conversion with additional options. We also introduced you to a free online Excel to image converter that can be used to convert XLS sheets to image formats.
You can explore more about Java spreadsheet manipulation API using documentation. In case you would have any questions or queries, contact us via our forum.