POI dataFormat种类
来源:互联网 发布:python list转字典 编辑:程序博客网 时间:2024/04/29 22:27
POI dataFormat种类
http://blog.csdn.net/phoenixx123/article/details/12720431
环境:POI3.9 自定义DataFormat
- Utility to identify builtin formats. Now can handle user defined data formats also. The following is a list of the formats as returned by this class.
- 0, "General"
- 1, "0"
- 2, "0.00"
- 3, "#,##0"
- 4, "#,##0.00"
- 5, "($#,##0_);($#,##0)"
- 6, "($#,##0_);[Red]($#,##0)"
- 7, "($#,##0.00);($#,##0.00)"
- 8, "($#,##0.00_);[Red]($#,##0.00)"
- 9, "0%"
- 0xa, "0.00%"
- 0xb, "0.00E+00"
- 0xc, "# ?/?"
- 0xd, "# ??/??"
- 0xe, "m/d/yy"
- 0xf, "d-mmm-yy"
- 0x10, "d-mmm"
- 0x11, "mmm-yy"
- 0x12, "h:mm AM/PM"
- 0x13, "h:mm:ss AM/PM"
- 0x14, "h:mm"
- 0x15, "h:mm:ss"
- 0x16, "m/d/yy h:mm"
- // 0x17 - 0x24 reserved for international and undocumented 0x25, "(#,##0_);(#,##0)"
- 0x26, "(#,##0_);[Red](#,##0)"
- 0x27, "(#,##0.00_);(#,##0.00)"
- 0x28, "(#,##0.00_);[Red](#,##0.00)"
- 0x29, "_(*#,##0_);_(*(#,##0);_(* \"-\"_);_(@_)"
- 0x2a, "_($*#,##0_);_($*(#,##0);_($* \"-\"_);_(@_)"
- 0x2b, "_(*#,##0.00_);_(*(#,##0.00);_(*\"-\"??_);_(@_)"
- 0x2c, "_($*#,##0.00_);_($*(#,##0.00);_($*\"-\"??_);_(@_)"
- 0x2d, "mm:ss"
- 0x2e, "[h]:mm:ss"
- 0x2f, "mm:ss.0"
- 0x30, "##0.0E+0"
- 0x31, "@" - This is text format.
- 0x31 "text" - Alias for "@"
自定义不用愁格式了。
refurl:http://www.javadocexamples.com/org/apache/poi/hssf/usermodel/org.apache.poi.hssf.usermodel.HSSFDataFormat.html
http://blog.csdn.net/caihaijiang/article/details/6381948
http://www.cnblogs.com/cndavy/archive/2012/09/24/2700109.html
http://www.blogjava.net/Angi/articles/342857.html
0 0
- POI dataFormat种类
- poi Dataformat种类
- POI dataFormat种类
- 杂记 - RegExp TextArea dataFormat
- dataformat 格式化字符串
- AdvancedDataGrid 和 excel的dataFormat
- Data类与DataFormat类
- python dataformat.py通用数据格式转化脚本
- Java Data使用DataFormat类简单格式化
- Spring MVC 集成 jackson-dataformat-xml 问题
- 利用jackson-dataformat-csv读写csv文件
- Uncaught TypeError:option dataFormat is not recognized
- poi
- POI
- POI
- POI
- POI
- poi
- Android ExifInterface 学习笔记,图片旋转的操作。
- 如何看懂源代码--(分析源代码方法)
- 线程小球
- Linux内核驱动之GPIO子系统(一)GPIO的使用
- 基于maven的ssh框架搭建
- POI dataFormat种类
- Linux下快速使用makedown
- iOS图片上传
- AJAX中XMLHttpRequest对象详解(1)
- ZOJ1050
- OpenGL实现Volume Rendering 大致步骤
- Squid 服务启动脚本
- 小狗踢足球
- uva 10271 Chopsticks