Design and implementation of massive MYSQL data intelligent export system to excel by using Apache –POI libraries
Journal Title: IOSR Journals (IOSR Journal of Computer Engineering) - Year 2014, Vol 16, Issue 5
Abstract
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.
Authors and Affiliations
Kamalakant L Bawankule , N B. Raut
Keywords
Related Articles
- EP ID EP131966
- DOI -
- Views 127
- Downloads 0
Data Mining: Solving the Thirst of Recommendations to Users
Abstract: Internet usage attains a peek level in these days. It is portable due to arrival of smart phones. Peoplecan enquire information about any products they are in need using the Electronic sites. Their needs...
Imaging of Intracranial Space Occupying Lesions: A Prospective Study in A Tertiary Care Centre in Northern India
Introduction: The high morbidity & mortality associated with ICSOLs necessitates their early diagnosis so as to plan the required intervention. Intracranial Space occupying lesions (ICSOL) can be neoplastic,inf...
Towards Accurate Estimation of Fingerprint Ridge Orientation Using BPNN and Ternarization
Accurate estimation of ridge orientation is a crucial step in fingerprint image enhancement because the performance of a minutiae extraction algorithm and matching heavily relies on the quality of the input fin...
A Word Stemming Algorithm for Hausa Language
Abstract: Hausa, a highly inflected language, needs a worthy stemming approach for efficient informationretrieval (IR). However, there is a limited or unavailable study to stemming in the language. Stemming refers tothe...
Modified Rabin Cryptosystem through Advanced Key Distribution System
Abstract: In this paper, an asymmetric cryptosystem Rabin Cryptosystem has been modified by adding an advanced message authentication system with it. The proposed modified Rabin Cryptosystem is a combination of sym...