jxl架包操作excel表格

import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;


import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;


public class Test {
public static void main(String[] args) {
Test test = new Test();
test.readerExcel();
test.writerExcel();
}


public void readerExcel() {
try {
InputStream is = new FileInputStream("D://test.xls");
Workbook wb = Workbook.getWorkbook(is);
Sheet rs = wb.getSheet(0);
Cell c;
for (int i = 0; i < rs.getRows(); i++) {
for (int j = 0; j < rs.getColumns(); j++) {
c = (rs).getCell(j, i);
String strc = c.getContents();
System.out.printf("%10s", strc);
}
System.out.println();
}
System.out.println(rs.getRows());
wb.close();
is.close();
} catch (Exception e) {
e.printStackTrace();
}
}


public void writerExcel() {
System.out.println("正在往test2.xls中写入数据.......");
try {
File file = new File("D://test2.xls");
if (!file.exists())
file.createNewFile();
WritableWorkbook book = Workbook.createWorkbook(file);
WritableSheet sheet = book.createSheet("test2.xls", 0);
String[] str = new String[] { "你", "我", "他" };
for (int i = 0; i < 5; i++) {
String[] cell = str;
for (int j = 0; j < cell.length; j++) {
Label label = new Label(j, i, cell[j]);
sheet.addCell(label);
}
}
book.write();
book.close();
System.out.println("数据写入成功.......");
} catch (Exception e) {
System.out.println("数据写入出错.......");
e.printStackTrace();
}
}

}