简单的java读写excel

最新推荐文章于 2023-07-24 09:40:04 发布

最新推荐文章于 2023-07-24 09:40:04 发布 · 120 阅读

文章标签：

#Excel #Java #单元测试 #J#

jxl 专栏收录该内容

1 篇文章

订阅专栏

本文提供了一个使用Java进行Excel读写的示例程序，包括如何读取Excel文件中的数据及如何创建并写入数据到新的Excel文件。示例中详细展示了不同数据类型的处理方式以及如何设置单元格格式。

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

[size=large][color=blue]首先是读Excel：[/color][/size]


package August;

import java.io.File;

import jxl.Cell;
import jxl.CellType;
import jxl.DateCell;
import jxl.NumberCell;
import jxl.Sheet;
import jxl.Workbook;

public class ReadExcel {
	public static void main(String[] args) {
		Workbook workbook = null;

		try {
		   workbook = Workbook.getWorkbook(new File("d:\\readExcel.xls"));
		} catch (Exception e) {
		  e.printStackTrace();
		}

		Sheet sheet = workbook.getSheet(0);
		Cell cell = null;

		int columnCount=4;//代表列
		int rowCount=sheet.getRows();//得到列有多少行
		for (int i = 0; i <rowCount; i++) {
		   for (int j = 0; j <columnCount; j++) {
		       //注意，这里的两个参数，第一个是表示列的，第二才表示行
		       cell=sheet.getCell(j, i);
		       //要根据单元格的类型分别做处理，否则格式化过的内容可能会不正确
		       if(cell.getType()==CellType.NUMBER){
		           System.out.print(((NumberCell)cell).getValue());
		       }
		       else if(cell.getType()==CellType.DATE){
		           System.out.print(((DateCell)cell).getDate());
		       }
		       else{
		           System.out.print(cell.getContents());
		       }

		       //System.out.print(cell.getContents());
		       System.out.print("\t");
		   }
		   System.out.print("\n");
		}
		//关闭它，否则会有内存泄露
		workbook.close();

	}
}

[size=large][color=blue]然后是写Excel：[/color][/size]


package August;

import java.io.File;
import java.io.IOException;

import jxl.Workbook;
import jxl.format.UnderlineStyle;
import jxl.write.DateFormat;
import jxl.write.DateTime;
import jxl.write.Label;
import jxl.write.NumberFormat;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

public class WriteExcel {
	public static void main(String[] args) {
		File tempFile=new File("d:/writeExcel.xls");
		WritableWorkbook workbook = null;
		try {
			workbook = Workbook.createWorkbook(tempFile);
		} catch (IOException e) {
			e.printStackTrace();
		}
		WritableSheet sheet = workbook.createSheet("TestCreateExcel", 0); 

		//一些临时变量，用于写到excel中
		Label l=null;
		jxl.write.Number n=null;
		DateTime d=null;

		//预定义的一些字体和格式，同一个Excel中最好不要有太多格式
		WritableFont headerFont = new WritableFont(WritableFont.ARIAL, 12, WritableFont.BOLD, false,UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.BLUE); 
		WritableCellFormat headerFormat = new WritableCellFormat (headerFont); 

		WritableFont titleFont = new WritableFont(WritableFont.ARIAL, 10, WritableFont.NO_BOLD, false, UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.RED); 
		WritableCellFormat titleFormat = new WritableCellFormat (titleFont); 

		WritableFont detFont = new WritableFont(WritableFont.ARIAL, 10, WritableFont.NO_BOLD, false, UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.BLACK); 
		WritableCellFormat detFormat = new WritableCellFormat (detFont); 

		NumberFormat nf=new NumberFormat("0.00000");  //用于Number的格式
		WritableCellFormat priceFormat = new WritableCellFormat (detFont, nf); 

		DateFormat df=new DateFormat("yyyy-MM-dd");//用于日期的
		WritableCellFormat dateFormat = new WritableCellFormat (detFont, df); 

		//剩下的事情，就是用上面的内容和格式创建一些单元格，再加到sheet中
		l=new Label(1, 0, "用于测试的Excel文件", headerFormat);
		try{

		sheet.addCell(l);

		//add Title
		int column=0;
		l=new Label(column++, 2, "标题", titleFormat);
		sheet.addCell(l);
		l=new Label(column++, 2, "日期", titleFormat);
		sheet.addCell(l);
		l=new Label(column++, 2, "货币", titleFormat);
		sheet.addCell(l);
		l=new Label(column++, 2, "价格", titleFormat);
		sheet.addCell(l);

		//add detail
		int i=0;
		column=0;
		l=new Label(column++, i+3, "标题 "+i, detFormat);
		sheet.addCell(l);
		d=new DateTime(column++, i+3, new java.util.Date(), dateFormat);
		sheet.addCell(d);
		l=new Label(column++, i+3, "CNY", detFormat);
		sheet.addCell(l);
		n=new jxl.write.Number(column++, i+3, 5.678, priceFormat);
		sheet.addCell(n);

		i++;
		column=0;
		l=new Label(column++, i+3, "标题 "+i, detFormat);
		sheet.addCell(l);
		d=new DateTime(column++, i+3, new java.util.Date(), dateFormat);
		sheet.addCell(d);
		l=new Label(column++, i+3, "SGD", detFormat);
		sheet.addCell(l);
		n=new jxl.write.Number(column++, i+3, 98832, priceFormat);
		sheet.addCell(n);

		//设置列的宽度
		column=0;
		sheet.setColumnView(column++, 20);
		sheet.setColumnView(column++, 20);
		sheet.setColumnView(column++, 10);
		sheet.setColumnView(column++, 20);

		workbook.write();
		workbook.close();
		}catch(Exception e) {

		}

	}
}

以上代码必须导入jxl.jar包。