Apache POI Cell Multiple Styles

by Online Tutorials Library July 14, 2022

Apache POI Cell Multiple Styles

To apply multiple styles and text formatting to a cell, Apache POI provides CellStyle feature. We can create CellStyle for the workbook and then apply text styling to the cell.

Apache POI Cell Multiple Style Example

  package poiexample;  import java.io.FileOutputStream;  import java.io.OutputStream;  import org.apache.poi.ss.usermodel.Row;  import org.apache.poi.ss.usermodel.Sheet;  import org.apache.poi.ss.usermodel.Workbook;  import org.apache.poi.xssf.usermodel.XSSFCell;  import org.apache.poi.xssf.usermodel.XSSFColor;  import org.apache.poi.xssf.usermodel.XSSFFont;  import org.apache.poi.xssf.usermodel.XSSFRichTextString;  import org.apache.poi.xssf.usermodel.XSSFWorkbook;  public class MultipleStylesExample {  public static void main(String[] args) {  try (OutputStream os = new FileOutputStream(“tutoraspire.xls”)) {   Workbook wb = new XSSFWorkbook();   Sheet sheet = wb.createSheet(“Sheet”);   Row row = sheet.createRow(2);   XSSFFont font1 = (XSSFFont) wb.createFont();   XSSFFont font2 = (XSSFFont) wb.createFont();   XSSFFont font3 = (XSSFFont) wb.createFont();   XSSFCell hssfCell = (XSSFCell) row.createCell(2);    XSSFRichTextString richString = new XSSFRichTextString( “Hello, World!” );    richString.applyFont( 0, 6, font1 );    richString.applyFont( 6, 13, font2 );    hssfCell.setCellValue( richString );    XSSFCell cell = (XSSFCell) row.createCell(1);    XSSFRichTextString rt = new XSSFRichTextString(“This is tutoraspire”);    font1.setBold(true);    font1.setColor(new XSSFColor(new java.awt.Color(255, 0, 0)));    rt.applyFont(0, 12, font1);    font2.setItalic(true);    font2.setUnderline(XSSFFont.U_DOUBLE);    font2.setColor(new XSSFColor(new java.awt.Color(0, 255, 0)));    rt.applyFont(12, 18, font2);    font3.setColor(new XSSFColor(new java.awt.Color(0, 0, 255)));    rt.append(” Learn New Technology Easily”, font3);    cell.setCellValue(rt);    wb.write(os);  }catch(Exception e) {  System.out.println(e);  }  }  }  

Output:

Apache POI Cell Multiple Styles

Next TopicApache POI Excel Cell Type

Apache POI Cell Multiple Styles

Apache POI Cell Multiple Styles

Apache POI Cell Multiple Style Example

Apache Cordova Tutorial

Updating the Document Using XML in Apache Solr

You may also like