前期准备:
到官网下载pol的jar包:https://poi.apache.org/
导入项目所依赖的jar包(注:这几个一个都不能少,不然会报些奇怪的错)
代码:
使用POI读取Excel并输出
import java.io.IOException;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class demo1 {
public static void main(String[] args) throws IOException {
//获取工作簿对象
XSSFWorkbook workbook1 = new XSSFWorkbook("././POL/hello.xlsx");
//获取工作表
XSSFSheet sheet = workbook1.getSheetAt(0);
int lastRowNum = sheet.getLastRowNum();
for(int i=0;i<=lastRowNum;i++) {
XSSFRow row = sheet.getRow(i);
if(row!=null) {
short cellNum = row.getLastCellNum();
for (int j = 0; j <= cellNum; j++) {
XSSFCell cell = row.getCell(j);
if (cell!=null) {
String stringcelString = cell.getStringCellValue();
System.out.println(stringcelString);
}
}
}
}
workbook1.close();
}
}
运行效果:
使用POI创建Excel文件
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import java.io.FileOutputStream;
import java.io.IOException;
public class demo1 {
public static void main(String[] args) throws IOException {
//创建工作对象
XSSFWorkbook workbook = new XSSFWorkbook();
//创建工作表
XSSFSheet sheet = workbook.createSheet("demo1");
//创建行
XSSFRow row = sheet.createRow(0);
//创建单元格
row.createCell(0).setCellValue("hello");
//创建行
XSSFRow row1 = sheet.createRow(1);
//创建单元格
row1.createCell(0).setCellValue("world");
FileOutputStream outputStream = new FileOutputStream("././POL/hello.xlsx");
workbook.write(outputStream);
outputStream.flush();
//释放资源
outputStream.close();
workbook.close();
System.out.println("写入成功");
}
}
运行效果:
原文章在博主的网站也有:http://runsel.cn/
都看到这了给博主点个赞呗😁