/** * 重命名sheet * * @param sheet sheet需要,0表示第一个sheet * @param sheetName 新的sheet名 * @return this * @since 4.1.8 */ public ExcelWriter renameSheet(int sheet, String sheetName) { this.workbook.setSheetName(sheet, sheetName); return this; }
/** * 重命名sheet * * @param sheet sheet需要,0表示第一个sheet * @param sheetName 新的sheet名 * @return this * @since 4.1.8 */ public ExcelWriter renameSheet(int sheet, String sheetName) { this.workbook.setSheetName(sheet, sheetName); return this; }
data.wb.setSheetName( data.wb.getSheetIndex( data.sheet ), data.realSheetname );
Context context = PoiTransformer.createInitialContext(); Workbook workbook = WorkbookFactory.create(templateInputStream); workbook.setSheetName(0, "newName");//Changing name of the first sheet PoiTransformer transformer = PoiTransformer.createTransformer(workbook); transformer.setOutputStream(resultOutputstream); JxlsHelper.getInstance().processTemplate(context, transformer);
/** * 重命名sheet * * @param sheet sheet需要,0表示第一个sheet * @param sheetName 新的sheet名 * @return this * @since 4.1.8 */ public ExcelWriter renameSheet(int sheet, String sheetName) { this.workbook.setSheetName(sheet, sheetName); return this; }
/** * 创建工作表 * * @param sheetNo sheet数量 * @param index 序号 */ public void createSheet(double sheetNo, int index) { this.sheet = workbook.createSheet(); // 设置工作表的名称. if (sheetNo == 0) { workbook.setSheetName(index, sheetName); } else { workbook.setSheetName(index, sheetName + index); } }
public void setName(String name) { Workbook workbook = sheet.getWorkbook(); workbook.setSheetName(workbook.getSheetIndex(sheet), name); }
private void cloneSheet(org.apache.poi.ss.usermodel.Workbook hssfWorkbook, int index, String name) { org.apache.poi.ss.usermodel.Sheet hssfSheet = hssfWorkbook.cloneSheet(index); for (int i = 0; i < hssfWorkbook.getNumberOfSheets(); i++) { if(hssfSheet.equals(hssfWorkbook.getSheetAt(i))) { hssfWorkbook.setSheetName(i, name); break; } } }
private void cloneSheet(org.apache.poi.ss.usermodel.Workbook hssfWorkbook, int index, String name) { org.apache.poi.ss.usermodel.Sheet hssfSheet = hssfWorkbook.cloneSheet(index); for (int i = 0; i < hssfWorkbook.getNumberOfSheets(); i++) { if(hssfSheet.equals(hssfWorkbook.getSheetAt(i))) { hssfWorkbook.setSheetName(i, name); break; } } }
/** * Creates a clone of the specified sheet. * @param oldName the name of original sheet * @param newName the created sheet name * @throws IllegalArgumentException if some parameters were {@code null} */ public void copy(String oldName, String newName) { if (oldName == null) { throw new IllegalArgumentException("oldName must not be null"); //$NON-NLS-1$ } if (newName == null) { throw new IllegalArgumentException("newName must not be null"); //$NON-NLS-1$ } Workbook workbook = info.workbook; int oldIndex = workbook.getSheetIndex(oldName); if (oldIndex < 0) { throw new IllegalArgumentException(); } Sheet newSheet = workbook.cloneSheet(oldIndex); int newIndex = workbook.getSheetIndex(newSheet); workbook.setSheetName(newIndex, newName); }
wb.setSheetName(sheetNumber, sheetName); try { FileOutputStream out = new FileOutputStream(xlsFilename);
public Workbook createExcleByTemplate(TemplateExportParams params, Map<Integer, Map<String, Object>> map) { // step 1. 判断模板的地址 if (params == null || map == null || StringUtils.isEmpty(params.getTemplateUrl())) { throw new ExcelExportException(ExcelExportEnum.PARAMETER_ERROR); } Workbook wb = null; // step 2. 判断模板的Excel类型,解析模板 try { this.teplateParams = params; wb = getCloneWorkBook(); // step 3. 解析模板 for (int i = 0, le = params.isScanAllsheet() ? wb.getNumberOfSheets() : params.getSheetNum().length; i < le; i++) { if (params.getSheetName() != null && params.getSheetName().length > i && StringUtils.isNotEmpty(params.getSheetName()[i])) { wb.setSheetName(i, params.getSheetName()[i]); } tempCreateCellSet.clear(); parseTemplate(wb.getSheetAt(i), map.get(i), params.isColForEach()); } } catch (Exception e) { LOGGER.error(e.getMessage(), e); return null; } return wb; }
public Workbook createExcleByTemplate(TemplateExportParams params, Map<Integer, Map<String, Object>> map) { // step 1. 判断模板的地址 if (params == null || map == null || StringUtils.isEmpty(params.getTemplateUrl())) { throw new ExcelExportException(ExcelExportEnum.PARAMETER_ERROR); } Workbook wb = null; // step 2. 判断模板的Excel类型,解析模板 try { this.teplateParams = params; wb = getCloneWorkBook(); // step 3. 解析模板 for (int i = 0, le = params.isScanAllsheet() ? wb.getNumberOfSheets() : params.getSheetNum().length; i < le; i++) { if (params.getSheetName() != null && params.getSheetName().length > i && StringUtils.isNotEmpty(params.getSheetName()[i])) { wb.setSheetName(i, params.getSheetName()[i]); } tempCreateCellSet.clear(); parseTemplate(wb.getSheetAt(i), map.get(i), params.isColForEach()); } } catch (Exception e) { LOGGER.error(e.getMessage(), e); return null; } return wb; }
/** * Clones the current sheet. * * @see Workbook#cloneSheet(int) */ public ExportSheet cloneSheet(final int sheetNum, final String name) { final ExportSheet originSheet = getSheet(sheetNum); final Sheet poiSheet = this.poiWorkbook.cloneSheet(sheetNum); this.poiWorkbook.setSheetName(sheets.size(), name); ContentProvider cp = getContentProvider(); if (contentProvider != null) { cp = contentProvider; } else { cp = ExportConfig.getInstance().createNewContentProvider(this); } final ExportSheet sheet = new ExportSheet(cp, poiSheet.getSheetName(), poiSheet); sheet.setImported(originSheet.isImported()); sheets.add(sheet); return sheet; }
wb.setSheetName(i, params.getSheetName()[i]);
if (!isSpreadsheetToRemove(spreadsheetName)) { if (isSpreadsheetToRename(spreadsheetName)) { hssfWorkbook.setSheetName(sheetNo, getSpreadsheetToReName(spreadsheetName)); for(int sheetNo = 0; sheetNo < excludedSheets.size(); sheetNo++) { String spreadsheetName = (String) excludedSheets.get(0); hssfWorkbook.setSheetName(hssfWorkbook.getSheetIndex(spreadsheetName), spreadsheetName.substring(configuration.getExcludeSheetProcessingMark().length()));
if (!isSpreadsheetToRemove(spreadsheetName)) { if (isSpreadsheetToRename(spreadsheetName)) { hssfWorkbook.setSheetName(sheetNo, getSpreadsheetToReName(spreadsheetName)); for(int sheetNo = 0; sheetNo < excludedSheets.size(); sheetNo++) { String spreadsheetName = (String) excludedSheets.get(0); hssfWorkbook.setSheetName(hssfWorkbook.getSheetIndex(spreadsheetName), spreadsheetName.substring(configuration.getExcludeSheetProcessingMark().length()));
if (params.getSheetName() != null && params.getSheetName().length > i && StringUtils.isNotEmpty(params.getSheetName()[i])) { wb.setSheetName(i, params.getSheetName()[i]);
if (params.getSheetName() != null && params.getSheetName().length > i && StringUtils.isNotEmpty(params.getSheetName()[i])) { wb.setSheetName(i, params.getSheetName()[i]);
if (params.getSheetName() != null && params.getSheetName().length > i && StringUtils.isNotEmpty(params.getSheetName()[i])) { wb.setSheetName(i, params.getSheetName()[i]);