PIO的EXCEL的写入和导出
PIO的EXCEL的字体样式，边框样式，背景色样式，下拉选择，下拉级联选择，日期格式验证，下拉验证，验证错误提示，输入信息提示等功能

代码如下

package com.fruitking.excel;public class Student {private String studentNo;//学生学号private String studentName;//学生姓名    private String studentSex;//性别    private String provinceName;//出生省份    private String cityName;//出生城市    private String collageName;//所在学院    private String majorName;//专业名称    private String studentAge ;//年龄    private String birthday;//出生日期    private String remark;//备注信息    public String getStudentNo() {return studentNo;}public void setStudentNo(String studentNo) {this.studentNo = studentNo;}public String getStudentName() {return studentName;}public void setStudentName(String studentName) {this.studentName = studentName;}public String getStudentSex() {return studentSex;}public void setStudentSex(String studentSex) {this.studentSex = studentSex;}public String getProvinceName() {return provinceName;}public void setProvinceName(String provinceName) {this.provinceName = provinceName;}public String getCityName() {return cityName;}public void setCityName(String cityName) {this.cityName = cityName;}public String getCollageName() {return collageName;}public void setCollageName(String collageName) {this.collageName = collageName;}public String getMajorName() {return majorName;}public void setMajorName(String majorName) {this.majorName = majorName;}public String getStudentAge() {return studentAge;}public void setStudentAge(String studentAge) {this.studentAge = studentAge;}public String getBirthday() {return birthday;}public void setBirthday(String birthday) {this.birthday = birthday;}public String getRemark() {return remark;}public void setRemark(String remark) {this.remark = remark;}}