JavaPOI读取excel支持xls、xlsx

JavaPOI读取excel支持xls、xlsx
Java POI读取excel 支持xls、xlsx
import java.io.File;import java.io.FileInputStream;import java .util.List;
import ermodel.HSSFPicture;import o ermodel.HSSFPictureData;import org.apach ermodel.HSSFShape;import er model.HSSFSheet;import ermodel.HSSFW orkbook;import ermodel.Cell;import org.ap ermodel.DateUtil;import ermo del.Row;
public final class T estImportExcel {
public static void main(String[] args) throws Exception {
File excelFile = new File("test.xls"); HSSFWorkbook wb = new HSSFWorkbook(new FileInputStream(excelFile)); HSS FSheet sheet = wb.getSheetAt(0);
for (Row row : sheet) { for (Cell cell : row) { s witch (cell.getCellType()) { case Cell.CELL_TYPE_STRING: System.out.print(cell.getRichStringCellValue().getString());
break; case Cell.CELL_TYPE_NUMERIC: if (DateUtil.isCellDateFormatted(cell)) {
System.out.print(String.valueOf(cell.getDateCellValue()));
} else {
System.out.print(cell.getNumericCellValue());
} break; case Cell.CELL_TYPE_BOOLEAN: System.out.print(cell.getBooleanCellValue()); bre ak; default:
}
}
System.out.println();
}
//读取图片
List<HSSFPictureData> pictures = wb.getAllPictures();
for (HSSFShape shape : sheet.getDrawingPatriarch().getChil dren()) {
if (shape instanceof HSSFPicture) { HSSFPicture pic = (HSSFPicture) shape;
int pictureIndex = pic.getPictureIndex()-1;
HSSFPictureData picData = pictures.get(pictureIndex);
System.out.println("image-size:" + picData.getData().length);
}
}
System.out.println(wb.getSheetName(0));
}
}。