67,512
社区成员
发帖
与我相关
我的任务
分享
package jxls;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Random;
import net.sf.jxls.exception.ParsePropertyException;
import net.sf.jxls.transformer.XLSTransformer;
public class ExportExcel {
private static Map<String,List<Client>> m = new HashMap<String,List<Client>>();
private static java.util.List<Client> clientList = new ArrayList<Client>();
public static void main(String[] args) {
Random r = new Random();
for (int i = 0; i < 10; i++) {
Client t = new Client(i + 1, "客户020" + i, Calendar
.getInstance().getTime(), r.nextBoolean() ? "M" : "F");
clientList.add(t);
System.out.println(t.getName());
}
m.put("clients", clientList);
// 以上模拟从数据库中查询出的数据
XLSTransformer tfmer = new XLSTransformer();
try {
tfmer.transformXLS("d:\\template1.xls", m, "d:\\1.xls");
} catch (ParsePropertyException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
class Client {
public int id;
public String name;
public Date birthday;
public String sex;
public Client(int id, String name, Date birthday, String sex) {
super();
this.id = id;
this.name = name;
this.birthday = birthday;
this.sex = sex;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Date getBirthday() {
return birthday;
}
public void setBirthday(Date birthday) {
this.birthday = birthday;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
}