java/ExcelUtil.java · secondriver/bullshit-codes

Fetch the repository succeeded.

richgiteeai

Watch

Unwatch Watching Releases Only Ignoring

1 Star 0 Fork 462

secondriver/bullshit-codes

forked from Gitee Community/bullshit-codes

Code Issues 0 Pull Requests 0 Wiki Insights Pipelines

Service

Tencent Cloud Serverless

Create your Gitee Account

Explore and code with more than 14 million developers,Free private repositories !:)

Already have an account? Sign in

文件

master

Branches (1)

Manage

master

Clone or Download

Clone/Download

HTTPS SSH SVN SVN+SSH Download ZIP

Prompt

To download the code, please copy the following command and execute it in the terminal

To ensure that your submitted code identity is correctly recognized by Gitee, please execute the following command.

git config --global user.name userName 
git config --global user.email userEmail

When using the SSH protocol for the first time to clone or push code, follow the prompts below to complete the SSH configuration.

1 Generate RSA keys.

2 Obtain the content of the RSA public key and configure it in SSH Public Keys

To use SVN on Gitee, please visit the usage guide

When using the HTTPS protocol, the command line will prompt for account and password verification as follows. For security reasons, Gitee recommends configure and use personal access tokens instead of login passwords for cloning, pushing, and other operations.

Username for 'https://gitee.com': userName

Password for 'https://userName@gitee.com': # Private Token

Branches 1

Tags 0

bullshit-codes

java

ExcelUtil.java

ExcelUtil.java 2.95 KB

/**
 * 锁表 
 * @param workbook 
 * @param sheetIndex 
 * @param plusClass 
 * @throws Exception 
 */
 public static void lockSheet(Workbook workbook, int sheetIndex, Class<? extends ExcelPlus> plusClass,String password) throws Exception {

// final short STRING_FORMAT = (short) BuiltinFormats.getBuiltinFormat("TEXT");
 // final Sheet sheet0 = workbook.getSheetAt(sheetIndex);
 // sheet0.protectSheet(password);
 // final CellStyle lockCellStyle = workbook.createCellStyle();
 // lockCellStyle.setAlignment(HorizontalAlignment.CENTER);
 // lockCellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
 // lockCellStyle.setDataFormat(STRING_FORMAT);
 // lockCellStyle.setLocked(true);
 // final CellStyle unlockCellStyle = workbook.createCellStyle();
 // unlockCellStyle.setAlignment(HorizontalAlignment.CENTER);
 // unlockCellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
 // unlockCellStyle.setDataFormat(STRING_FORMAT);
 // unlockCellStyle.setLocked(false);

// final Field[] fields = plusClass.getDeclaredFields();
 // ExportParams entity = new ExportParams();
 // List<PlusExcelExportEntity> excelParams = new ArrayList<PlusExcelExportEntity>();
 // PlusExportCommonService plusExportCommonService = new PlusExportCommonService();
 // ExcelTarget etarget = plusClass.getAnnotation(ExcelTarget.class);
 // String targetId = etarget == null ? null : etarget.value();
 // plusExportCommonService.getAllExcelFieldPlus(entity.getExclusions(), targetId, fields, excelParams, plusClass,
 // null, null);
 // //排序
 // plusExportCommonService.sortAllParamsPlus(excelParams);
 // final int lastRowNum = sheet0.getLastRowNum()+1;
 // final ExcelPlus excelPlus = plusClass.newInstance();
 // final int dataStartRowIndex = (Integer)plusClass.getMethod("dataStartRowIndex").invoke(excelPlus);
 // for (int i = 0; i < excelParams.size(); i++) {

// if(excelParams.get(i).isLock()){

// for (int i1 = dataStartRowIndex; i1 < lastRowNum; i1++) {
 // final CellStyle cellStyle = sheet0.getRow(i1).getCell(i).getCellStyle();
 // cellStyle.setLocked(true);
 
 //坑爹的api,得到原本的cellStyle直接setLocked无效,必须得重新setCellStyle
 sheet0.getRow(i1).getCell(i).setCellStyle(lockCellStyle);
 // }
 // }else{
 // for (int i1 = dataStartRowIndex; i1 < lastRowNum; i1++) {
 //final CellStyle cellStyle = sheet0.getRow(i1).getCell(i).getCellStyle();
 // cellStyle.setLocked(false);
 sheet0.getRow(i1).getCell(i).setCellStyle(unlockCellStyle);
 // }
 // }
 // }
 }

Copy Edit Raw Blame History

邓峰峰 authored 2019年06月10日 14:10 +08:00 . poi setCellStyle和getCellStyle的问题

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57

/**
 * 锁表 
 * @param workbook 
 * @param sheetIndex 
 * @param plusClass 
 * @throws Exception 
 */
 public static void lockSheet(Workbook workbook, int sheetIndex, Class<? extends ExcelPlus> plusClass,String password) throws Exception {

 // final short STRING_FORMAT = (short) BuiltinFormats.getBuiltinFormat("TEXT");
 // final Sheet sheet0 = workbook.getSheetAt(sheetIndex);
 // sheet0.protectSheet(password);
 // final CellStyle lockCellStyle = workbook.createCellStyle();
 // lockCellStyle.setAlignment(HorizontalAlignment.CENTER);
 // lockCellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
 // lockCellStyle.setDataFormat(STRING_FORMAT);
 // lockCellStyle.setLocked(true);
 // final CellStyle unlockCellStyle = workbook.createCellStyle();
 // unlockCellStyle.setAlignment(HorizontalAlignment.CENTER);
 // unlockCellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
 // unlockCellStyle.setDataFormat(STRING_FORMAT);
 // unlockCellStyle.setLocked(false);


 // final Field[] fields = plusClass.getDeclaredFields();
 // ExportParams entity = new ExportParams();
 // List<PlusExcelExportEntity> excelParams = new ArrayList<PlusExcelExportEntity>();
 // PlusExportCommonService plusExportCommonService = new PlusExportCommonService();
 // ExcelTarget etarget = plusClass.getAnnotation(ExcelTarget.class);
 // String targetId = etarget == null ? null : etarget.value();
 // plusExportCommonService.getAllExcelFieldPlus(entity.getExclusions(), targetId, fields, excelParams, plusClass,
 // null, null);
 // //排序
 // plusExportCommonService.sortAllParamsPlus(excelParams);
 // final int lastRowNum = sheet0.getLastRowNum()+1;
 // final ExcelPlus excelPlus = plusClass.newInstance();
 // final int dataStartRowIndex = (Integer)plusClass.getMethod("dataStartRowIndex").invoke(excelPlus);
 // for (int i = 0; i < excelParams.size(); i++) {

 // if(excelParams.get(i).isLock()){

 // for (int i1 = dataStartRowIndex; i1 < lastRowNum; i1++) {
 // final CellStyle cellStyle = sheet0.getRow(i1).getCell(i).getCellStyle();
 // cellStyle.setLocked(true);
 
 //坑爹的api,得到原本的cellStyle直接setLocked无效,必须得重新setCellStyle
 sheet0.getRow(i1).getCell(i).setCellStyle(lockCellStyle);
 // }
 // }else{
 // for (int i1 = dataStartRowIndex; i1 < lastRowNum; i1++) {
 //final CellStyle cellStyle = sheet0.getRow(i1).getCell(i).getCellStyle();
 // cellStyle.setLocked(false);
 sheet0.getRow(i1).getCell(i).setCellStyle(unlockCellStyle);
 // }
 // }
 // }
 }