Apache POI Styling Shapes

by Online Tutorials Library July 14, 2022

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(“tutoraspire.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, tutoraspire!”);    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:

Next TopicApache POI Comment

Apache POI Styling Shapes

Apache POI Styling Shapes

Apache POI Styling Shapes Example

Apache Cordova Tutorial

Updating the Document Using XML in Apache Solr

You may also like