导出成excel

最新推荐文章于 2023-02-12 14:54:37 发布

iteye_20932

最新推荐文章于 2023-02-12 14:54:37 发布

阅读量112

点赞数

CC 4.0 BY-SA版权

分类专栏：导出excel

本文链接：https://blog.youkuaiyun.com/iteye_20932/article/details/82542869

导出excel 专栏收录该内容

0 篇文章

订阅专栏

本文介绍了一种将用户信息列表导出到Excel文件的方法。该方法使用了jxl库来创建Excel工作簿，并设置了包括用户编号、登录名、密码等在内的多个字段。通过遍历用户信息列表，将数据逐行写入Excel中。

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

下面是导出的一个方法：

public static void writeProjectToExcel(String filePath, List<CfsdcUserInfoBean> list) throws Exception{
		File file = new File(filePath);
		//如果文件已存在，删除文件并重建文件
		if (file.exists()){
			file.delete();
			file.createNewFile();
		}
		WritableWorkbook book = null;
		WritableSheet sheet = null;
		book = Workbook.createWorkbook(file);
		sheet = book.createSheet("sheet",0);
		Label label = null;
		label = new Label(0,0,"用户编号");
		sheet.addCell(label);
		label = new Label(1,0,"登录名");
		sheet.addCell(label);
		label = new Label(2,0,"密码");
		sheet.addCell(label);
		label = new Label(3,0,"密码提示问题");
		sheet.addCell(label);
		label = new Label(4,0,"密码提示答案");
		sheet.addCell(label);
		label = new Label(5,0,"电子邮件");
		sheet.addCell(label);
		label = new Label(6,0,"工作单位");
		sheet.addCell(label);
		label = new Label(7,0,"用户注册时间");
		sheet.addCell(label);
		label = new Label(8,0,"真实姓名");
		sheet.addCell(label);
		label = new Label(9,0,"性别");
		sheet.addCell(label);
		label = new Label(10,0,"生日");
		sheet.addCell(label);
		label = new Label(11,0,"详细地址");
		sheet.addCell(label);
		label = new Label(12,0,"教育程度（学位）");
		sheet.addCell(label);
		label = new Label(13,0,"专业");
		sheet.addCell(label);
		label = new Label(14,0,"职业");
		sheet.addCell(label);
		label = new Label(15,0,"从事工作");
		sheet.addCell(label);
		label = new Label(16,0,"职位");
		sheet.addCell(label);
		label = new Label(17,0,"所在地");
		sheet.addCell(label);
		label = new Label(18,0,"月收入");
		sheet.addCell(label);
		label = new Label(19,0,"婚姻状况");
		sheet.addCell(label);
		label = new Label(20,0,"邮编");
		sheet.addCell(label);
		label = new Label(21,0,"电话");
		sheet.addCell(label);
		label = new Label(22,0,"手机");
		sheet.addCell(label);
		label = new Label(23,0,"MSN");
		sheet.addCell(label);
		label = new Label(24,0,"OICQ");
		sheet.addCell(label);
		label = new Label(25,0,"传真");
		sheet.addCell(label);
		label = new Label(26,0,"身份证号码");
		sheet.addCell(label);
		label = new Label(27,0,"个人网站");
		sheet.addCell(label);
		label = new Label(28,0,"个人简介");
		sheet.addCell(label);
		label = new Label(29,0,"兴趣爱好");
		sheet.addCell(label);
		label = new Label(30,0,"用户组编号");
		sheet.addCell(label);
		label = new Label(31,0,"用户权限编号");
		sheet.addCell(label);
		for (int i=0; i<list.size(); i++){
			label = new Label(0,i+1,String.valueOf(list.get(i).getUserId()));
			sheet.addCell(label);
			label = new Label(1,i+1,String.valueOf(list.get(i).getUserLoginName()));
			sheet.addCell(label);
			label = new Label(2,i+1,String.valueOf(list.get(i).getUserPassword()));
			sheet.addCell(label);
			label = new Label(3,i+1,String.valueOf(list.get(i).getUserPasswordQuestion()));
			sheet.addCell(label);
			label = new Label(4,i+1,String.valueOf(list.get(i).getUserPasswordAnswer()));
			sheet.addCell(label);
			label = new Label(5,i+1,String.valueOf(list.get(i).getUserEmail()));
			sheet.addCell(label);
			label = new Label(6,i+1,String.valueOf(list.get(i).getUserWorkUnit()));
			sheet.addCell(label);
			label = new Label(7,i+1,String.valueOf(list.get(i).getUserRegisterTime()));
			sheet.addCell(label);
			label = new Label(8,i+1,String.valueOf(list.get(i).getUserRealName()));
			sheet.addCell(label);
			label = new Label(9,i+1,String.valueOf(list.get(i).getUserSex()));
			sheet.addCell(label);
			label = new Label(10,i+1,String.valueOf(list.get(i).getUserBirthday()));
			sheet.addCell(label);
			label = new Label(11,i+1,String.valueOf(list.get(i).getUserAddress()));
			sheet.addCell(label);
			label = new Label(12,i+1,String.valueOf(list.get(i).getUserEducateDegree()));
			sheet.addCell(label);
			label = new Label(13,i+1,String.valueOf(list.get(i).getUserMajor()));
			sheet.addCell(label);
			label = new Label(14,i+1,String.valueOf(list.get(i).getUserProfession()));
			sheet.addCell(label);
			label = new Label(15,i+1,String.valueOf(list.get(i).getUserJob()));
			sheet.addCell(label);
			label = new Label(16,i+1,String.valueOf(list.get(i).getUserDuty()));
			sheet.addCell(label);
			label = new Label(17,i+1,String.valueOf(list.get(i).getUserLocation()));
			sheet.addCell(label);
			label = new Label(18,i+1,String.valueOf(list.get(i).getUserMonthEarn()));
			sheet.addCell(label);
			label = new Label(19,i+1,String.valueOf(list.get(i).getUserMaritalStatus()));
			sheet.addCell(label);
			label = new Label(20,i+1,String.valueOf(list.get(i).getUserZipCode()));
			sheet.addCell(label);
			label = new Label(21,i+1,String.valueOf(list.get(i).getUserTelephone()));
			sheet.addCell(label);
			label = new Label(22,i+1,String.valueOf(list.get(i).getUserMobilePhone()));
			sheet.addCell(label);
			label = new Label(23,i+1,String.valueOf(list.get(i).getUserMsn()));
			sheet.addCell(label);
			label = new Label(24,i+1,String.valueOf(list.get(i).getUserOICQ()));
			sheet.addCell(label);
			label = new Label(25,i+1,String.valueOf(list.get(i).getUserFax()));
			sheet.addCell(label);
			label = new Label(26,i+1,String.valueOf(list.get(i).getUserIdentityCard()));
			sheet.addCell(label);
			label = new Label(27,i+1,String.valueOf(list.get(i).getUserWebSite()));
			sheet.addCell(label);
			label = new Label(28,i+1,String.valueOf(list.get(i).getUserIntro()));
			sheet.addCell(label);
			label = new Label(29,i+1,String.valueOf(list.get(i).getUserInterest()));
			sheet.addCell(label);
			label = new Label(30,i+1,String.valueOf(list.get(i).getUserGroupId()));
			sheet.addCell(label);
			label = new Label(31,i+1,String.valueOf(list.get(i).getUserAuthorityId()));
			sheet.addCell(label);
		}
		
		book.write();
		book.close();
		return;
	}