Apache POI 插件读写Excel

vivion34

//图片 jar 包如下,下载地址我就不多说了,百度一下有很多
//这里有 poi 对 excel 的读写操作希望能帮到大家!

 
package com.poi.excel;
import java.io.IOException;
import java.io.InputStream;
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;
/**
* 读取 excel
* @author LGF
*
*/
public class ReadExcel {
public static void main(String[] args) {
ReadExcel read = new ReadExcel();
try {
read.read("ORACLE.xlsx");
} catch (IOException e) {
e.printStackTrace();
}
}
/**
* 读取 excel 文件
* @param name 文件名称
* @throws IOException
*/
public void read(String name) throws IOException{
//获取文件流
InputStream input = getInputStream(name);
//构造 XSSFWorkbook 对象传入 文件流
XSSFWorkbook wb = new XSSFWorkbook(input);
//获取 excel中第一个表
XSSFSheet hs = wb.getSheetAt(0);
//获取第一个表的总行数
int count = hs.getLastRowNum();
//获取excel中有几个表
int sheetCount = wb.getNumberOfSheets();
//简单打印一下
System.out.println("sheet1 count:" + count);
System.out.println("sheetCount:" + sheetCount);
//循环遍历第一个表中的数据
for (int i = 0; i <= count; i++) {
//获取第 i 行对象
XSSFRow row = hs.getRow(i);
//获取第 i 行对象中的总列数
int column = row.getLastCellNum();
//循环遍历取值
for (int j = 0; j <column; j++) {
XSSFCell cell = row.getCell(j);
String value = cell.getStringCellValue();
if(value.trim().isEmpty())continue;
System.out.print(value + "|");
}
System.out.println("\n------------------------------------------");
}
//最后释放资源
wb.close();
input.close();
}
/**
* 获取 class path 中的文件流
* @param name 名称
* @return InputStream
*/
public InputStream getInputStream(String name){
return Thread.currentThread().getContextClassLoader().getResourceAsStream(name);
}
}

package com.poi.excel;
import java.io.File;
import java.io.FileOutputStream;
import java.io.OutputStream;
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;
/**
*
* @author LGF 2015-01-03
* 创建excel文件
*/
public class WriterExcel {
@SuppressWarnings("resource")
public static void main(String[] args) throws Exception {
//需要一个文件输入流
OutputStream out = new FileOutputStream(new File("src/test.xlsx"));
//创建 XSSFWorkbook 对象
XSSFWorkbook wb = new XSSFWorkbook();
//创建 excel中的表
XSSFSheet sheet = wb.createSheet("test");
//循环添加行,列
for (int i = 0; i < 3; i++) {
XSSFRow row = sheet.createRow(i);
for (int j = 0; j < 5; j++) {
XSSFCell cell = row.createCell(j);
String value ="date:2012-03-0"+j;
cell.setCellValue(value);
sheet.autoSizeColumn(j);
}
}
//释放资源
wb.write(out);
out.close();
System.out.println("success");
}
}