先下载jxl.jar包
创建Excel文件
package com.my.file;
import java.io.File;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class CreateExcel
{
public static void main(String[] args)
{
try
{
// 打开文件
WritableWorkbook book = Workbook.createWorkbook(new File(
"E:\\test.xls"));
// 生成名为"第一页"的工作表,参数0表示这是第一页
WritableSheet sheet = book.createSheet("第一页", 0);
// 在Label对象的构造中指明单元格的位置(0,0),内容是test
Label label = new Label(0, 0, "test");
// 将定义好的单元格添加到工作表
sheet.addCell(label);
// 生成一个保存数字的单元格
jxl.write.Number number = new jxl.write.Number(1, 0, 555.12541);
sheet.addCell(number);
book.write();
book.close();
} catch (Exception e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
//读取Excel文件
package com.my.file;
import java.io.File;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
public class ReadExcel
{
public static void main(String[] args)
{
try
{
Workbook book = Workbook.getWorkbook(new File("E:\\test.xls"));
// 获取第一个工作对象
Sheet sheet = book.getSheet(0);
// 得到第一行第一列的单元格
Cell cell = sheet.getCell(0, 0);
// 获取单元格中的内容
String result = cell.getContents();
System.out.println(result);
book.close();
} catch (Exception e)
{
e.printStackTrace();
}
}
}
//更新Excel文件
package com.my.file;
import java.io.File;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class UpdateExcele
{
public static void main(String[] args)
{
try
{
// 获取Excel文件
Workbook wb = Workbook.getWorkbook(new File("E:\\test.xls"));
// 打开一个文件的副本,并指定数据回写到原文件中
WritableWorkbook book = Workbook.createWorkbook(new File(
"E:\\test.xls"), wb);
// 名称为第二页,1表示第二页
WritableSheet sheet = book.createSheet("第二页", 1);
// 合并第0行---第0行,第0列--第5列
sheet.mergeCells(0, 0, 5, 0);
// 设置字符格式
WritableFont font = new WritableFont(WritableFont.TIMES, 16,
WritableFont.BOLD);
// 指定格式模版
WritableCellFormat format = new WritableCellFormat(font);
// 水平方向指定为居中
format.setAlignment(jxl.format.Alignment.CENTRE);
// 垂直方向指定居中
format.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);
// 指定单元表格的长和宽
sheet.setColumnView(0, 50);
sheet.setRowView(0, 500);
Label lable = new Label(0, 0, "第二页,hello world", format);
sheet.addCell(lable);
book.write();
book.close();
} catch (Exception e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}