Apache POI Excel Image

In Apache POI, images are part of the drawing support. To add an image just call createPicture() on the drawing patriarch. Apache POI supports the following image types:

It should be noted that any existing drawings may be erased once we add a new image to a sheet. Lets see an example.

Apache POI Excel Image Example

package poiexample;
import java.io.FileOutputStream;
import java.io.OutputStream;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
public class OutlineExample {
	public static void main(String[] args) {
		 try (OutputStream os = new FileOutputStream("Javatpoint.xls")) {
			 Workbook wb = new HSSFWorkbook();
			 Sheet sheet = wb.createSheet("Sheet");
			 sheet.groupRow( 4, 10 );
			 sheet.groupColumn( 2, 8 );
		     wb.write(os);
		 }catch(Exception e) {
			 System.out.println(e.getMessage());
		 }
	}
}

Output: