To search, Click below search items. |
| All Published Papers Search Service |
|
|
|
Title |
Design and implementation of massive MYSQL data intelligent export system to excel by using Apache ? POI libraries |
|
Author |
KAMALAKANT L BAWANKULE |
| Citation |
Vol. 15 No. 9 pp. 85-90 |
|
Abstract |
To export nearly 1,0000 attribute from database to excel of 10-20 column information of students and papers of database format into the target Excel sheet, we developed the intelligent export system which distinguished the simple export system. The system uses Netbeans/Eclipse as the development tool, object-oriented language java as the programming language, MySQL as the background database, POI-HSSF as the apache Library for reading & writing data from excel, used AWT and SWING for design of an application ,and uses the mysql-connector as connection technology to database. The system realizes to export the massive data of database into the Excel format intellectually that convenient for integrating and managing the multiple data required for regular examination process in the institutes and universities. HSSF is the POI Project's pure Java implementation of the Excel '97(-2007) file format. XSSF is the POI Project's pure Java implementation of the Excel 2007 OOXML (.xlsx) file format.HSSF and XSSF provide ways to read spreadsheets create, modify, read and write XLS spreadsheets. |
|
Keywords |
Database, JAVA, POI-HSSF, HSSF, MySQL, XSSF. |
|
URL |
