public int getLastRow(int sheet) { if (FileType.getFileType() == 1) { return excel_xls.getLastRow(sheet); } else if (FileType.getFileType() == 2) { return excel_xlsx.getLastRow(sheet); } return -1; }
public int getSheetNumber() { if (FileType.getFileType() == 1) { return excel_xls.getSheetNumber(); } else if (FileType.getFileType() == 2) { return excel_xlsx.getSheetNumber(); } return -1; }
public int getLastSheet() { if (FileType.getFileType() == 1) { return wb_xls.getNumberOfSheets() - 1; } else if (FileType.getFileType() == 2) { return wb_xlsx.getNumberOfSheets() - 1; } return -1; }
public int createCertainCell(int sheet, int row, int cell) { if (FileType.getFileType() == 1) { excel_xls.createCertainCell(sheet, row, cell); } else if (FileType.getFileType() == 2) { excel_xlsx.createCertainCell(sheet, row, cell); } return 1; }
public int getIndexofLastSheet() { if (FileType.getFileType() == 1) { return excel_xls.getLastSheet(); } else if (FileType.getFileType() == 2) { return excel_xlsx.getLastSheet(); } return -1; }
public int setCellValue_Output(int sheet, int RowIndex, int CellIndex, String value) { if (FileType.getFileType() == 1) { excel_xls.setCellValue_Output(sheet, RowIndex, CellIndex, value); } else if (FileType.getFileType() == 2) { excel_xlsx.setCellValue_Output(sheet, RowIndex, CellIndex, value); } return -1; }
public int createSheet() { if (FileType.getFileType() == 1) { excel_xls.createSheet(); } else if (FileType.getFileType() == 2) { excel_xlsx.createSheet(); } return 1; }
public int createRow(int sheet) { if (FileType.getFileType() == 1) { excel_xls.createRow(sheet); } else if (FileType.getFileType() == 2) { excel_xlsx.createRow(sheet); } return 1; }
public int getIndex_of_SheetName(String name) { if (FileType.getFileType() == 1) { return excel_xls.getIndex_of_SheetName(name); } else if (FileType.getFileType() == 2) { return excel_xlsx.getIndex_of_SheetName(name); } return -1; }
public int getIndex_of_RowName(int sheet, String name) { if (FileType.getFileType() == 1) { return excel_xls.getIndex_of_RowName(sheet, name); } else if (FileType.getFileType() == 2) { return excel_xlsx.getIndex_of_RowName(sheet, name); } return -1; }
public int getLastCellIndex(int sheet, int RowIndex) { if (FileType.getFileType() == 1) { return excel_xls.getLastCellIndex(sheet, RowIndex); } else if (FileType.getFileType() == 2) { return excel_xlsx.getLastCellIndex(sheet, RowIndex); } return -1; }
public String get(int sheet, int RowIndex, int CellIndex) { if (FileType.getFileType() == 1) { // xls return excel_xls.get(sheet, RowIndex, CellIndex); } else if (FileType.getFileType() == 2) { // xlsx return excel_xlsx.get(sheet, RowIndex, CellIndex); } return ""; }
public int outputExcel() { if (FileType.getFileType() == 1) { excel_xls.outputExcel(); return 1; } else if (FileType.getFileType() == 2) { excel_xlsx.outputExcel(); return 1; } return -1; }
protected Excel_File(String fp) { try { file_path = fp; FileType = new File_Type_Check(fp); if (FileType.getFileType() == 1) { excel_xls = new Excel_xls(fp); wb_xls = excel_xls.getWorkBook(); } else if (FileType.getFileType() == 2) { excel_xlsx = new Excel_xlsx(fp); wb_xlsx = excel_xlsx.getWorkBook(); } } catch (Exception e1) { System.out.println("Initialize Excel_File failed"); e1.printStackTrace(); } }