学步园

import java.io.FileOutputStream;<br /> import org.apache.poi.hssf.usermodel.HSSFCell;<br /> import org.apache.poi.hssf.usermodel.HSSFCellStyle;<br /> import org.apache.poi.hssf.usermodel.HSSFFont;<br /> import org.apache.poi.hssf.usermodel.HSSFRichTextString;<br /> import org.apache.poi.hssf.usermodel.HSSFRow;<br /> import org.apache.poi.hssf.usermodel.HSSFSheet;<br /> import org.apache.poi.hssf.usermodel.HSSFWorkbook;<br /> import org.apache.poi.hssf.util.HSSFColor; </p> <p>/**<br /> *<br /> * @author hadeslee<br /> */<br /> public class Test2{ </p> <p> /** Creates a new instance of Test2 */<br /> public Test2() {<br /> }<br /> public static void main(String[] args)throws Exception {<br /> //声明一个工作薄<br /> HSSFWorkbook wb=new HSSFWorkbook();<br /> //生成一个表格<br /> HSSFSheet sheet=wb.createSheet("表格1");<br /> //生成一个列<br /> HSSFRow row=sheet.createRow(0);<br /> //生成一个样式<br /> HSSFCellStyle style=wb.createCellStyle();<br /> //设置这些样式<br /> style.setFillForegroundColor(HSSFColor.SKY_BLUE.index);<br /> style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);<br /> style.setBorderBottom(HSSFCellStyle.BORDER_THIN);<br /> style.setBorderLeft(HSSFCellStyle.BORDER_THIN);<br /> style.setBorderRight(HSSFCellStyle.BORDER_THIN);<br /> style.setBorderTop(HSSFCellStyle.BORDER_THIN);<br /> style.setAlignment(HSSFCellStyle.ALIGN_CENTER);<br /> //生成一个字体<br /> HSSFFont font=wb.createFont();<br /> font.setColor(HSSFColor.VIOLET.index);<br /> font.setFontHeightInPoints((short)16);<br /> font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);<br /> //把字体应用到当前的样式<br /> style.setFont(font);<br /> //填充单元格<br /> for(short i=0;i<5;i++){<br /> //声明一个单元格<br /> HSSFCell cell=row.createCell(i);<br /> //设置单元格的字符值<br /> cell.setCellValue(new HSSFRichTextString("第"+i+"列"));<br /> //设置单元格的样式<br /> cell.setCellStyle(style);<br /> }<br /> FileOutputStream fout=new FileOutputStream("我的第一个EXCEL.xls");<br /> //输出到文件<br /> wb.write(fout);<br /> fout.close();<br /> }<br /> }<br />