java中如何导入Excel，并给出模板
一般使用jxl或poi需要相关jar
poi的直接去Apache去下载就行了
下面写意个jxl子
String fi = “Excel文件路径”;
//设置字
WorkbookSettings workbooksetting = new WorkbookSettings();
workbooksetting.setEncoding(“GBK”);
//构造Workbook(工作薄)对象,此先将EXCEL文件装入内存,易引起内存溢出！
InputStream is = new FileInputStream(fi);
Workbook wb = Workbook.getWorkbook(is,workbooksetting);
// 获得了Workbook对象之后，就可以通过它得到Sheet(工作表)对象了
Sheet[] s = wb.getSheets();
for (Sheet sh : s) {
int rows = sh.getRows();
for (int i = 1; i < rows; i ) {
Cell[] cells = sh.getRow(i);
//这里可以读取第i行的xx格内容了cells[xx].getContents()
System.out.println(cells[0].getContents().trim().replaceAll(“\\s”, “”));
}
}
java批量导入excel
两种方案：
1. 可以对数据库表进行本地缓存处理，验证时调用缓存进行验证。
2. 用生成需要导入excel的数据模板，在模板里将要验证的这一列做成下拉框。此模板条件下的excel数据文件批量导入时即不用校验。
具体采用哪种视你的应用场景来定。
如何把excel数据导入java
用方组poi读取，给个例参下
public class ApachePOIExcelRead {
private static final String FILE_NAME = “/tmp/MyFirstExcel.xlsx”;
public static void main(String[] args) {
try {
FileInputStream excelFile = new FileInputStream(new File(FILE_NAME));
Workbook workbook = new XSSFWorkbook(excelFile);
Sheet datatypeSheet = workbook.getSheetAt(0);
Iterator iterator = datatypeSheet.iterator();
while (iterator.hasNext()) {
Row currentRow = iterator.next();
Iterator cellIterator = currentRow.iterator();
while (cellIterator.hasNext()) {
Cell currentCell = cellIterator.next();
//getCellTypeEnum shown as deprecated for version 3.15
//getCellTypeEnum ill be renamed to getCellType starting from version 4.0
if (currentCell.getCellTypeEnum() == CellType.STRING) {
System.out.print(currentCell.getStringCellValue() “–“);
} else if (currentCell.getCellTypeEnum() == CellType.NUMERIC) {
System.out.print(currentCell.getNumericCellValue() “–“);
}
}
System.out.println();
}
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
}