1)引入jxl.jar包

2)写接口

package testExcel;

public interface ExcelService {
 public void write(int colum, int row, String content) throws Exception;
 public String read(int colum, int row)throws Exception;
}
3)读写excle类

package testExcel;
import testExcel.ExcelService;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

public class ExcelUtils implements ExcelService{
 private String path = "D:\\excel.xls";
 
 public static void main(String[] args) throws Exception {
  ExcelUtils excelUtils = new ExcelUtils();
  String content = "Hello World";
  excelUtils.write(2, 3, content);
  String newContent = excelUtils.read(2, 3);
  System.out.println(newContent);

 }
 public void write(int colum, int row, String content) throws Exception {
  FileOutputStream fileOutputStream = new FileOutputStream(path);
  WritableWorkbook writableWorkbook = Workbook
    .createWorkbook(fileOutputStream);
  WritableSheet writableSheet = writableWorkbook.createSheet("Excel", 0);
  Label label = new Label(colum, row, content);
  writableSheet.addCell(label);
  writableWorkbook.write();
  writableWorkbook.close();
  fileOutputStream.close();
 }
 public String read(int colum, int row) throws Exception {
  FileInputStream fileInputStream = new FileInputStream(path);
  Workbook workbook = Workbook.getWorkbook(fileInputStream);
  Sheet sheet = workbook.getSheet(0);
  Cell cell = sheet.getCell(colum, row);
  String content = cell.getContents();
  workbook.close();
  fileInputStream.close();
  return content;
 }
}

发表于 @ 2009年07月01日　11:08:00 | 评论( loading... ) | 编辑| 举报| 收藏

旧一篇:花生壳域名应用局域网tomcat服务器 | 新一篇:axis 提供webservice 连接.net