采用的是开源的jxl组件进行开发。
具体的源代码如下:
import java.io.File; import java.io.IOException; import java.util.ArrayList; import jxl.Workbook; import jxl.format.Alignment; import jxl.format.Border; import jxl.format.BorderLineStyle; import jxl.format.VerticalAlignment; import jxl.write.WritableCellFormat; import jxl.write.WritableFont; import jxl.write.WriteException; import jxl.write.biff.RowsExceededException; public class Demo { public static void main(String[] args)throws IOException ,RowsExceededException, WriteException{ String fileName = "exportExcel.xls"; File file = new File(fileName); if(file.exists()) file.delete(); //创建一个excel文件 jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(new File(fileName)); //创建一个工作簿 jxl.write.WritableSheet ws = wwb.createSheet("统计数据", 0); //定义excel的文本单元格 jxl.write.Label label; //=======================设置第一个单元格========================= //合并(0,0)和(0,1)单元格 ws.mergeCells(0, 0, 0, 1); //字体为Arial格式,不是斜体 WritableFont wf = new WritableFont(WritableFont.ARIAL, 10,WritableFont.NO_BOLD, false); //字体颜色为红色 wf.setColour(jxl.format.Colour.BLAC