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);
}
}
}