JXL读写EXCEL文件
今天研究了一下如何使用jxl操作excel文件，写了个简单的示例程序如下，以后要是用Java做报表可以拿来用用。
1 import java.io.FileInputStream;
2 import java.io.FileOutputStream;
3 import java.io.InputStream;
4
5 import jxl.Cell;
6 import jxl.Sheet;
7 import jxl.Workbook;
8 import jxl.write.Label;
9 import jxl.write.WritableSheet;
10 import jxl.write.WritableWorkbook;
11
12
13 public class EXCEL {
14
15 /**
16 * @param args
17 */
18 public static void main(String[] args) {
19 // TODO Auto-generated method stub
20 try{
21 String resourcePath=System.getProperty("user.dir");
22 System.out.println(resourcePath);
23 InputStream is=new FileInputStream(resourcePath.concat("\\src\\data.xls"));
24 Workbook book=Workbook.getWorkbook(is);
25 Sheet sheet=book.getSheet(0);
26 Cell cell[]=sheet.getColumn(0);
27 for(int i=0;i<cell.length;i++)//读出文件内容
28 System.out.println(cell[i].getContents());
29 System.out.println("导入的数据行数："+sheet.getRows());
30 System.out.println("导入的数据列数："+sheet.getColumns());
31
32 WritableWorkbook wrk = Workbook.createWorkbook(new FileOutputStream("b.xls"));
33 //WritableWorkbook wrk = Workbook.createWorkbook(new FileOutputStream("b.xls"),book);34 //以book的格式创建一个excel文件，其初始内容与in文件相同(更新文件可以用到此方法)
35 WritableSheet wst = wrk.createSheet("demo", 0);
36 Label l=new Label(0,0,"cike");//有多种格式的单元格
37 wst.addCell(l);
38
39 book.close();
40 wrk.write();//必须有
41 wrk.close();
42
43 book=Workbook.getWorkbook(new FileInputStream("b.xls"));
44 sheet=book.getSheet(0);
45 System.out.println("导入的数据行数："+sheet.getRows());
46 System.out.println("导入的数据列数："+sheet.getColumns());
47 book.close();
48 }catch(Exception e){
49 e.printStackTrace();
50 }
51 }
52
53 }
54
