test.java

来自「留学生信息管理系统 我的工程实习的项目」· Java 代码 · 共 42 行

package Xl;

import java.io.File;
import java.io.FileOutputStream;
import java.io.OutputStream;

import jxl.Workbook;
import jxl.format.UnderlineStyle;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;


public class Test{
	public static void writeExcel(OutputStream os) throws Exception{
		WritableWorkbook wwb=Workbook.createWorkbook(os);
		WritableSheet ws=wwb.createSheet("TestSheet1", 0);
		Label labelC=new Label(0,0,"我爱中国");
		ws.addCell(labelC);
		WritableFont wfc=new WritableFont(WritableFont.ARIAL,20,
				WritableFont.BOLD,false,UnderlineStyle.NO_UNDERLINE,
				jxl.format.Colour.GREEN);
		WritableCellFormat wcfFC=new WritableCellFormat(wfc);
		wcfFC.setBackground(jxl.format.Colour.RED);
		labelC=new Label(6,0,"中国爱我",wcfFC);
		ws.addCell(labelC);
		
		wwb.write();
		wwb.close();
	}
	
	
	public static void main(String[] args)throws Exception{
		File f=new File("kk.xls");
		f.createNewFile();
		writeExcel(new FileOutputStream(f));
		
	}
}