1.写出Excel
代码:
import java.io.File;
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 POIWriteExcel {
public static void main(String[] args) throws IOException {
// 创建表头数据
String[] title = { "id", "name", "age", "sex" };
// 创建工作溥
HSSFWorkbook workbook = new HSSFWorkbook();
// 创建工作表(表名:test01)
HSSFSheet sheet = workbook.createSheet("test01");
// 创建第一行
HSSFRow row = sheet.createRow(0);
// 写入数据(表头)
for (int i = 0; i < title.length; i++) {
// 创建单元格
HSSFCell cell = row.createCell(i);
// 写入数据
cell.setCellValue(title[i]);
}
// 添加数据
HSSFRow row2 = null;
HSSFCell cell = null;
for (int i = 1; i < 10; i++) {
row2