这是创建一个excel表名字是Student.xls
这个excel文件中有两个sheet,名字分别是学生表和教师表
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
public class ExcelExport {
public static void main(String[] args) {
// TODO Auto-generated method stub
//创建一个workbook
HSSFWorkbook workbook = new HSSFWorkbook();
//创建一个sheet页
HSSFSheet sheet = workbook.createSheet("学生表");
HSSFSheet sheet2 = workbook.createSheet("教师表");
//创建第一行
HSSFRow row = sheet.createRow(0);
//创建单元格
HSSFCell cell1 = row.createCell(0);
HSSFCell cell2 = row.createCell(1);
HSSFCell cell3 = row.createCell(2);
HSSFCell cell4 = row.createCell(3);
//设置表头
cell1.setCellValue("学号");
cell2.setCellValue("姓名");
cell3.setCellValue("性别");
cell4.setCellValue("年龄");
try {
FileOutputStream stream = new FileOutputStream("C:\\Users\\hermes\\Desktop\\excelexport\\student.xls");
workbook.write(stream);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println("导出成功");
}
}