java excel

最新推荐文章于 2025-08-20 15:04:37 发布

lstlcj

最新推荐文章于 2025-08-20 15:04:37 发布

阅读量245

点赞数

CC 4.0 BY-SA版权

文章标签： java exception string file excel class

本文链接：https://blog.youkuaiyun.com/lstlcj/article/details/7084601

本文介绍了如何使用jxl库在Java中创建、读取及更新Excel文件。包括创建新的Excel文件并写入数据、从现有文件中读取数据以及向已有文件中添加新内容的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

首先下载一个jxl.jar 包

1、打开文件

WritableWorkbook book = Workbook.createWorkbook(new File("my.xls"));

2、生成第一页

WritableSheet sheet = book.createSheet("第一页", 0);

3、向sheet里面添加内容

添加文本Label label = new Label(0,0,"内容");

第一个0表示行，第二个0表示列

4、写入

book.write();

5、关闭

book.close();

完整代码：

package cn.lst;

import java.io.File;

import jxl.*;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class First {

public static void main(String[] args){
  try{
   //打开文件
   WritableWorkbook book = Workbook.createWorkbook(new File("my.xls"));
   //生成第一页
   WritableSheet sheet = book.createSheet("第一页", 0);
   Label label = new Label(0,0,"test");
   sheet.addCell(label);
   jxl.write.Number number = new jxl.write.Number(1,0,05);
   sheet.addCell(number);
   Label label1 = new Label(0,1,"不知道");
   Label label2 = new Label(1,1,"不知道哦啊");
   sheet.addCell(label1);
   sheet.addCell(label2);
   book.write();
   book.close();
  }catch(Exception e){
   e.printStackTrace();
  }
}
}

从excel中读取

package cn.lst;

import java.io.File;

import jxl.*;
public class Second {

public static void main(String[] args) {
  try{
   Workbook book = Workbook.getWorkbook(new File("my.xls"));
   Sheet sheet = book.getSheet(0);
   Cell cell = sheet.getCell(1,1);
   String result = cell.getContents();
   System.out.print(result);
   book.close();
  }catch(Exception e){
   e.printStackTrace();
  }
}

}

更新

package cn.lst;

import java.io.File;

import jxl.*;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class Third {

public static void main(String[] args) {

  try{
   Workbook book = Workbook.getWorkbook(new File("my.xls"));

   WritableWorkbook bo = Workbook.createWorkbook(new File("my.xls"),book);

   WritableSheet sheet = bo.createSheet("第二页", 1);

   sheet.addCell(new Label(0,0,"测试"));

   bo.write();
   bo.close();

  }catch(Exception e){
   e.printStackTrace();
  }
}

}