java读取sheet2_java读取Excel指定sheet页或全部sheet页数据(含2003和2007版本)

java读取Excel指定sheet页或全部sheet页数据(含2003和2007版本)

在http://download.csdn.net/detail/u010792467/8072015下载所需要的包

如果需要excel2003和excel2007文件可以去

http://download.csdn.net/detail/u010792467/8072009下载

package Excel;

import java.io.File;

import java.io.FileInputStream;

import java.io.IOException;

import java.io.InputStream;

import java.util.ArrayList;

import java.util.List;

import org.apache.poi.hssf.usermodel.HSSFCell;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

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.xssf.usermodel.XSSFWorkbook;

public class ImportExeclMain {

// 错误信息

private String errorInfo;

// 错误信息

private static int readSheet = 0;

private static boolean readSheetNum = false;

public static void main(String[] args) throws Exception {

// readSheetNum = true 开启自定义读取sheet页 默认false(读取全部sheet页)

readSheetNum = false;

// readSheet默认为0(读取第一页) 值为2时读取第二页

//当readSheetNum = false时 readSheet无作用

readSheet = 1;

ImportExeclMain poi = new ImportExeclMain();

// 2003

// List> list = po