POI读取03和07版本
来源:互联网 发布:大卫罗宾逊数据 编辑:程序博客网 时间:2024/06/04 00:29
package cn.itcast.test;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.util.CellRangeAddress;
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;
import org.junit.Test;
public class TestPOI2Excel {
@Test
public void testWrite03Excel(){
try {
//1.创建工作簿
HSSFWorkbook workbook = new HSSFWorkbook();
//2.创建工作表
HSSFSheet sheet = workbook.createSheet("hello world");
//3.创建行
HSSFRow row = sheet.createRow(3);
//4.创建单元格:(3.3)
HSSFCell cell = row.createCell(3);
cell.setCellValue("hello world");
//输出到硬盘
FileOutputStream outputStream = new FileOutputStream("E:\\itcast\\测试.xls");
workbook.write(outputStream);
workbook.close();
outputStream.close();
} catch (Exception e) {
e.printStackTrace();
}
}
@Test
public void testRead03Excel(){
try {
FileInputStream inputStream = new FileInputStream("E:\\itcast\\测试.xls");
//1.读取工作簿
HSSFWorkbook workbook = new HSSFWorkbook(inputStream);
//2.读取工作表
HSSFSheet sheet = workbook.getSheetAt(0);
//3.读取行
HSSFRow row = sheet.getRow(3);
//4.读取单元格:(3.3)
HSSFCell cell = row.getCell(3);
System.out.println(cell.getStringCellValue());
workbook.close();
inputStream.close();
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* xlsx 版本读取
*/
@Test
public void testRead07Excel(){
try {
FileInputStream inputStream = new FileInputStream("E:\\itcast\\测试.xls");
//1.读取工作簿
XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
//2.读取工作表
XSSFSheet sheet = workbook.getSheetAt(0);
//3.读取行
XSSFRow row = sheet.getRow(3);
//4.读取单元格:(3.3)
XSSFCell cell = row.getCell(3);
System.out.println(cell.getStringCellValue());
workbook.close();
inputStream.close();
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 利用文件名
* 自动判断 xls xlsx版本进行读取
*/
@Test
public void testRead03And07Excel(){
try {
String fileName = "E:\\itcast\\测试.xls";
if(fileName.matches("^.+\\.(?i)((xls)|(xlsx))$")){
boolean is03Excel = fileName.matches("^.+\\.(?i)(xls)$");
FileInputStream inputStream = new FileInputStream(fileName);
//1.读取工作簿
Workbook workbook = is03Excel?new HSSFWorkbook(inputStream):new XSSFWorkbook(inputStream);
//2.读取工作表
Sheet sheet = workbook.getSheetAt(0);
//3.读取行
Row row = sheet.getRow(3);
//4.读取单元格:(3.3)
Cell cell = row.getCell(3);
System.out.println(cell.getStringCellValue());
workbook.close();
inputStream.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 设置样式
*/
@Test
public void testExcelstyle(){
try {
//1.创建工作簿
HSSFWorkbook workbook = new HSSFWorkbook();
//1.1创建合并单元格对象
CellRangeAddress cellRangeAddress = new CellRangeAddress(2,2,2,4);
//1.2创建单元格样式
HSSFCellStyle style = workbook.createCellStyle();
style.setAlignment(HSSFCellStyle.ALIGN_CENTER);//水平居中
style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);//垂直居中
//1.3创建字体(加载于样式应用于单元格)
HSSFFont font = workbook.createFont();
font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
//font.setFontHeight((short)16);//设置字体大小(自己设置的高度/20)
font.setFontHeightInPoints((short) 16);
//加载字体到样式
style.setFont(font);
//单元格背景,需要设置背景填充模式(钻石模式:DIAMONDS HSSFCellStyle.SOLID_FOREGROUND(以前景色为准))
style.setFillPattern(HSSFCellStyle.DIAMONDS);
style.setFillBackgroundColor(HSSFColor.YELLOW.index);
style.setFillForegroundColor(HSSFColor.RED.index);
//2.创建工作表
HSSFSheet sheet = workbook.createSheet("hello world");
//2.1加载合并单元格对象
sheet.addMergedRegion(cellRangeAddress);
//3.创建行
HSSFRow row = sheet.createRow(2);
//4.创建单元格:(3.3)
HSSFCell cell = row.createCell(2);
cell.setCellStyle(style);
cell.setCellValue("hello world");
//输出到硬盘
FileOutputStream outputStream = new FileOutputStream("E:\\itcast\\测试.xls");
workbook.write(outputStream);
workbook.close();
outputStream.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
import java.io.FileInputStream;
import java.io.FileOutputStream;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.util.CellRangeAddress;
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;
import org.junit.Test;
public class TestPOI2Excel {
@Test
public void testWrite03Excel(){
try {
//1.创建工作簿
HSSFWorkbook workbook = new HSSFWorkbook();
//2.创建工作表
HSSFSheet sheet = workbook.createSheet("hello world");
//3.创建行
HSSFRow row = sheet.createRow(3);
//4.创建单元格:(3.3)
HSSFCell cell = row.createCell(3);
cell.setCellValue("hello world");
//输出到硬盘
FileOutputStream outputStream = new FileOutputStream("E:\\itcast\\测试.xls");
workbook.write(outputStream);
workbook.close();
outputStream.close();
} catch (Exception e) {
e.printStackTrace();
}
}
@Test
public void testRead03Excel(){
try {
FileInputStream inputStream = new FileInputStream("E:\\itcast\\测试.xls");
//1.读取工作簿
HSSFWorkbook workbook = new HSSFWorkbook(inputStream);
//2.读取工作表
HSSFSheet sheet = workbook.getSheetAt(0);
//3.读取行
HSSFRow row = sheet.getRow(3);
//4.读取单元格:(3.3)
HSSFCell cell = row.getCell(3);
System.out.println(cell.getStringCellValue());
workbook.close();
inputStream.close();
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* xlsx 版本读取
*/
@Test
public void testRead07Excel(){
try {
FileInputStream inputStream = new FileInputStream("E:\\itcast\\测试.xls");
//1.读取工作簿
XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
//2.读取工作表
XSSFSheet sheet = workbook.getSheetAt(0);
//3.读取行
XSSFRow row = sheet.getRow(3);
//4.读取单元格:(3.3)
XSSFCell cell = row.getCell(3);
System.out.println(cell.getStringCellValue());
workbook.close();
inputStream.close();
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 利用文件名
* 自动判断 xls xlsx版本进行读取
*/
@Test
public void testRead03And07Excel(){
try {
String fileName = "E:\\itcast\\测试.xls";
if(fileName.matches("^.+\\.(?i)((xls)|(xlsx))$")){
boolean is03Excel = fileName.matches("^.+\\.(?i)(xls)$");
FileInputStream inputStream = new FileInputStream(fileName);
//1.读取工作簿
Workbook workbook = is03Excel?new HSSFWorkbook(inputStream):new XSSFWorkbook(inputStream);
//2.读取工作表
Sheet sheet = workbook.getSheetAt(0);
//3.读取行
Row row = sheet.getRow(3);
//4.读取单元格:(3.3)
Cell cell = row.getCell(3);
System.out.println(cell.getStringCellValue());
workbook.close();
inputStream.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 设置样式
*/
@Test
public void testExcelstyle(){
try {
//1.创建工作簿
HSSFWorkbook workbook = new HSSFWorkbook();
//1.1创建合并单元格对象
CellRangeAddress cellRangeAddress = new CellRangeAddress(2,2,2,4);
//1.2创建单元格样式
HSSFCellStyle style = workbook.createCellStyle();
style.setAlignment(HSSFCellStyle.ALIGN_CENTER);//水平居中
style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);//垂直居中
//1.3创建字体(加载于样式应用于单元格)
HSSFFont font = workbook.createFont();
font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
//font.setFontHeight((short)16);//设置字体大小(自己设置的高度/20)
font.setFontHeightInPoints((short) 16);
//加载字体到样式
style.setFont(font);
//单元格背景,需要设置背景填充模式(钻石模式:DIAMONDS HSSFCellStyle.SOLID_FOREGROUND(以前景色为准))
style.setFillPattern(HSSFCellStyle.DIAMONDS);
style.setFillBackgroundColor(HSSFColor.YELLOW.index);
style.setFillForegroundColor(HSSFColor.RED.index);
//2.创建工作表
HSSFSheet sheet = workbook.createSheet("hello world");
//2.1加载合并单元格对象
sheet.addMergedRegion(cellRangeAddress);
//3.创建行
HSSFRow row = sheet.createRow(2);
//4.创建单元格:(3.3)
HSSFCell cell = row.createCell(2);
cell.setCellStyle(style);
cell.setCellValue("hello world");
//输出到硬盘
FileOutputStream outputStream = new FileOutputStream("E:\\itcast\\测试.xls");
workbook.write(outputStream);
workbook.close();
outputStream.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
1 0
- POI读取03和07版本
- poi 读取excel(03和07版本)--小结
- POI 读取 Excel 转 HTML 支持 03xls 和 07xlsx 版本 包含样式,03xls07xlsx
- POI读取Excel 03/07
- POI读取Excel 03/07
- apache poi读取excel(03版本之前)
- JAVA用POI读取和创建2003和2007版本Excel完美示例
- JAVA用POI读取和创建2003和2007版本Excel完美示例
- JAVA用POI读取和创建2003和2007版本Excel完美示例
- poi导入Excel,兼容03/07版本
- 利用POI读取老版本的word和excel以及txt文件的内容
- POI读取xls和xlsx
- POI读取和写入Excel
- POI读取xls和xlsx
- poi读取和写入excel2003
- POI读取Excel,分行读取和列读取
- poi读取高版本Excel表格的日期处理方式
- java poi 读取excel(兼容03,07)
- angular.js学习(1)--指令和控制器间的交互
- 1002-大数相加
- 虚函数和多态性1——动态绑定和静态绑定
- Gradle 安装以及查看jar文件本地的存储位置
- python挑战之总结
- POI读取03和07版本
- 数学建模中的Matlab模板程序
- 2016北京网络赛 NTT板子(附上素数表)
- 菜鸟练习华为级考题——明明的随机数
- HDU 5920 Ugly Problem CCPC长春赛区 贪心
- 条件变量的虚假唤醒(spurious wakeups)问题
- 自动轮播图js源代码
- ajax 入门案例
- oracle高级 列表分区 复合分区