java获取excel指定行内容
来源:互联网 发布:linux常用命令 cat 编辑:程序博客网 时间:2024/06/06 01:35
package HolidaySummaryReport;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.Arrays;
import java.util.Comparator;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellValue;
import org.apache.poi.ss.usermodel.FormulaEvaluator;
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.xssf.usermodel.XSSFWorkbook;
//可适用.xls/ .xlsx
public class readExcel {
@SuppressWarnings("resource")
public static Workbook openWorkbook(String fileName)
throws IOException {
InputStream in = new FileInputStream(fileName); // 创建输入流
Workbook wb = null;
if (fileName.toLowerCase().endsWith(".xlsx")) {//toLowerCase 区分大小写
wb = new XSSFWorkbook(in);// Excel 2007
} else {
wb = (Workbook) new HSSFWorkbook(in);// Excel 2003
}
return wb;
}
public static void poloRead(String fileName, int sheetIndex) {
try {
Workbook wb = openWorkbook(fileName);
Sheet sheet = wb.getSheetAt(sheetIndex);
int colNumCount = sheet.getRow(0).getPhysicalNumberOfCells();// 有多少列
FormulaEvaluator evaluator = wb.getCreationHelper()
.createFormulaEvaluator();// 获取表格公式后的值
for (int i = 0; i < 1; i++) {
for (int j = 0; j < colNumCount; j++) {
Row row = sheet.getRow(i);//行
Cell cell = row.getCell((short) j);//列
CellValue cellValue = evaluator.evaluate(cell);// 获表格公式计算后的值
if (cellValue != null) {
switch (cellValue.getCellType()) {// 判断值类型
case Cell.CELL_TYPE_STRING:
String Stringvalue = cell.getStringCellValue();
System.out.println(Stringvalue + " ");//输出结果
break;
case Cell.CELL_TYPE_NUMERIC:
Double Doublevalue = cellValue.getNumberValue();
System.out.println(Doublevalue + " ");
break;
}
}
}
System.out.print("------------------------");
}
for (int i = 10; i < 11; i++) {
for (int j = 0; j < colNumCount; j++) {
Row row = sheet.getRow(i);
Cell cell = row.getCell((short) j);
CellValue cellValue = evaluator.evaluate(cell);// 获表格公式计算后的值
if (cellValue != null) {
switch (cellValue.getCellType()) {// 判断值类型
case Cell.CELL_TYPE_STRING:
String Stringvalue = cell.getStringCellValue();
System.out.println(Stringvalue + " ");
break;
case Cell.CELL_TYPE_NUMERIC:
Double Doublevalue = cellValue.getNumberValue();
System.out.println(Doublevalue + " ");
break;
}
}
}
System.out.print("------------------------");
}
for (int i = 14; i < 15; i++) {
for (int j = 0; j < colNumCount; j++) {
Row row = sheet.getRow(i);
Cell cell = row.getCell((short) j);
CellValue cellValue = evaluator.evaluate(cell);// 获表格公式计算后的值
if (cellValue != null) {
switch (cellValue.getCellType()) {// 判断值类型
case Cell.CELL_TYPE_STRING:
String Stringvalue = cell.getStringCellValue();
System.out.println(Stringvalue + " ");
break;
case Cell.CELL_TYPE_NUMERIC:
Double Doublevalue = cellValue.getNumberValue();
System.out.println(Doublevalue + " ");
break;
}
}
}
System.out.print("------------------------");
}
for (int i = 15; i < 16; i++) {
for (int j = 0; j < colNumCount; j++) {
Row row = sheet.getRow(i);
Cell cell = row.getCell((short) j);
CellValue cellValue = evaluator.evaluate(cell);// 获表格公式计算后的值
if (cellValue != null) {
switch (cellValue.getCellType()) {// 判断值类型
case Cell.CELL_TYPE_STRING:
String Stringvalue = cell.getStringCellValue();
System.out.println(Stringvalue + " ");
break;
case Cell.CELL_TYPE_NUMERIC:
Double Doublevalue = cellValue.getNumberValue();
System.out.println(Doublevalue + " ");
break;
}
}
}
}
wb.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public static void readpolo(){
File path = new File("D:\\User");
File[] files = path.listFiles();// 列出该目录下所有文件和文件夹
Arrays.sort(files, new Comparator<File>() {// 按照文件最后修改日期倒序排序
@Override
public int compare(File file1, File file2) {
return (int) (file2.lastModified() - file1.lastModified());
}
});
// 取出第一个(即最新修改的)文件,打印文件名
}
static public void main(String[] args){
readpolo();
}
}
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.Arrays;
import java.util.Comparator;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellValue;
import org.apache.poi.ss.usermodel.FormulaEvaluator;
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.xssf.usermodel.XSSFWorkbook;
//可适用.xls/ .xlsx
public class readExcel {
@SuppressWarnings("resource")
public static Workbook openWorkbook(String fileName)
throws IOException {
InputStream in = new FileInputStream(fileName); // 创建输入流
Workbook wb = null;
if (fileName.toLowerCase().endsWith(".xlsx")) {//toLowerCase 区分大小写
wb = new XSSFWorkbook(in);// Excel 2007
} else {
wb = (Workbook) new HSSFWorkbook(in);// Excel 2003
}
return wb;
}
public static void poloRead(String fileName, int sheetIndex) {
try {
Workbook wb = openWorkbook(fileName);
Sheet sheet = wb.getSheetAt(sheetIndex);
int colNumCount = sheet.getRow(0).getPhysicalNumberOfCells();// 有多少列
FormulaEvaluator evaluator = wb.getCreationHelper()
.createFormulaEvaluator();// 获取表格公式后的值
for (int i = 0; i < 1; i++) {
for (int j = 0; j < colNumCount; j++) {
Row row = sheet.getRow(i);//行
Cell cell = row.getCell((short) j);//列
CellValue cellValue = evaluator.evaluate(cell);// 获表格公式计算后的值
if (cellValue != null) {
switch (cellValue.getCellType()) {// 判断值类型
case Cell.CELL_TYPE_STRING:
String Stringvalue = cell.getStringCellValue();
System.out.println(Stringvalue + " ");//输出结果
break;
case Cell.CELL_TYPE_NUMERIC:
Double Doublevalue = cellValue.getNumberValue();
System.out.println(Doublevalue + " ");
break;
}
}
}
System.out.print("------------------------");
}
for (int i = 10; i < 11; i++) {
for (int j = 0; j < colNumCount; j++) {
Row row = sheet.getRow(i);
Cell cell = row.getCell((short) j);
CellValue cellValue = evaluator.evaluate(cell);// 获表格公式计算后的值
if (cellValue != null) {
switch (cellValue.getCellType()) {// 判断值类型
case Cell.CELL_TYPE_STRING:
String Stringvalue = cell.getStringCellValue();
System.out.println(Stringvalue + " ");
break;
case Cell.CELL_TYPE_NUMERIC:
Double Doublevalue = cellValue.getNumberValue();
System.out.println(Doublevalue + " ");
break;
}
}
}
System.out.print("------------------------");
}
for (int i = 14; i < 15; i++) {
for (int j = 0; j < colNumCount; j++) {
Row row = sheet.getRow(i);
Cell cell = row.getCell((short) j);
CellValue cellValue = evaluator.evaluate(cell);// 获表格公式计算后的值
if (cellValue != null) {
switch (cellValue.getCellType()) {// 判断值类型
case Cell.CELL_TYPE_STRING:
String Stringvalue = cell.getStringCellValue();
System.out.println(Stringvalue + " ");
break;
case Cell.CELL_TYPE_NUMERIC:
Double Doublevalue = cellValue.getNumberValue();
System.out.println(Doublevalue + " ");
break;
}
}
}
System.out.print("------------------------");
}
for (int i = 15; i < 16; i++) {
for (int j = 0; j < colNumCount; j++) {
Row row = sheet.getRow(i);
Cell cell = row.getCell((short) j);
CellValue cellValue = evaluator.evaluate(cell);// 获表格公式计算后的值
if (cellValue != null) {
switch (cellValue.getCellType()) {// 判断值类型
case Cell.CELL_TYPE_STRING:
String Stringvalue = cell.getStringCellValue();
System.out.println(Stringvalue + " ");
break;
case Cell.CELL_TYPE_NUMERIC:
Double Doublevalue = cellValue.getNumberValue();
System.out.println(Doublevalue + " ");
break;
}
}
}
}
wb.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public static void readpolo(){
File path = new File("D:\\User");
File[] files = path.listFiles();// 列出该目录下所有文件和文件夹
Arrays.sort(files, new Comparator<File>() {// 按照文件最后修改日期倒序排序
@Override
public int compare(File file1, File file2) {
return (int) (file2.lastModified() - file1.lastModified());
}
});
// 取出第一个(即最新修改的)文件,打印文件名
String file = files[0].getName();
//以上这几行是在一个文件夹里获取最新报表,可不要
// System.out.println(file);String fileName = "D://User//" + file;
//String fileName="D://User//user.xlsx";//不要上面自动获取文件夹里最新报表就是自己指定
poloRead(fileName, 4);}
static public void main(String[] args){
readpolo();
}
}
阅读全文
1 0
- java获取excel指定行内容
- java获取Excel单元格内容
- 用java 获取指定url 网站内容
- java获取url网页指定内容
- 使用JAVA获取指定网页内容
- Python 获取文件指定行内容
- 获取指定网页内容
- Tree Widget控件获取指定行指定列的内容
- Java 抓取网页内容,获取指定服务器IP
- Java 抓取网页内容,获取指定服务器IP
- java 正则表达式获取指定两个字符串之间内容
- java 正则表达式获取指定两个字符串之间内容
- java 使用jxl API 获取 Excel表格中的内容
- java获取excel里面的内容(点提取)
- java 读取文件指定行的内容
- C#获取网页指定内容
- 获取指定网站的内容
- shell 精确获取指定内容
- BufferedOutputStream 源码的个人理解
- pachi源码阅读
- OWASP 10大安全问题
- 4.EditText控件的应用实例:结合TableLayout
- Linux IO模式及 select、poll、epoll详解
- java获取excel指定行内容
- C#回顾学习笔记十一:while循环语句
- spring scope prototype与singleton区别
- python 调用 C/C++
- js增删改查列表
- 关于查询两种张表两列和并求两列和的和
- centOS7.2快速安装mysql
- Spark Streaming 学习笔记
- 关于HOSTS设置不生效的解决小方法