Shulou(Shulou.com)06/02 Report--

How to understand Java Excel API, I believe that many inexperienced people are at a loss about it. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

Sometimes in java development will manipulate excel tables, in fact, the operation is also very simple. Here are the early steps, this article will briefly introduce an open source project: Java Excel Api, you can easily use it to manipulate Excel files.

First of all, download: Java Excel Api, this file I have compressed and uploaded with JAVA+Excel+API detailed tutorial .pdf, interested friends can download!

Download address: http://download.csdn.net/detail/pzhtpf/4256241

The development platform I use here is Eclipse. Here I will briefly explain the operation:

1, build, set up the java project, in this project, create a new folder lib

2, copy jxl.jar, that is, Java Excel Ap, to lib

3, then right-click on the java project and select Properties

4. Select Java Build Path on the left list and Libraries on the right

5, click Add JARs

6, then select the jxl.jar in the lib folder of the project, and click OK

After success, there will be one more folder in the project: Referenced Libraries

After the preparatory work is complete, you can operate the excel.

Here is a piece of read code:

Import java.io.File; import java.io.IOException; import jxl.Cell; import jxl.Sheet; import jxl.Workbook; import jxl.read.biff.BiffException; public class mainClass {public static void main (String args []) {File f=new File ("E:" + File.separator+ "dataAnalysis" + File.separator+ "test.xls"); / / this is a self-built test.xls try {Workbook book=Workbook.getWorkbook (f) located in the E:\ dataAnalysis folder / / Sheet sheet=book.getSheet (0); / / get * worksheet objects for (int item0witi)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.