Package cn.net.pap.common.excel
Class ExcelCRUDUtil
java.lang.Object
cn.net.pap.common.excel.ExcelCRUDUtil
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionstatic voidcreateXlsx(String path, String sheetName) static voidstatic StringformatCell(org.apache.poi.ss.usermodel.Cell cell) static org.apache.poi.xssf.usermodel.XSSFWorkbookgetExcelByPath(String path) 通过文件路劲获取excel文件static intgetExcelRealRow(org.apache.poi.ss.usermodel.Sheet sheet) static voidselectList(String path, String sheet) static void
-
Constructor Details
-
ExcelCRUDUtil
public ExcelCRUDUtil()
-
-
Method Details
-
createXlsx
-
selectList
- Throws:
ParseException
-
insert
- Throws:
IOException
-
delete
- Throws:
IOException
-
update
public static void update(int rowNum, int colNum, String value, String path, String sheets) throws IOException - Parameters:
rowNum- 行数colNum- 列数value-path-sheets-- Throws:
IOException
-
vttInit
-
getExcelRealRow
public static int getExcelRealRow(org.apache.poi.ss.usermodel.Sheet sheet) -
getExcelByPath
通过文件路劲获取excel文件- Parameters:
path-- Returns:
-
formatCell
-