1 package nn;
 2 
 3 import java.io.File;
 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 public class a {
13     public static void main(String args[]) {
14         try {
15             Workbook book = Workbook.getWorkbook(new File("C:\\Users\\yaru\\Desktop\\abcd.xls"));
16             // 获得第一个工作表对象
17             Sheet sheet = book.getSheet(0);
18             
19              WritableWorkbook workbook = Workbook.createWorkbook(new File("C:\\Users\\yaru\\Desktop\\aaa3.xls"));
20             WritableSheet sheet1 = workbook.createSheet("Sheet 1", 0);
21             
22             int i=0;
23             int rownum = sheet.getRows();
24             System.out.println(rownum);
25             
26             while(i<rownum)
27             {
28             Cell cell1 = sheet.getCell(3, i);
29             
30             String result = cell1.getContents();
31 //            System.out.println(result+"123");
32             result=result.trim();
33 //            System.out.println(result+"123");
34             Label lbl = new Label(3, i, result);
35             sheet1.addCell(lbl);
36    
37             sheet1.setName("修改后"); // 给sheet页改名 
38             
39 
40             i++;
41             }
42 
43           
44             workbook.write(); 
45             workbook.close();
46             book.close();
47         } catch (Exception e) {
48             System.out.println(e);
49         }
50     }
51 }