| | |
| | | |
| | | @Test |
| | | public void addressInsertTest() throws IOException { |
| | | File file = new File("/Users/helius/Desktop/src20.xls"); |
| | | // String src = "/Users/helius/Desktop/src20.xls"; |
| | | String src = "C:/Users/wzy19/Desktop/ace2.xls"; |
| | | File file = new File(src); |
| | | FileInputStream input = new FileInputStream(file); |
| | | |
| | | Workbook wb = null; |
| | |
| | | |
| | | Sheet sheet = wb.getSheetAt(0); |
| | | int lastRowNum = sheet.getLastRowNum(); |
| | | for (int i = 0; i < lastRowNum; i++) { |
| | | for (int i = 0; i <= lastRowNum; i++) { |
| | | Row row = sheet.getRow(i); |
| | | Cell cell = row.getCell(0); |
| | | TrcAddressEntity addressEntity = new TrcAddressEntity(); |