jlSheetExcel.java
2.41 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
package com.hui.iqiyi.excel;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentStyle;
import com.alibaba.excel.annotation.write.style.HeadStyle;
import lombok.Data;
import org.apache.poi.ss.usermodel.HorizontalAlignment;
@Data
@HeadStyle(horizontalAlignment = HorizontalAlignment.CENTER)//表头样式
@ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER)//内容样式
@ColumnWidth(40)//表头宽度
public class jlSheetExcel {
//节目名称
@ExcelProperty("节目名称")
private String name;
//节目类型
@ExcelProperty("节目类型")
private String elementType;
//爱奇艺id
@ExcelProperty("爱奇艺id")
private Long externalId;
//节目内容分类
@ExcelProperty("节目内容分类")
private String cname;
//上映年份
@ExcelProperty("上映年份")
private String year;
//首播日期
@ExcelProperty("首播日期")
private String publishTime;
//节目描述
@ExcelProperty("节目描述")
private String desc ;
//节目标签
@ExcelProperty("节目标签")
private String tags;
//节目图片路径
@ExcelProperty("节目图片路径")
private String picUrl;
//导演
@ExcelProperty("导演")
private String directors;
//主演
@ExcelProperty("主演")
private String mainActors;
//编剧
@ExcelProperty("编剧")
private String writers;
//明星
@ExcelProperty("明星")
private String stars;
//索引名称
@ExcelProperty("索引名称")
private String searchName;
//评分
@ExcelProperty("评分")
private String score;
//地区
@ExcelProperty("地区")
private String country;
//语言
@ExcelProperty("语言")
private String language;
//爱奇艺节目id
@ExcelProperty("爱奇艺节目id")
private Long iqiyiContentId;
//码流id
@ExcelProperty("码流id")
private String vid;
//清晰度
@ExcelProperty("清晰度")
private String bitrate;
//时长
@ExcelProperty("时长")
private String duration;
//tar包大小
@ExcelProperty("tar包大小")
private String fileSize;
//下载状态
@ExcelProperty("下载状态")
private Long localStatus;
//下载地址
@ExcelProperty("下载地址")
private String localPath;
}