poi
TraceNL
这个作者很懒,什么都没留下…
展开
-
02 poi导致中文excel
poi导致中文excel List<Map<String, Object>> exportList = dsjService.getExportList(dsjDetail); String[][] map = { {"序号","ID"}, {"需求类型","XQ_TYPE"}, {"标题","TITLE"}, {"正文","GD_INFO"}, {"工单发起时间","CREATE_DATE_SHOW"}, {"发起人","OPER_NAME"}, {..原创 2021-02-24 22:00:59 · 57 阅读 · 0 评论 -
06 xlsx添加水印
1、引入maven配置 <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>3.16</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <.原创 2021-02-22 21:50:33 · 460 阅读 · 0 评论 -
05 读取xlsx
读取简单的xlsx package test02; import org.apache.poi.xssf.usermodel.XSSFCell; import org.apache.poi.xssf.usermodel.XSSFRow; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import java.io.File; import java.i.原创 2021-02-22 21:47:46 · 248 阅读 · 1 评论 -
04 读取简单xls的
读取简单的数据 package test02; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import java.io.File; import java.io..原创 2021-02-22 21:46:40 · 54 阅读 · 0 评论 -
03 导出带样式的数据
导出带样式的excel package test01; import org.apache.poi.hssf.usermodel.*; import org.apache.poi.hssf.util.HSSFColor; import java.io.File; import java.io.FileOutputStream; public class ExportWithStyle { public static void main(String[] args) { St.原创 2021-02-22 21:45:45 · 66 阅读 · 0 评论