package nn;

 import java.io.File;

 import jxl.Cell;

 import jxl.Sheet;

 import jxl.Workbook;

 import jxl.write.Label;

 import jxl.write.WritableSheet;

 import jxl.write.WritableWorkbook;

 public class a {

     public static void main(String args[]) {

         try {

             Workbook book = Workbook.getWorkbook(new File("C:\\Users\\yaru\\Desktop\\abcd.xls"));

             // 获得第一个工作表对象

             Sheet sheet = book.getSheet(0);

              WritableWorkbook workbook = Workbook.createWorkbook(new File("C:\\Users\\yaru\\Desktop\\aaa3.xls"));

             WritableSheet sheet1 = workbook.createSheet("Sheet 1", 0);

             int i=0;

             int rownum = sheet.getRows();

             System.out.println(rownum);

             while(i<rownum)

             {

             Cell cell1 = sheet.getCell(3, i);

             String result = cell1.getContents();

 //            System.out.println(result+"123");

             result=result.trim();

 //            System.out.println(result+"123");

             Label lbl = new Label(3, i, result);

             sheet1.addCell(lbl);

             sheet1.setName("修改后"); // 给sheet页改名 

             i++;

             }

             workbook.write();

             workbook.close();

             book.close();

         } catch (Exception e) {

             System.out.println(e);

         }

     }

 }