- 博客(6)
- 资源 (1)
- 收藏
- 关注
原创 poi 规则copy
/** * rowコピー * @param srcRow * @param desRow */ private void copyRow(Row srcRow, Row desRow) { Iterator<Cell> it = srcRow.cellIterator(); desRow.setHeight(srcRow.getHeight()); while (it.hasNext())...
2021-10-29 11:12:59 316
原创 java获取对象定义名和值
private static List getFiledsInfo(Object o){ Field[] fields=o.getClass().getDeclaredFields(); String[] fieldNames=new String[fields.length]; List list = new ArrayList(); Map infoMap=null; for(in...
2021-09-18 18:19:54 395
原创 No Persistence provider for EntityManager named
“No Persistence provider for EntityManager named”查看下面的路径下的persistence.xml是不是最新的WEB-INF\classes\META-INF
2021-08-17 11:14:46 289
原创 POI 设定excel的打印范围
int sheetIndex = wb.getSheetIndex(this.sheet); String oldPrintRange = wb.getPrintArea(sheetIndex); System.out.println(oldPrintRange); int maxRowPrint = 5 + this.gem3List.size(); String newPrintRange = oldPrintRange.substri..
2021-07-28 11:29:27 1172
转载 poi 复制规则
if(!ruleSetted) { SheetConditionalFormatting scf =sheet.getSheetConditionalFormatting(); List<ConditionalFormattingRule> ruleList=getConditionalRule(srcCell); CellRangeAddress[] regions= {new CellRangeAddress(8,...
2021-07-27 16:08:02 412
原创 poi 复制下拉框内容入力规则
在poi中,下拉框里面有两种格式入力,一种是通过入力规则直接有数据进行复制另一种是通过引用其他sheet或者是单元格的内容进行list显示的private void xxcopy() { List<? extends DataValidation> validations = sheet.getDataValidations(); for(DataValidation validation : validations){ Cell...
2021-07-27 14:31:21 674
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人