POI实现Excel的数据导入导出的研究

The Realization of Using Excel File as Input or Output Data in POI

随着Java成为越来越多的Web应用系统的开发语言,利用Java进行Excel的数据导入导出在很多系统中都发挥着重要作用。本文采用POI操作Excel文件的方法,实现了将数据库中的数据导出到Excel表格中,并将Excel表格中的数据导入数据库的功能。满足了用户进行数据库数据导入导出的要求。

More and more systems are developed by Java, it is important to use java to realize using Excel file as input or output data. this method is adopted to operate Excel by POI, can the data be exported from database into Excel and data be imported from Excel into database. It meet the requirements of clients for data import and export.