import java.io.IOException;
import org.junit.Test;
import jxl.Workbook;
import java.io.File;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
public class ReadExcel {
@Test
public void gen() {
addExcel();
}
public void addExcel() {
WritableWorkbook wbook = null;
String filename = "E:\\excel\\report.xls";
String newFilename = "E:\\excel\\reportNew"+System.currentTimeMillis()+".xls";
File file = new File(filename);
File newFile = new File(newFilename);
if (!file.exists()) {
// 如果不存在
return ;
}
try {
Workbook book = Workbook.getWorkbook(file);
//Sheet sheet = book.getSheet(0);
// 获取行
int length = 11;
System.out.println(length);
wbook = Workbook.createWorkbook(newFile, book); // 根据book创建一个操作对象
WritableSheet sh = wbook.getSheet(0);// 得到一个工作对象
Label label