Package cn.net.pap.common.excel

Class ExcelCRUDUtil

java.lang.Object

cn.net.pap.common.excel.ExcelCRUDUtil

public class ExcelCRUDUtil
extends Object

Constructor Summary

Constructors

Constructor	Description
ExcelCRUDUtil()

Method Summary

Modifier and Type	Method	Description
static void	createXlsx(String path, String sheetName)
static void	delete(int rowIndex, String path, String sheets)
static String	formatCell(org.apache.poi.ss.usermodel.Cell cell)
static org.apache.poi.xssf.usermodel.XSSFWorkbook	getExcelByPath(String path)	通过文件路劲获取excel文件
static int	getExcelRealRow(org.apache.poi.ss.usermodel.Sheet sheet)
static void	insert(PageData pd, String path, String sheets)
static List<PageData>	selectList(String path, String sheet)
static void	update(int rowNum, int colNum, String value, String path, String sheets)
static List<PageData>	vttInit(String path, String sheets)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

ExcelCRUDUtil

public ExcelCRUDUtil()

Method Details

createXlsx

public static void createXlsx(String path,
 String sheetName)

selectList

public static List<PageData> selectList(String path,
 String sheet)
                                 throws ParseException

Throws:

ParseException

insert

public static void insert(PageData pd,
 String path,
 String sheets)
                   throws IOException

Throws:

IOException

delete

public static void delete(int rowIndex,
 String path,
 String sheets)
                   throws IOException

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

public static List<PageData> vttInit(String path,
 String sheets)

getExcelRealRow

public static int getExcelRealRow(org.apache.poi.ss.usermodel.Sheet sheet)

getExcelByPath

public static org.apache.poi.xssf.usermodel.XSSFWorkbook getExcelByPath(String path)

通过文件路劲获取excel文件

Parameters:

path -

Returns:

formatCell

public static String formatCell(org.apache.poi.ss.usermodel.Cell cell)