Java_jxl创建Excel文件,插入数据(含图片)

来源：互联网发布：淘宝会员卡图片编辑：程序博客网时间：2024/05/16 12:23

准备工作:

1,创建Java项目或者Java web项目

2,导入jxl.jar

3,创建类

接下来上代码:

package excel;import java.io.File;import jxl.Workbook;import jxl.write.Label;import jxl.write.WritableImage;import jxl.write.WritableSheet;import jxl.write.WritableWorkbook;public class JxlExcel2 {public static void main(String[] args) {String[] title = {"编号","姓名","性别","头像"};//用字符串数组存放标题//要插入的图片File imgFile = new File("d:\\Azzan.png");//自定义盘符中的文件//创建Excel文件File file = new File("d:/Azzan_test2.xls");try {//创建文件file.createNewFile();//创建工作簿WritableWorkbook workbook = Workbook.createWorkbook(file);//创建sheet页WritableSheet sheet = workbook.createSheet("sheet1", 0);//sheet1名字,0索引的值//写入标题Label label = null;for (int i = 0; i < title.length; i++) {label = new Label(i,0,title[i]);sheet.addCell(label);}//追加数据for (int i = 1; i <= 10; i++) {label = new Label(0,i,"a"+i);sheet.addCell(label);label = new Label(1,i,"user"+i);sheet.addCell(label);label = new Label(2,i,"男");sheet.addCell(label);//WritableImage(col, row, width, height, imgFile);//列   行    宽      高WritableImage image = new WritableImage(3,i,1, 1, imgFile);sheet.addImage(image);}workbook.write();//流的写入workbook.close();//流的关闭} catch (Exception e) {e.printStackTrace();}}}

注意:

jxl无行列概念,因此通过坐标来定位要操作的位置.

0 0