关注我们

POI Excel - 多种样式

要将多种样式和文本格式应用于单元，Apache POI提供了CellStyle函数。无涯教程可以为工作簿创建CellStyle，然后将文本样式应用于单元格。

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("Learnfk.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 javatpoint");
		  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);
		}
	}
}