知道POI嘛?一款专业的excel导入导出工具,导入jar包即可。
HSSFWorkbook wb;
HSSFSheet sheet;
HSSFRow row;
HSSFCell cell;// 获得Excel文件
public void openExl() {
Frame f = new Frame("test for filedialog");
FileDialog file = new FileDialog(f, "new");
file.setVisible(true);
path = file.getDirectory() + file.getFile();
path = path.replace("\\", "/");
System.out.println(path);
} // 获得Excel文件
public void openExl(String name) {
path = name;
System.out.println(path);
} public void getExl() {
try {
myxls = new FileInputStream(path);
wb = new HSSFWorkbook(myxls);
sheet = wb.getSheetAt(0); // 工作表
row = sheet.getRow(0); // 行
cell = row.getCell((short) 0); // 单元格
sheet_n = wb.getNumberOfSheets();
row_n = sheet.getLastRowNum();
System.out.println(sheet_n + "," + row_n);
}
catch (Exception e) {
e.printStackTrace();
}
}
在数据库中构建excle表 数据JDBC持久化到数据库即可