Paper Title :Design And Implementation Of Massive Excel Data Intelligent Import System To Database (Mysql) By Using Libraries

Author :Kamalakant L Bawankule, N B. Raut

Article Citation :Kamalakant L Bawankule ,N B. Raut , (2014 ) " Design And Implementation Of Massive Excel Data Intelligent Import System To Database (Mysql) By Using Libraries " , International Journal of Advance Computational Engineering and Networking (IJACEN) , pp. 75-78, Volume-2,Issue-5

Abstract : Abstract—To import nearly 1,0000 to attribute to the tables of 10-20 column information of students and papers database of Excel format into the target tables of MySQL database, we developed the intelligent import system which distinguished the simple import 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 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 import the massive data of Excel format into the MySQL database 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.

Type : Research paper

Published : Volume-2,Issue-5

	|		PDF	|	Viewed - 46	|	Published on 2014-05-16