废话不多说,直接上代码,一个简单的读取Excel数据,并且设置单元格数据类型
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
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 Test {
public static void main(String[] args) throws Exception {
String sFullPath = "D:/exportNoRetail.xls";
File file = new File(sFullPath);
//file.getAbsolutePath() 获取文件的全路径
//创建输入流读取Excel
InputStream finput = new FileInputStream(file.getAbsolutePath());
HSSFWorkbook wb = new HSSFWorkbook(finput);
HSSFSheet sheet = wb.getSheetAt(0);
finput.close();
HSSFRow row = null;//宣告一列
HSSFCell cell = null;//宣告一个储存格
for (int i = 1;i <= sheet.getLastRowNum();i++){
row = sheet.getRow(i);
for (int j = 0; j < 4; j++){
//设置单元格是字符串类型
//长度较大的数字时,导入数据放到缓存中会变成科学计数发的形式,可以将数字转换为字符串导入
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
cell = row.getCell(j);
System.out.print(cell+"**");
}
System.out.println();
}
}
}