这是我写的一个类 ,在控制台上打印出来
import java.io.File;
import java.io.FileInputStream;import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;public class ExcelReader {
private HSSFWorkbook workbook;
private File file;
private FileInputStream ins;
private HSSFSheet sheet;
private HSSFRow row;
private HSSFCell cell;
public void read(){
String path = "D:08年度变电站电能表数及电量.xls";
workbook = new HSSFWorkbook();
sheet = workbook.getSheetAt(0);
if(sheet==null){
System.out.println("null");
}
int i = sheet.getLastRowNum();
for(int k=0;k<i;i++){
HSSFRow row = sheet.getRow(k);
for(int j=0;j<row.getLastCellNum();j++){
cell = row.getCell((short)j);
System.out.println(cell.getStringCellValue());
}
}
}
public static void main(String []args){
ExcelReader read = new ExcelReader();
read.read();
}
}
import java.io.File;
import java.io.FileInputStream;import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;public class ExcelReader {
private HSSFWorkbook workbook;
private File file;
private FileInputStream ins;
private HSSFSheet sheet;
private HSSFRow row;
private HSSFCell cell;
public void read(){
String path = "D:08年度变电站电能表数及电量.xls";
workbook = new HSSFWorkbook();
sheet = workbook.getSheetAt(0);
if(sheet==null){
System.out.println("null");
}
int i = sheet.getLastRowNum();
for(int k=0;k<i;i++){
HSSFRow row = sheet.getRow(k);
for(int j=0;j<row.getLastCellNum();j++){
cell = row.getCell((short)j);
System.out.println(cell.getStringCellValue());
}
}
}
public static void main(String []args){
ExcelReader read = new ExcelReader();
read.read();
}
}
解决方案 »
- bonecp 连接池 循环到15次报错
- war包如何读外部properties文件
- 关于hibernate一级缓存的一个疑惑
- 熟悉hibernate下的HQL的高手帮帮忙啊!
- 如何实现formbean里的属性与select下来框的选项对应?
- 请高手指教:用Myeclipse新建的hibernate工程中,执行cfg.buildSessionFactory()总报错
- java中import问题
- J2EE中cr_ora_tb.sql之类的.sql文件是什么用处?
- 关于Java播放多媒体播放(JMF)的问题。
- 如何在局域网中实现邮件发送?
- jsp基础速成精华讲解 .docx
- xfire插件生产工具client在执行持久化数据操作时异常
String path = "D://08年度变电站电能表数及电量.xls";
HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(path));
HSSFSheet sheet = workbook.getSheetAt(0);
System.out.println(sheet);
HSSFCell cell;
HSSFRow row;
if (sheet == null) {
System.out.println("null");
}
int i = sheet.getLastRowNum();
for (int k = 0; k < i; k++) {
row = sheet.getRow((short) k);
for (int j = 0; j <= row.getLastCellNum(); j++) {
//cell也是从0开始的
cell = row.getCell((short) j);
System.out.print(cell.getRichStringCellValue());
}
System.out.println();
}