Java Region类代码示例

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› Java›Java编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了Java中org.apache.poi.hssf.util.Region类的典型用法代码示例。如果您正苦于以下问题：Java Region类的具体用法？Java Region怎么用？Java Region使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

Region类属于org.apache.poi.hssf.util包，在下文中一共展示了Region类的14个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的Java代码示例。

示例1: pushSheetToExcelBySQL

import org.apache.poi.hssf.util.Region; //导入依赖的package包/类
/**可重复调用以达到在一个工作簿生成多个Sheet的目的*/
	private void pushSheetToExcelBySQL(String title,String sql,String SheetName){
		writerDataBySQL(sql);
		//创建工作表
		HSSFSheet sheet = wb.createSheet(SheetName);
		HSSFRow row ;
		HSSFCell cell ;
		//创建标题
		row = sheet.createRow(0);
		cell = row.createCell(0);
		cell.setCellValue(new HSSFRichTextString(title));
		cell.setCellStyle(titleStyle);
		sheet.addMergedRegion(new Region(0,(short)0,0,(short)(ColNum-1)));//合并单元格
//		System.out.println(RowNum+":"+ColNum);
		//创建正文
		for (int i=0;i<RowNum;i++){
			row = sheet.createRow(i+1);
			for (int j=0;j<ColNum;j++){
				cell = row.createCell(j);
				cell.setCellValue(new HSSFRichTextString(tables.get(i)[j].trim()));
				cell.setCellStyle(contentStyle);
			}
		}
	}

开发者ID:Kuangcp，项目名称:JavaToolKit，代码行数:25，代码来源:TableTurnExcel.java

示例2: listTurnSheet

import org.apache.poi.hssf.util.Region; //导入依赖的package包/类
/**
	 *
	 * @param title 标题
	 * @param data 数据 List String数组
	 * @param SheetName 单个Sheet名字
	 */
	private void listTurnSheet(String title,List<String[]> data,String SheetName){
		HSSFSheet sheet = wb.createSheet(SheetName);
		HSSFRow row ;
		HSSFCell cell ;
		int ColNum = data.get(0).length;
		int RowNum = data.size();
		//创建标题
		row = sheet.createRow(0);
		cell = row.createCell(0);
		cell.setCellValue(new HSSFRichTextString(title));
		cell.setCellStyle(titleStyle);
		sheet.addMergedRegion(new Region(0,(short)0,0,(short)(ColNum-1)));//合并单元格
//		System.out.println(RowNum+":"+ColNum);
		//创建正文
		for (int i=0;i<RowNum;i++){
			row = sheet.createRow(i+1);
			for (int j=0;j<ColNum;j++){
				cell = row.createCell(j);
				cell.setCellValue(new HSSFRichTextString(data.get(i)[j].trim()));
				cell.setCellStyle(contentStyle);
			}
		}
	}

开发者ID:Kuangcp，项目名称:JavaToolKit，代码行数:30，代码来源:TableTurnExcel.java

示例3: generateLogo

import org.apache.poi.hssf.util.Region; //导入依赖的package包/类
public void generateLogo(Sheet sheet, int length, Workbook wb, String basePath, Image image) {
    if (image == null) {
        return;
    }

    ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();
    BufferedImage bufferImg;
    HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 220, 200,
            (short) image.getColFrom(), image.getRowFrom(), (short) (image.getColTo()), image.getRowTo());
    try {
        HSSFSheet xlsSheet = (HSSFSheet) sheet;
        String imageFilePath = "d:/app/tmp";
        bufferImg = ImageIO.read(new File(basePath + imageFilePath));
        ImageIO.write(bufferImg, "jpg", byteArrayOut);
        xlsSheet.addMergedRegion(new Region(image.getRowFrom(), (short) image.getColFrom(),
                image.getRowTo(), (short) (image.getColTo() - 1)));
        HSSFPatriarch patriarch = xlsSheet.createDrawingPatriarch();
        patriarch.createPicture(anchor, wb.addPicture(
                byteArrayOut.toByteArray(), HSSFWorkbook.PICTURE_TYPE_JPEG));
    } catch (IOException e) {
        e.printStackTrace();
    }
}

开发者ID:cgfalcon，项目名称:fluentexcel，代码行数:24，代码来源:XlsRender.java

示例4: getMergedCells

import org.apache.poi.hssf.util.Region; //导入依赖的package包/类
public static boolean[][] getMergedCells(HSSFSheet sheet) {
    int lastRowNum = sheet.getLastRowNum();
    short maxCellNum = getMaxCellNum(sheet);

    // Compute merged regions
    boolean[][] merged = new boolean[lastRowNum + 1][maxCellNum + 1];
    for (int i = 0; i < sheet.getNumMergedRegions(); i++) {
        Region region = sheet.getMergedRegionAt(i);
        for (int rowNum = region.getRowFrom(); rowNum <= region.getRowTo(); rowNum++) {
            for (int columnNum = region.getColumnFrom(); columnNum <= region.getColumnTo(); columnNum++) {
                if (rowNum != region.getRowFrom() || columnNum != region.getColumnFrom())
                    merged[rowNum][columnNum] = true;
            }
        }
    }

    return merged;
}

开发者ID:evlist，项目名称:orbeon-forms，代码行数:19，代码来源:XLSUtils.java

示例5: copySheet

import org.apache.poi.hssf.util.Region; //导入依赖的package包/类
public static void copySheet(HSSFWorkbook workbook, HSSFSheet destination, HSSFSheet source) {

        // Copy column width
        short maxCellNum = getMaxCellNum(source);
        for (short i = 0; i <= maxCellNum; i++) {
            destination.setColumnWidth(i, source.getColumnWidth(i));
        }

        // Copy merged cells
        for (int i = 0; i < source.getNumMergedRegions(); i++) {
            Region region = source.getMergedRegionAt(i);
            destination.addMergedRegion(region);
        }

        // Copy rows
        for (int i = 0; i <= source.getLastRowNum(); i++) {
            HSSFRow sourceRow = source.getRow(i);
            HSSFRow destinationRow = destination.createRow(i);
            copyRow(workbook, destinationRow, sourceRow);
        }
    }

开发者ID:evlist，项目名称:orbeon-forms，代码行数:22，代码来源:XLSUtils.java

示例6: copyRow

import org.apache.poi.hssf.util.Region; //导入依赖的package包/类
@SuppressWarnings({ "rawtypes", "unchecked" })
	public static void copyRow(HSSFSheet srcSheet, HSSFSheet destSheet, HSSFRow srcRow, HSSFRow destRow, Map<Integer, HSSFCellStyle> styleMap) {  
        Set mergedRegions = new TreeSet();  
        destRow.setHeight(srcRow.getHeight());  
        for (int j = srcRow.getFirstCellNum(); j <= srcRow.getLastCellNum(); j++) {  
            HSSFCell oldCell = srcRow.getCell(j);  
            HSSFCell newCell = destRow.getCell(j);  
            if (oldCell != null) {  
                if (newCell == null) {  
                    newCell = destRow.createCell(j);  
                }  
                copyCell(oldCell, newCell, styleMap);  
                Region mergedRegion = getMergedRegion(srcSheet, srcRow.getRowNum(), oldCell.getCellNum());  
                if (mergedRegion != null) {  
//	                    Region newMergedRegion = new Region( destRow.getRowNum(), mergedRegion.getColumnFrom(),  
//	                            destRow.getRowNum() + mergedRegion.getRowTo() - mergedRegion.getRowFrom(), mergedRegion.getColumnTo() );  
                    Region newMergedRegion = new Region(mergedRegion.getRowFrom(), mergedRegion.getColumnFrom(),  
                            mergedRegion.getRowTo(), mergedRegion.getColumnTo());  
                    if (isNewMergedRegion(newMergedRegion, mergedRegions)) {  
                        mergedRegions.add(newMergedRegion);  
                        destSheet.addMergedRegion(newMergedRegion);  
                    }  
                }  
            }  
        }  
          
    }

开发者ID:rmage，项目名称:gnvc-ims，代码行数:28，代码来源:MultiPageReportModel.java

示例7: getMergedRegion

import org.apache.poi.hssf.util.Region; //导入依赖的package包/类
public static Region getMergedRegion(HSSFSheet sheet, int rowNum, short cellNum) {  
    for (int i = 0; i < sheet.getNumMergedRegions(); i++) {  
        Region merged = sheet.getMergedRegionAt(i);  
        if (merged.contains(rowNum, cellNum)) {  
            return merged;  
        }  
    }  
    return null;  
}

开发者ID:rmage，项目名称:gnvc-ims，代码行数:10，代码来源:MultiPageReportModel.java

示例8: downloadXLSFileBase

import org.apache.poi.hssf.util.Region; //导入依赖的package包/类
public FileTransfer downloadXLSFileBase(List<String[]> list,
	String filename, String name) throws Exception {
if (list == null) {
	list = new ArrayList<String[]>();
}
ByteArrayOutputStream buffer = new ByteArrayOutputStream();
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet();

HSSFCellStyle cs = wb.createCellStyle();
cs.setBorderBottom(HSSFCellStyle.BORDER_THIN);
cs.setBorderLeft(HSSFCellStyle.BORDER_THIN);
cs.setBorderRight(HSSFCellStyle.BORDER_THIN);
cs.setBorderTop(HSSFCellStyle.BORDER_THIN);
cs.setAlignment(HSSFCellStyle.ALIGN_CENTER);
cs.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);

int columnCount = list.get(0).length;
sheet.setColumnWidth((short) 0, (short) 100);
sheet.addMergedRegion(new Region((short) 0, (short) 0, (short) 0,
		(short) columnCount));
for (int i = 1; i <= columnCount; i++) {
	sheet.setColumnWidth((short) i, (short) 4000);
}
// 表名
HSSFRow row1 = sheet.createRow(0);
HSSFCell cell = row1.createCell((short) 0);
// cell.setEncoding((short) 0);
cell.setCellValue(name);
cell.setCellStyle(cs);
row1.setHeight((short) 800);

HSSFRow rows = null;
for (int i = 0; i < list.size(); i++) {
	rows = sheet.createRow(i + 1);
	String cellDate[] = list.get(i);
	HSSFCell cells = null;
	for (int j = 0; j < cellDate.length; j++) {
		cells = rows.createCell((short) (j + 1));
		// cells.setEncoding((short) j);
		cells.setCellValue(cellDate[j]);
		cells.setCellStyle(cs);
	}
	if (i == 0) {
		rows.setHeight((short) 600);// 标题行宽
	}
}
wb.write(buffer);
return new FileTransfer(filename, "application/x-xls", buffer
		.toByteArray());
}

开发者ID:wufeisoft，项目名称:ryf_mms2，代码行数:52，代码来源:DownloadFile.java

示例9: downloadXLSFileBase

import org.apache.poi.hssf.util.Region; //导入依赖的package包/类
private FileTransfer downloadXLSFileBase(List<String[]> list,
		String filename, String name) throws Exception {
	if (list == null) {
		list = new ArrayList<String[]>();
	}
	ByteArrayOutputStream buffer = new ByteArrayOutputStream();
	HSSFWorkbook wb = new HSSFWorkbook();
	HSSFSheet sheet = wb.createSheet();

	HSSFCellStyle cs = wb.createCellStyle();
	cs.setBorderBottom(HSSFCellStyle.BORDER_THIN);
	cs.setBorderLeft(HSSFCellStyle.BORDER_THIN);
	cs.setBorderRight(HSSFCellStyle.BORDER_THIN);
	cs.setBorderTop(HSSFCellStyle.BORDER_THIN);
	cs.setAlignment(HSSFCellStyle.ALIGN_CENTER);
	cs.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);

	int columnCount = list.get(0).length;
	sheet.setColumnWidth((short) 0, (short) 100);
	sheet.addMergedRegion(new Region((short) 0, (short) 0, (short) 0,
			(short) columnCount));
	for (int i = 1; i <= columnCount; i++) {
		sheet.setColumnWidth((short) i, (short) 4000);
	}
	// 表名
	HSSFRow row1 = sheet.createRow(0);
	HSSFCell cell = row1.createCell((short) 0);
	// cell.setEncoding((short) 0);
	cell.setCellValue(name);
	cell.setCellStyle(cs);
	row1.setHeight((short) 800);

	HSSFRow rows = null;
	for (int i = 0; i < list.size(); i++) {
		rows = sheet.createRow(i + 1);
		String cellDate[] = list.get(i);
		HSSFCell cells = null;
		for (int j = 0; j < cellDate.length; j++) {
			cells = rows.createCell((short) (j + 1));
			// cells.setEncoding((short) j);
			cells.setCellValue(cellDate[j]);
			cells.setCellStyle(cs);
		}
		if (i == 0) {
			rows.setHeight((short) 600);// 标题行宽
		}
	}
	wb.write(buffer);
	return new FileTransfer(filename, "application/x-xls", buffer
			.toByteArray());
}

开发者ID:wufeisoft，项目名称:ryf_mms2，代码行数:52，代码来源:DownloadFileService.java

示例10: exportMotionExcel

import org.apache.poi.hssf.util.Region; //导入依赖的package包/类
/**
 * 为退款经办下载表
 * 
 * @param outfile
 * @param list
 * @param name
 *            表名
 * @param s为每一格的宽度
 * @throws IOException
 */
public FileTransfer exportMotionExcel(List<String[]> list, String filename,
		String name, String[] s) throws Exception {

	ByteArrayOutputStream buffer = new ByteArrayOutputStream();
	HSSFWorkbook wb = new HSSFWorkbook();
	HSSFSheet sheet = wb.createSheet();
	HSSFCellStyle cs = wb.createCellStyle();
	// 设置表头的格式
	HSSFCellStyle cs1 = wb.createCellStyle();
	HSSFFont f1 = wb.createFont();
	f1.setFontHeightInPoints((short) 20);// 字体大小
	cs1.setFont(f1);
	cs1.setAlignment(HSSFCellStyle.ALIGN_CENTER);

	// 设置表中的格�?
	cs.setBorderBottom(HSSFCellStyle.BORDER_THIN);
	cs.setBorderLeft(HSSFCellStyle.BORDER_THIN);
	cs.setBorderRight(HSSFCellStyle.BORDER_THIN);
	cs.setBorderTop(HSSFCellStyle.BORDER_THIN);
	cs.setAlignment(HSSFCellStyle.ALIGN_CENTER);
	cs.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
	cs.setWrapText(true);// 自动换行
	// 将页面设�为横向打印模�?
	HSSFPrintSetup hps = sheet.getPrintSetup();
	hps.setLandscape(true); // 将页面设置为横向打印模式
	hps.setPaperSize(HSSFPrintSetup.A4_PAPERSIZE);// 为A4纸的大小

	int columnCount = list.get(0).length;
	// 表头那一列的的宽�?
	sheet.setColumnWidth((short) 0, (short) 10000);
	// 合并单元�?
	// sheet.addMergedRegion(new Region((short) 0, (short) 0, (short) 0,
	// (short) (columnCount-1)));
	// 根据String[] s来设定每一格的宽度
	for (int i = 0; i < columnCount; i++) {
		sheet.setColumnWidth((short) i, (Short.parseShort(s[i])));
	}
	// 表名
	HSSFRow row1 = sheet.createRow(0);
	HSSFCell cell = row1.createCell(0);
	cell.setCellValue(name);
	cell.setCellStyle(cs1);
	row1.setHeight((short) 800);
	sheet.addMergedRegion(new Region((short) 0, (short) 0, (short) 0,
			(short) (columnCount - 1)));

	HSSFRow rows = null;
	for (int i = 0; i < list.size(); i++) {
		rows = sheet.createRow(i + 1);
		String cellDate[] = list.get(i);
		HSSFCell cells = null;
		for (int j = 0; j < cellDate.length; j++) {
			cells = rows.createCell((short) (j));
			cells.setCellValue(cellDate[j]);
			cells.setCellStyle(cs);
		}
		if (i == 0) {
			rows.setHeight((short) 600);// 标题行宽�?
		}
	}
	wb.write(buffer);
	return new FileTransfer(filename, "application/x-xls", buffer
			.toByteArray());
}

开发者ID:wufeisoft，项目名称:ryf_mms2，代码行数:75，代码来源:DownloadFileService.java

示例11: exportToExcel

import org.apache.poi.hssf.util.Region; //导入依赖的package包/类
public ActionForward exportToExcel(ActionMapping mapping, ActionForm actionForm, HttpServletRequest request,
        HttpServletResponse response) throws IOException {
    ParkingRequestSearch parkingRequestSearch = new ParkingRequestSearch();
    setSearchCriteria(request, parkingRequestSearch);
    parkingRequestSearch.doSearch();
    List<ParkingRequest> parkingRequestList = parkingRequestSearch.getSearchResult();
    StyledExcelSpreadsheet spreadsheet = new StyledExcelSpreadsheet("Pedidos_Parque", 15);
    spreadsheet.newHeaderRow();
    spreadsheet.addHeader("Categoria");
    spreadsheet.addHeader("Número");
    spreadsheet.addHeader("Nome", 9000);
    spreadsheet.addHeader("Estado");
    spreadsheet.addHeader("Data Pedido");
    spreadsheet.addHeader("Outras Informações", 6000);

    final ResourceBundle enumerationBundle = ResourceBundle.getBundle("resources.EnumerationResources", I18N.getLocale());
    for (ParkingRequest parkingRequest : parkingRequestList) {
        if (parkingRequest.getParkingParty().getParty().isPerson()) {
            Person person = (Person) parkingRequest.getParkingParty().getParty();
            spreadsheet.newRow();
            int firstRow = spreadsheet.getRow().getRowNum();
            spreadsheet.addCell(enumerationBundle.getString(parkingRequestSearch.getPartyClassification().name()));
            spreadsheet.addCell(parkingRequest.getParkingParty().getMostSignificantNumber());
            spreadsheet.addCell(person.getName());
            spreadsheet.addCell(enumerationBundle.getString(parkingRequest.getParkingRequestState().name()));
            spreadsheet.addDateTimeCell(parkingRequest.getCreationDate());
            if (!parkingRequest.getParkingParty().getDegreesInformation().isEmpty()) {
                Iterator<String> iterator = parkingRequest.getParkingParty().getDegreesInformation().iterator();
                String degreeInfo = iterator.next();
                spreadsheet.addCell(degreeInfo);
                while (iterator.hasNext()) {
                    spreadsheet.newRow();
                    degreeInfo = iterator.next();
                    spreadsheet.addCell(degreeInfo, 5);
                }
                int lastRow = firstRow + parkingRequest.getParkingParty().getDegreesInformation().size() - 1;
                if (firstRow != lastRow) {
                    for (int iter = 0; iter < 5; iter++) {
                        spreadsheet.getSheet().addMergedRegion(new Region(firstRow, (short) iter, lastRow, (short) iter));
                    }
                }
            }
        }
    }
    response.setContentType("application/vnd.ms-excel");
    response.setHeader("Content-Disposition", "attachment; filename=pedidos_parque.xls");
    final ServletOutputStream writer = response.getOutputStream();
    spreadsheet.getWorkbook().write(writer);
    writer.flush();
    response.flushBuffer();
    return null;
}

开发者ID:ist-dsi-archive，项目名称:fenix-parking，代码行数:53，代码来源:ParkingManagerDispatchAction.java

示例12: isNewMergedRegion

import org.apache.poi.hssf.util.Region; //导入依赖的package包/类
@SuppressWarnings("rawtypes")
private static boolean isNewMergedRegion(Region region, Collection mergedRegions) {  
       return !mergedRegions.contains(region);  
   }

开发者ID:rmage，项目名称:gnvc-ims，代码行数:5，代码来源:MultiPageReportModel.java

示例13: createHeader

import org.apache.poi.hssf.util.Region; //导入依赖的package包/类
private void createHeader(final StyledExcelSpreadsheet spreadsheet, final Degree degree) {
    // title
    spreadsheet.newHeaderRow();
    spreadsheet.addCell(degree.getName(), spreadsheet.getExcelStyle().getTitleStyle());

    // empty row
    spreadsheet.newHeaderRow();

    // table header
    spreadsheet.newHeaderRow();
    spreadsheet.addHeader(BundleUtil.getString(Bundle.APPLICATION, "label.candidacy.identification"));
    spreadsheet.addHeader(2, BundleUtil.getString(Bundle.APPLICATION, "label.candidacy.degree.and.school"));
    spreadsheet.addHeader(BundleUtil.getString(Bundle.APPLICATION, "label.candidacy.affinity"));
    spreadsheet.addHeader(BundleUtil.getString(Bundle.APPLICATION, "label.candidacy.degreeNature"));
    spreadsheet.addHeader(BundleUtil.getString(Bundle.APPLICATION, "label.candidacy.concludedUCs"));
    spreadsheet.addHeader(8, "");
    spreadsheet.addHeader(BundleUtil.getString(Bundle.APPLICATION, "label.candidacy.approvedEctsRate"));
    spreadsheet.addHeader(BundleUtil.getString(Bundle.APPLICATION, "label.candidacy.gradeRate"));
    spreadsheet.addHeader(BundleUtil.getString(Bundle.APPLICATION, "label.candidacy.degreeTransfer.seriesCandidacyGrade"));
    spreadsheet.addHeader(BundleUtil.getString(Bundle.APPLICATION, "label.candidacy.result"));

    spreadsheet.newHeaderRow();
    spreadsheet.addHeader(BundleUtil.getString(Bundle.APPLICATION, "label.number"));
    spreadsheet.addHeader(BundleUtil.getString(Bundle.APPLICATION, "label.name"));
    spreadsheet.addHeader(5, BundleUtil.getString(Bundle.APPLICATION, "label.number"));
    spreadsheet.addHeader(BundleUtil.getString(Bundle.APPLICATION, "label.candidacy.gradeSum.abbr"));
    spreadsheet.addHeader(BundleUtil.getString(Bundle.APPLICATION, "label.candidacy.approvedEcts"));
    spreadsheet.addHeader(BundleUtil.getString(Bundle.APPLICATION, "label.candidacy.enroledEcts"));

    // Id + Nº + Nome merge
    spreadsheet.getSheet().addMergedRegion(new Region(2, (short) 0, 2, (short) 1));
    // Degree name merge
    spreadsheet.getSheet().addMergedRegion(new Region(2, (short) 2, 3, (short) 2));
    // affinity merge
    spreadsheet.getSheet().addMergedRegion(new Region(2, (short) 3, 3, (short) 3));
    // degreeNature merge
    spreadsheet.getSheet().addMergedRegion(new Region(2, (short) 4, 3, (short) 4));
    // UCs merge
    spreadsheet.getSheet().addMergedRegion(new Region(2, (short) 5, 2, (short) 7));
    // A merge
    spreadsheet.getSheet().addMergedRegion(new Region(2, (short) 9, 3, (short) 9));
    // B merge
    spreadsheet.getSheet().addMergedRegion(new Region(2, (short) 10, 3, (short) 10));
    // C merge
    spreadsheet.getSheet().addMergedRegion(new Region(2, (short) 11, 3, (short) 11));
    // result merge
    spreadsheet.getSheet().addMergedRegion(new Region(2, (short) 12, 3, (short) 12));
}

开发者ID:FenixEdu，项目名称:fenixedu-academic，代码行数:49，代码来源:DegreeTransferCandidacyProcessDA.java

示例14: createHeader

import org.apache.poi.hssf.util.Region; //导入依赖的package包/类
private void createHeader(final StyledExcelSpreadsheet spreadsheet, final Degree degree) {
    // title
    spreadsheet.newHeaderRow();
    spreadsheet.addCell(degree.getName(), spreadsheet.getExcelStyle().getTitleStyle());

    // empty row
    spreadsheet.newHeaderRow();

    // table header
    spreadsheet.newHeaderRow();
    spreadsheet.addHeader(getString("label.candidacy.identification"));
    spreadsheet.addHeader(2, getString("label.candidacy.degree.and.school"));
    spreadsheet.addHeader(getString("label.candidacy.affinity"));
    spreadsheet.addHeader(getString("label.candidacy.degreeNature"));
    spreadsheet.addHeader(getString("label.candidacy.concludedUCs"));
    spreadsheet.addHeader(8, "");
    spreadsheet.addHeader(getString("label.candidacy.approvedEctsRate"));
    spreadsheet.addHeader(getString("label.candidacy.gradeRate"));
    spreadsheet.addHeader(getString("label.candidacy.degreeChange.seriesCandidacyGrade"));
    spreadsheet.addHeader(getString("label.candidacy.result"));

    spreadsheet.newHeaderRow();
    spreadsheet.addHeader(getString("label.number"));
    spreadsheet.addHeader(getString("label.name"));
    spreadsheet.addHeader(5, getString("label.number"));
    spreadsheet.addHeader(getString("label.candidacy.gradeSum.abbr"));
    spreadsheet.addHeader(getString("label.candidacy.approvedEcts"));
    spreadsheet.addHeader(getString("label.candidacy.enroledEcts"));

    // Id + Nº + Nome merge
    spreadsheet.getSheet().addMergedRegion(new Region(2, (short) 0, 2, (short) 1));
    // Degree name merge
    spreadsheet.getSheet().addMergedRegion(new Region(2, (short) 2, 3, (short) 2));
    // affinity merge
    spreadsheet.getSheet().addMergedRegion(new Region(2, (short) 3, 3, (short) 3));
    // degreeNature merge
    spreadsheet.getSheet().addMergedRegion(new Region(2, (short) 4, 3, (short) 4));
    // UCs merge
    spreadsheet.getSheet().addMergedRegion(new Region(2, (short) 5, 2, (short) 7));
    // A merge
    spreadsheet.getSheet().addMergedRegion(new Region(2, (short) 9, 3, (short) 9));
    // B merge
    spreadsheet.getSheet().addMergedRegion(new Region(2, (short) 10, 3, (short) 10));
    // C merge
    spreadsheet.getSheet().addMergedRegion(new Region(2, (short) 11, 3, (short) 11));
    // result merge
    spreadsheet.getSheet().addMergedRegion(new Region(2, (short) 12, 3, (short) 12));
}

开发者ID:FenixEdu，项目名称:fenixedu-academic，代码行数:49，代码来源:DegreeChangeCandidacyProcessDA.java

注：本文中的org.apache.poi.hssf.util.Region类示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

Java HttpServer类代码示例发布时间：2022-05-23

Java Listeners类代码示例发布时间：2022-05-23

剪的笔顺,诠释剪的笔画,认识剪的部首

1 六六分期app的软件客服如何联系？(六六分期

六六分期app的软件客服如何联系？不知道吗？加qq群【895510560】即可！标题：六六分期

阅读：18790|2023-10-27

2 可心卡盟:win10系统火狐flash插件崩溃怎么

今天小编告诉大家如何处理win10系统火狐flash插件总是崩溃的问题，可能很多用户都不知

阅读：9856|2022-11-06

3 亲亲特价:怎么删除回收站图标

今天小编告诉大家如何对win10系统删除桌面回收站图标进行设置，可能很多用户都不知道

阅读：8277|2022-11-06

4 济南大学虚拟社区:鲁大师节能降温的具体办

今天小编告诉大家如何对win10系统电脑设置节能降温的设置方法，想必大家都遇到过需要

阅读：8637|2022-11-06

5 xlueops.exe:无线网络安装向导

我们在使用xp系统的过程中,经常需要对xp系统无线网络安装向导设置进行设置，可能很多

阅读：8561|2022-11-06

6 女斗合众国:win7系统cf与主机连接不稳定怎

今天小编告诉大家如何处理win7系统玩cf老是与主机连接不稳定的问题，可能很多用户都不

阅读：9563|2022-11-06

7 0xc000022-[cf烟雾头]cf怎么调烟雾头

电脑对日常生活的重要性小编就不多说了，可是一旦碰到win7系统设置cf烟雾头的问题，很

阅读：8554|2022-11-06

8 qizideyouhuo:应用程序无法正常启动0xc0000

我们在日常使用电脑的时候，有的小伙伴们可能在打开应用的时候会遇见提示应用程序无法

阅读：7953|2022-11-06

9 ipz-185:win7系统vcf文件怎么打开

今天小编告诉大家如何对win7系统打开vcf文件进行设置，可能很多用户都不知道怎么对win

阅读：8556|2022-11-06

10 傻哥蹦迪:win10系统s4怎么打开usb调试

今天小编告诉大家如何对win10系统s4开启USB调试模式进行设置，可能很多用户都不知道怎

阅读：7476|2022-11-06

客服电话

电子邮件

Java Region类代码示例

示例1: pushSheetToExcelBySQL

示例2: listTurnSheet

示例3: generateLogo

示例4: getMergedCells

示例5: copySheet

示例6: copyRow

示例7: getMergedRegion

示例8: downloadXLSFileBase

示例9: downloadXLSFileBase

示例10: exportMotionExcel

示例11: exportToExcel

示例12: isNewMergedRegion

示例13: createHeader

示例14: createHeader

请发表评论

全部评论

上一篇：

下一篇：

kojino/Harvard-Robust-Machine-Learning:

cescoffier/puppet-nexus: A Puppet Module

文的笔顺,诠释文的笔画,解读文的部首

CVE-2022-1599

Cassolotl/sentient.cloud · GitHub

剪的笔顺,诠释剪的笔画,认识剪的部首

六六分期app的软件客服如何联系？(六六分期

florent37/ViewAnimator: A fluent Android

florent37/Shrine-MaterialDesign2: implem

CVE-2020-36276

SimpleSoftwareIO/simple-sms: Send and re

关于我们

产品与服务

解决方案

139-2527-9053