public class Excel {
public static void main(String[] args) {
try {
FileOutputStream out = new FileOutputStream("e:\\aaa.xls");//要输出的文件名字
HSSFWorkbook workBook = new HSSFWorkbook();
HSSFSheet mySheet = workBook.createSheet();//创建一个工作薄
workBook.setSheetName(0, "我的工作簿1",HSSFWorkbook.ENCODING_UTF_16);//设置名字（以及编码）
HSSFRow myRow = mySheet.createRow(0);//创建 并设置第一行
HSSFCellStyle style = workBook.createCellStyle();
style.setAlignment(HSSFCellStyle.ALIGN_CENTER);//对齐方式
style.setBorderBottom(HSSFCellStyle.BORDER_THIN);//上下左右边框
style.setBorderLeft(HSSFCellStyle.BORDER_THIN);
style.setBorderRight(HSSFCellStyle.BORDER_THIN);
style.setBorderTop(HSSFCellStyle.BORDER_THIN);
HSSFFont font = workBook.createFont();//设置字体样式
font.setFontName("宋体");
font.setFontHeightInPoints((short) 10);
font.setBoldweight(HSSFFont.BOLDWEIGHT_NORMAL);
style.setFont(font);
HSSFCell cell = myRow.createCell((short) 0);
cell.setCellStyle(style);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("姓名");
cell = myRow.createCell((short) 1);
cell.setCellStyle(style);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("性别");
cell = myRow.createCell((short) 2);
cell.setCellStyle(style);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("呵呵");
List<Users> list = new Excel().getUsers();//得到查询数据（模拟数据库查询）
for(int i = 1; i <= list.size(); i++){
myRow = mySheet.createRow(i);
Users user = list.get(i-1);
cell = myRow.createCell((short) 0);//创建单元格 先设置样式、编码，然后再置值。
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue(user.getName());
cell = myRow.createCell((short) 1);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue(user.getSex());
cell = myRow.createCell((short) 2);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue(user.getHobby());
}
workBook.write(out);//写出文件
out.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public List<Users> getUsers(){
List<Users> users = new ArrayList<Users>();
Users u = new Users();
u.setHobby("吃饭");
u.setName("张三");
u.setSex("男");
Users u1 = new Users();
u1.setHobby("睡觉");
u1.setName("李四");
u1.setSex("女");
users.add(u);
users.add(u1);
return users;
}
}
注：给cell(单元格)置值一定要在设置单元格各属性之后。
