从网上下载jxl组件。然后用下面的方法即可//生成设备使用情况报表方法
private void PrintExcal(String result) {
try {
WritableWorkbook workbook = Workbook.createWorkbook(new File(result));
WritableSheet sheet = workbook.createSheet("First Sheet", 0);
// 定义18号字体
WritableFont arial18font = new WritableFont(WritableFont.ARIAL, 18);
WritableCellFormat arial18format = new WritableCellFormat(arial18font);
//定义14号字体
WritableFont arial14font = new WritableFont(WritableFont.ARIAL, 14);
WritableCellFormat arial14format = new WritableCellFormat(arial14font); jxl.write.Label label = new jxl.write.Label(0, 1, "DCN设备使用情况月表",
arial18format);
try {
sheet.addCell(label);
label = new jxl.write.Label(0, 3,
MonthInputYear.getText() + "年" +
MonthInputMonth.getText() + "月",
arial14format);
sheet.addCell(label);
label = new jxl.write.Label(4, 3, "填表单位:" + EUSPDepName.getText(),
arial14format);
sheet.addCell(label);
private void PrintExcal(String result) {
try {
WritableWorkbook workbook = Workbook.createWorkbook(new File(result));
WritableSheet sheet = workbook.createSheet("First Sheet", 0);
// 定义18号字体
WritableFont arial18font = new WritableFont(WritableFont.ARIAL, 18);
WritableCellFormat arial18format = new WritableCellFormat(arial18font);
//定义14号字体
WritableFont arial14font = new WritableFont(WritableFont.ARIAL, 14);
WritableCellFormat arial14format = new WritableCellFormat(arial14font); jxl.write.Label label = new jxl.write.Label(0, 1, "DCN设备使用情况月表",
arial18format);
try {
sheet.addCell(label);
label = new jxl.write.Label(0, 3,
MonthInputYear.getText() + "年" +
MonthInputMonth.getText() + "月",
arial14format);
sheet.addCell(label);
label = new jxl.write.Label(4, 3, "填表单位:" + EUSPDepName.getText(),
arial14format);
sheet.addCell(label);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货