Apache POI Styling Shapes

By default shapes are little plain. It's possible to apply different styles to the shapes however. The sorts of things that can currently be done are:

Change the fill color.
Make a shape with no fill color.
Change the thickness of the lines.
Change the style of the lines. Eg: dashed, dotted.
Change the line color.

Lets see an example in which shapes outer line are dotted.

Apache POI Styling Shapes Example

package poiexample;
import java.io.FileOutputStream;
import java.io.OutputStream;
import org.apache.poi.hssf.usermodel.HSSFClientAnchor;
import org.apache.poi.hssf.usermodel.HSSFPatriarch;
import org.apache.poi.hssf.usermodel.HSSFShape;
import org.apache.poi.hssf.usermodel.HSSFSimpleShape;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
public class ShapeStyleExample {
	public static void main(String[] args) {
		try (OutputStream fileOut = new FileOutputStream("Javatpoint.xls")) {
			Workbook wb = new HSSFWorkbook();
			Sheet sheet = wb.createSheet("Sheet");
			Row row = sheet.createRow(4); // Creating a row
			Cell cell = row.createCell(1); // Creating a cell
			cell.setCellValue("Hello, Javatpoint!");
			
			HSSFPatriarch patriarch = (HSSFPatriarch) sheet.createDrawingPatriarch();
			HSSFClientAnchor a = new HSSFClientAnchor( 0, 0, 1023, 255, (short) 1, 0, (short) 1, 0 );
			HSSFSimpleShape s = patriarch.createSimpleShape(a);
		    s.setShapeType(HSSFSimpleShape.OBJECT_TYPE_OVAL);
		    s.setLineStyleColor(10,10,10);
		    //s.setFillColor(90,10,200);
		    s.setLineWidth(HSSFShape.LINEWIDTH_ONE_PT * 3);
		    s.setLineStyle(HSSFShape.LINESTYLE_DOTSYS);
		    wb.write(fileOut);
		}catch(Exception e) {
			System.out.println(e.getMessage());
		}	
	}
}

Output: