Introduction - If you have any usage issues, please Google them yourself
Java-based relational database and data access excel 2007 Research 1.2 Project background and content of a summary application in an enterprise often use Excel to handle forms, tables to Excel data into a database, or operation contrary to the past There are two methods: first, using the CSV text file to do the transition, the demerit is that the format of Excel can not carry information second is the use of COM technology. Direct access to Excel with Java is difficult to document. As a result of Office 2007' s OpenXML adoption of an open standard, Java greatly enhanced by direct access to the convenience of Office documents. This project include: (1) study OpenXML, Research Excel 2007 workbook access technology (2) the use of Java to achieve Excel 2007 workbooks, and SQL Server database conversion with each other