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();
}
}
