JExcelAPI读取Excel的实例三

最新推荐文章于 2024-09-01 11:24:22 发布

pingsuccess

最新推荐文章于 2024-09-01 11:24:22 发布

阅读量595

点赞数

文章标签： excel string import c class file

JExcelAPI读取Excel的实例三

摘要: JexcelApi读取Excel的内容 //导入 package com.jExcelApi.test; import java.io.File;import java.io.IOException; import jxl.Cell;import jxl.CellType;import jxl.LabelCell;import jxl.NumberCell;import jxl.S ...

JexcelApi读取Excel的内容

//导入

package com.jExcelApi.test;

import java.io.File;
import java.io.IOException;

import jxl.Cell;
import jxl.CellType;
import jxl.LabelCell;
import jxl.NumberCell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;

/**
* JExcelApi读取Excel数据
* @author kanjingcai

*
*/
public class ReadExcel {

public static void main(String args[]){

  try {
   Workbook workBook =Workbook.getWorkbook(new File("D://myFile.xls"));

   Sheet sheet =workBook.getSheet(0);

   Cell c1 =sheet.getCell(0,2);
   Cell c2 =sheet.getCell(3,4);

  /* String s1 =c1.getContents();
   String s2 =c2.getContents();
   System.out.println(s1);
   System.out.println(s2);
  */
   String s =null;
   Double d =null;
   //判断c1单元格的值类型
   if(c1.getType() ==CellType.LABEL){

    LabelCell label =(LabelCell)c1;
    s =label.getString();
   }
   if(c2.getType() ==CellType.NUMBER){

    NumberCell nc =(NumberCell)c2;
    d =nc.getValue();
   }

//打印获取的内容

   System.out.println(s);
   System.out.println(d);

   workBook.close();
  } catch (BiffException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (IOException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
}
}