public class CsvDownloadUtil extends BaseUtil
限定符和类型 | 字段和说明 |
---|---|
protected static String |
cellPrefix
为单元格数据增加后缀,用来支持 Excel 中正确显示格式
|
protected static String |
cellSuffix
为单元格数据增加后缀,用来支持 Excel 中正确显示格式
|
protected static String |
fileCharset |
protected static Boolean |
preserveSpaces
是否保留数据两边的空格
|
构造器和说明 |
---|
CsvDownloadUtil() |
限定符和类型 | 方法和说明 |
---|---|
protected static String |
getConvertedMapValue(Object val) |
static String |
getFileName(String displayName)
getFileName
|
static String |
saveFile(String filePath,
String fileName,
List<KeyValuePair> headList,
List<Map<String,Object>> dataList,
List<Map<String,Object>> sumList,
Boolean isAppend) |
static void |
setCellPrefix(String prefix) |
static void |
setCellSuffix(String suffix) |
static void |
setCharset(String charset) |
static void |
setPreserveSpaces(Boolean allowSpaces) |
convertMapValue
protected static String fileCharset
protected static String cellPrefix
protected static String cellSuffix
protected static Boolean preserveSpaces
public static String getFileName(String displayName)
displayName
- download file displayNamepublic static final String saveFile(String filePath, String fileName, List<KeyValuePair> headList, List<Map<String,Object>> dataList, List<Map<String,Object>> sumList, Boolean isAppend)
filePath
- 输出文件路径fileName
- 输出文件headList
- 表头列表dataList
- 数据列表sumList
- 总计列表isAppend
- 是否文件追加数据public static void setCellPrefix(String prefix)
public static void setCellSuffix(String suffix)
public static void setCharset(String charset)
public static void setPreserveSpaces(Boolean allowSpaces)
Copyright © 2015 jiucai.org. All rights reserved.