grapes.pack
类 JXLExcel
java.lang.Object
grapes.pack.JXLExcel
public class JXLExcel
- extends java.lang.Object
Excel文件导入导出
- 作者:
- JSPGen
方法摘要 |
boolean |
exportExcel(java.lang.Object obj,
java.util.List<java.util.Map<java.lang.Object,java.lang.Object>> list)
|
boolean |
exportExcel(java.lang.Object obj,
java.util.List<java.util.Map<java.lang.Object,java.lang.Object>> list,
java.lang.String name)
|
boolean |
exportExcel(java.lang.Object obj,
java.lang.Object keys,
java.util.List<java.util.Map<java.lang.Object,java.lang.Object>> list,
java.lang.String name)
导出Excel文件 |
java.util.List<java.util.Map<java.lang.Object,java.lang.Object>> |
importExcel(java.lang.String filepath)
|
java.util.List<java.util.Map<java.lang.Object,java.lang.Object>> |
importExcel(java.lang.String filepath,
int line)
|
java.util.List<java.util.Map<java.lang.Object,java.lang.Object>> |
importExcel(java.lang.String filepath,
java.lang.String[] keys,
java.lang.String name,
int line)
导入Excel文件 |
java.util.List<java.util.Map<java.lang.Object,java.lang.Object>> |
importExcel(java.lang.String filepath,
java.lang.String name,
int line)
|
从类 java.lang.Object 继承的方法 |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
JXLExcel
public JXLExcel()
exportExcel
public boolean exportExcel(java.lang.Object obj,
java.lang.Object keys,
java.util.List<java.util.Map<java.lang.Object,java.lang.Object>> list,
java.lang.String name)
- 导出Excel文件
- 参数:
obj
- 保存对象(String、File、OutputStream)keys
- 标题集合(String[]、Map[此Map中key与数据集Map中key一致,此Map中value可以是要显示的字符串,默认为数据集Map中key的数组集合])list
- 数据集name
- 表名称(默认:Sheet1)
- 返回:
- boolean
exportExcel
public boolean exportExcel(java.lang.Object obj,
java.util.List<java.util.Map<java.lang.Object,java.lang.Object>> list,
java.lang.String name)
exportExcel
public boolean exportExcel(java.lang.Object obj,
java.util.List<java.util.Map<java.lang.Object,java.lang.Object>> list)
importExcel
public java.util.List<java.util.Map<java.lang.Object,java.lang.Object>> importExcel(java.lang.String filepath,
java.lang.String[] keys,
java.lang.String name,
int line)
- 导入Excel文件
- 参数:
filepath
- 文件路径(本地或网络)keys
- 标题集合(为数据集Map中key值服务,从0开始)name
- 表名称(默认:Sheet1)line
- 数据开始行数(默认从0开始)
- 返回:
- List
importExcel
public java.util.List<java.util.Map<java.lang.Object,java.lang.Object>> importExcel(java.lang.String filepath,
java.lang.String name,
int line)
importExcel
public java.util.List<java.util.Map<java.lang.Object,java.lang.Object>> importExcel(java.lang.String filepath,
int line)
importExcel
public java.util.List<java.util.Map<java.lang.Object,java.lang.Object>> importExcel(java.lang.String filepath)