本文概述
- Apache POI单元多样式示例
Apache POI单元多样式示例
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("srcmini.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 srcmini");
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);
}
}
}【apache poi单元多种风格】输出：
文章图片
推荐阅读
- apache poi excel单元格类型
- apache poi绘制边界
- apache poi excel单元格属性
- apache poi隐藏行
- apache poi excel文档标题
- apache poi excel字体
- apache poi合并单元
- apache poi excel单元格颜色
- apache poi excel单元格边界