java读取excel文件的两种方法

java读取excel文件的两种方法

本文实例为大家分享了android九宫格图片展示的具体代码，供大家参考，具体内容如下

方式一：

借用

package com.ij34.util;

/**

* @author Admin

* @date 创建时间：2017年8月29日 下午2:07:59

* @version 1.0

*@type_name myclass

*/

import java.io.File;

import java.io.IOException;

import jxl.Cell;

import jxl.Sheet;

import jxl.Workbook;

import jxl.read.biff.BiffException;

public class Test05 {

public static void main(String args[]){

File f=new File("table01.xls");

try {

Workbook book=Workbook.getWorkbook(f);//

Sheet sheet=book.getSheet(0); //获得第一个工作表对象

for(int i=0;i

for(int j=0;j

Cell cell=sheet.getCell(j, i); //获得单元格

System.out.print(cell.getContents()+" ");

}

System.out.print("\n");

}

} catch (BiffException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

方式二：

package com.ij34.util;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.IOException;

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

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

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.DateUtil;

import org.apache.poi.ss.usermodel.Row;

/**

* @author Admin

* @date 创建时间：2017年8月29日 下午4:01:06

* @version 1.0

*@type_name Test02

*读取xls

*/

public class Test02 {

public static void main(String[] args) throws FileNotFoundException, IOException {

File excelFile = new File("table01.xls");

HSSFWorkbook wb = new HSSFWorkWmRTLHZpbook(new FileInputStream(excelFile));

HSSFSheet sheet = wb.getSheetAt(0);

for (Row row : sheet) {

for (Cell cell : row) {

switch (cell.getCellType()) {

case Cell.CELL_TYPE_STRING://字符串

System.out.print(cell.getRichStringCellValue().getString());

System.out.print(" ");

break;

case Cell.CELL_TYPE_NUMERIC://数值与日期

if (DateUtil.isCellDateFormatted(cell)) {

System.out.print(String.valueOf(cell.getDateCellValue()));

} else {

System.out.print(celhttp://l.getNumericCellValue());

}

System.out.print(" ");

break;

case Cell.CELL_TYPE_BOOLEAN://boolean类型

System.out.print(cell.getBooleanCellValue());

System.out.print(" ");

break;

default:

}

}

System.out.println();

}

}

}WmRTLHZp

附jar包

for(int j=0;j

Cell cell=sheet.getCell(j, i); //获得单元格

System.out.print(cell.getContents()+" ");

}

System.out.print("\n");

}

} catch (BiffException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

方式二：

package com.ij34.util;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.IOException;

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

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

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.DateUtil;

import org.apache.poi.ss.usermodel.Row;

/**

* @author Admin

* @date 创建时间：2017年8月29日 下午4:01:06

* @version 1.0

*@type_name Test02

*读取xls

*/

public class Test02 {

public static void main(String[] args) throws FileNotFoundException, IOException {

File excelFile = new File("table01.xls");

HSSFWorkbook wb = new HSSFWorkWmRTLHZpbook(new FileInputStream(excelFile));

HSSFSheet sheet = wb.getSheetAt(0);

for (Row row : sheet) {

for (Cell cell : row) {

switch (cell.getCellType()) {

case Cell.CELL_TYPE_STRING://字符串

System.out.print(cell.getRichStringCellValue().getString());

System.out.print(" ");

break;

case Cell.CELL_TYPE_NUMERIC://数值与日期

if (DateUtil.isCellDateFormatted(cell)) {

System.out.print(String.valueOf(cell.getDateCellValue()));

} else {

System.out.print(celhttp://l.getNumericCellValue());

}

System.out.print(" ");

break;

case Cell.CELL_TYPE_BOOLEAN://boolean类型

System.out.print(cell.getBooleanCellValue());

System.out.print(" ");

break;

default:

}

}

System.out.println();

}

}

}WmRTLHZp

附jar包

Cell cell=sheet.getCell(j, i); //获得单元格

System.out.print(cell.getContents()+" ");

}

System.out.print("\n");

}

} catch (BiffException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

方式二：

package com.ij34.util;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.IOException;

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

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

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.DateUtil;

import org.apache.poi.ss.usermodel.Row;

/**

* @author Admin

* @date 创建时间：2017年8月29日 下午4:01:06

* @version 1.0

*@type_name Test02

*读取xls

*/

public class Test02 {

public static void main(String[] args) throws FileNotFoundException, IOException {

File excelFile = new File("table01.xls");

HSSFWorkbook wb = new HSSFWorkWmRTLHZpbook(new FileInputStream(excelFile));

HSSFSheet sheet = wb.getSheetAt(0);

for (Row row : sheet) {

for (Cell cell : row) {

switch (cell.getCellType()) {

case Cell.CELL_TYPE_STRING://字符串

System.out.print(cell.getRichStringCellValue().getString());

System.out.print(" ");

break;

case Cell.CELL_TYPE_NUMERIC://数值与日期

if (DateUtil.isCellDateFormatted(cell)) {

System.out.print(String.valueOf(cell.getDateCellValue()));

} else {

System.out.print(celhttp://l.getNumericCellValue());

}

System.out.print(" ");

break;

case Cell.CELL_TYPE_BOOLEAN://boolean类型

System.out.print(cell.getBooleanCellValue());

System.out.print(" ");

break;

default:

}

}

System.out.println();

}

}

}WmRTLHZp

附jar包

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。