最近研究导数据接触到了JXL,就顺带着琢磨了下。在这里记录一下,以后就不用导出找资料了。
代码:
import java.io.File;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import jxl.Workbook;
import jxl.format.Alignment;
import jxl.format.Border;
import jxl.format.BorderLineStyle;
import jxl.format.Colour;
import jxl.format.PageOrientation;
import jxl.format.PaperSize;
import jxl.format.UnderlineStyle;
import jxl.format.VerticalAlignment;
import jxl.write.DateFormat;
import jxl.write.DateTime;
import jxl.write.Label;
import jxl.write.Number;
import jxl.write.NumberFormat;
import jxl.write.WritableCellFeatures;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableImage;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class JXLClass {
public static String savePath = "D:"+java.io.File.separator+"saveDir";//文档所在目录
/**
* 练习使用JXL生成Excel文件
*/
public static void main(String[] args) {
String fileName = System.currentTimeMillis()+".xls";//以当前时间作为Excel的名称:2003版本的
String filePath = savePath+ java.io.File.separator + fileName;
System.out.println("文件路径:"+filePath);
File excelFile = new File(filePath);//文件所在具体路径
createExcel(excelFile);
}
public static void createExcel(File file){
System.out.println("生成Excel文件开始了!");
try {
String[] title={"序号","姓名","年龄","工资","出生日期","婚否","头像"};//标题数组
//1、创建可以写入的Excel工作簿
WritableWorkbook workBook = Workbook.createWorkbook(file);
//2、创建工作表
//createSheet(param1,param2):param1为当前工作表名称,param2表示是第几张表,从0开始
WritableSheet sheet = workBook.createSheet("工作表1", 0);//0表示第一张表
WritableSheet sheet2 = workBook.createSheet("工作表2", 1);
WritableSheet sheet3 = workBook.createSheet("工作表3", 2);
//3、设置打印属性
sheet.getSettings().setOrientation(PageOrientation.LANDSCAPE) ;// 设置为横向打印
sheet.getSettings().setPaperSize(PaperSize.A4);//设置纸张A4
sheet.getSettings().setFitHeight(297);//打印区高度
sheet.getSet