使用java语言向Excel中写入多条测试数据详解

需要导入  jxl.jar包   随便在网上下载一个就行
public static void writeExcel() {

//定义列
    String[] titleA = {"会员卡号", "会员等级","姓名","昵称","头像","性别","手机号","电话","Email","身份证号","出生日期","省","市","初始积分","累计积分","领卡时间","最后一次消费时间","所属店铺名称",
    "微信用户标示","支付宝用户标示","会员实充余额","会员赠送余额"};
    //创建Excel文件
    File fileA = new File("D:/TestFile7.xls");
    if (fileA.exists()){
        fileA.delete();
    }
    try {

        //创建文件
        fileA.createNewFile();
        //创建工作簿
        WritableWorkbook workbook= Workbook.createWorkbook(fileA);
        //创建shell
        WritableSheet sheetA=workbook.createSheet("sheet1",0);
        //创建Lable对象
        Label labelA=null;

        for (int i=0;i<titleA.length;i++){
                labelA=new Label(i,0,titleA[i]);
                sheetA.addCell(