1.创建excel2007
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class Run {
public static void main(String[] args) throws IOException {
String fileName = "F://测试.xlsx";
File file=new File(fileName);
if(!file.exists())
file.createNewFile();
//输出流
OutputStream os = new FileOutputStream(file);
//工作区
XSSFWorkbook wb = new XSSFWorkbook();
//创建第一个sheet
XSSFSheet sheet= wb.createSheet("test");
//生成第一行
XSSFRow row = sheet.createRow(0);
//给这一行的第一列赋值
row.createCell(0).setCellValue("第一个单元格");
//给这一行的第一列赋值
row.createCell(1).setCellValue("第二个单元格");
//写文件
wb.write(os);
//关闭输出流
os.close();
}
}
2.读取excel2007
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class PoiReadExcel {
public static void main(String[] args) throws IOException {
String filePath = "F://测试.xlsx";
// 构造 XSSFWorkbook 对象,strPath 传入文件路径
InputStream inputStream=new FileInputStream(filePath);
XSSFWorkbook xwb = new XSSFWorkbook(inputStream);
// 读取第一章表格内容
XSSFSheet sheet = xwb.getSheetAt(0);
// 定义 row、cell
XSSFRow row;
String cell;
// 循环输出表格中的内容
for (int i = sheet.getFirstRowNum(); i < sheet.getPhysicalNumberOfRows(); i++) {
row = sheet.getRow(i);
for (int j = row.getFirstCellNum(); j < row.getPhysicalNumberOfCells(); j++) {
// 通过 row.getCell(j).toString() 获取单元格内容,
cell = row.getCell(j).toString();
System.out.print(cell + " ");
}
System.out.println("");
}
}
}
3.补充说明
poi包在我的资源里有