基于java和关系数据库的excel 2007数据存取技术研究

1.2 项目背景和内容概要 

　　在企业应用中，经常用Excel来处理表格，要把Excel表格中的数据存入数据库， 或者进行相反的操作，过去的方法有两个：一是采用文本格式的CSV文档做过渡， 缺点是无法携带Excel的格式信息；二是使用COM技术。用Java直接存取Excel文档 是困难的。由于Office 2007采用了开放的OpenXML标准，大大提高了用Java直接 存取Office文档的便捷性。本项目的研究内容包括：（1）学习OpenXML，研究 Excel 2007工作簿的存取技术；（2）采用Java实现Excel 2007工作簿和SQL Server数据库的互相转换-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