当前位置: 首页>>代码示例>>Java>>正文


Java HSSFSheet.createRow方法代码示例

本文整理汇总了Java中org.apache.poi.hssf.usermodel.HSSFSheet.createRow方法的典型用法代码示例。如果您正苦于以下问题:Java HSSFSheet.createRow方法的具体用法?Java HSSFSheet.createRow怎么用?Java HSSFSheet.createRow使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在org.apache.poi.hssf.usermodel.HSSFSheet的用法示例。


在下文中一共展示了HSSFSheet.createRow方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。

示例1: makeHeader

import org.apache.poi.hssf.usermodel.HSSFSheet; //导入方法依赖的package包/类
private void makeHeader ( final List<Field> columns, final HSSFSheet sheet )
{
    final Font font = sheet.getWorkbook ().createFont ();
    font.setFontName ( "Arial" );
    font.setBoldweight ( Font.BOLDWEIGHT_BOLD );
    font.setColor ( HSSFColor.WHITE.index );

    final CellStyle style = sheet.getWorkbook ().createCellStyle ();
    style.setFont ( font );
    style.setFillForegroundColor ( HSSFColor.BLACK.index );
    style.setFillPattern ( PatternFormatting.SOLID_FOREGROUND );

    final HSSFRow row = sheet.createRow ( 0 );

    for ( int i = 0; i < columns.size (); i++ )
    {
        final Field field = columns.get ( i );

        final HSSFCell cell = row.createCell ( i );
        cell.setCellValue ( field.getHeader () );
        cell.setCellStyle ( style );
    }
}
 
开发者ID:eclipse,项目名称:neoscada,代码行数:24,代码来源:ExportEventsImpl.java

示例2: insertItemToSheet

import org.apache.poi.hssf.usermodel.HSSFSheet; //导入方法依赖的package包/类
private void insertItemToSheet(String table, HSSFSheet sheet, ArrayList<String> columns) {
    HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
    Cursor cursor = database.rawQuery("select * from " + table, null);
    cursor.moveToFirst();
    int n = 1;
    while (!cursor.isAfterLast()) {
        HSSFRow rowA = sheet.createRow(n);
        for (int j = 0; j < columns.size(); j++) {
            HSSFCell cellA = rowA.createCell(j);
            if (cursor.getType(j) == Cursor.FIELD_TYPE_BLOB) {
                HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 0, 0, (short) j, n, (short) (j + 1), n + 1);
                anchor.setAnchorType(3);
                patriarch.createPicture(anchor, workbook.addPicture(cursor.getBlob(j), HSSFWorkbook.PICTURE_TYPE_JPEG));
            } else {
                cellA.setCellValue(new HSSFRichTextString(cursor.getString(j)));
            }
        }
        n++;
        cursor.moveToNext();
    }
    cursor.close();
}
 
开发者ID:androidmads,项目名称:SQLite2XL,代码行数:23,代码来源:SQLiteToExcel.java

示例3: writeXLSFile

import org.apache.poi.hssf.usermodel.HSSFSheet; //导入方法依赖的package包/类
public static void writeXLSFile() throws IOException {

			HSSFWorkbook wbObj = new HSSFWorkbook();
			HSSFSheet sheet = wbObj.createSheet(sheetName);

			for (int row = 0; row < tableData.size(); row++) {
				HSSFRow rowObj = sheet.createRow(row);
				rowData = tableData.get(row);
				for (int col = 0; col < rowData.size(); col++) {
					HSSFCell cellObj = rowObj.createCell(col);
					cellObj.setCellValue(rowData.get(col));
				}
			}

			FileOutputStream fileOut = new FileOutputStream(excelFileName);
			wbObj.write(fileOut);
			wbObj.close();
			fileOut.flush();
			fileOut.close();
		}
 
开发者ID:sergueik,项目名称:SWET,代码行数:21,代码来源:TableEditorEx.java

示例4: createHeader

import org.apache.poi.hssf.usermodel.HSSFSheet; //导入方法依赖的package包/类
private void createHeader(HSSFSheet sheet, List<ExpedientConsultaDissenyDto> expedientsConsultaDissenyDto) {
	int rowNum = 0;
	int colNum = 0;

	// Capçalera
	HSSFRow xlsRow = sheet.createRow(rowNum++);

	HSSFCell cell;
	
	cell = xlsRow.createCell(colNum++);
	cell.setCellValue(new HSSFRichTextString(StringUtils.capitalize("Expedient")));
	cell.setCellStyle(headerStyle);
	
	Iterator<Entry<String, DadaIndexadaDto>> it = expedientsConsultaDissenyDto.get(0).getDadesExpedient().entrySet().iterator();
	while (it.hasNext()) {
		Map.Entry<String, DadaIndexadaDto> e = (Map.Entry<String, DadaIndexadaDto>)it.next();
		sheet.autoSizeColumn(colNum);
		cell = xlsRow.createCell(colNum++);
		cell.setCellValue(new HSSFRichTextString(StringUtils.capitalize(e.getValue().getEtiqueta())));
		cell.setCellStyle(headerStyle);
	}
}
 
开发者ID:GovernIB,项目名称:helium,代码行数:23,代码来源:ExpedientInformeController.java

示例5: copySheets

import org.apache.poi.hssf.usermodel.HSSFSheet; //导入方法依赖的package包/类
/**
 * @param newSheet the sheet to create from the copy.
 * @param sheet the sheet to copy.
 * @param copyStyle true copy the style.
 */
public static void copySheets(HSSFSheet newSheet, HSSFSheet sheet, boolean copyStyle) {
    int maxColumnNum = 0;
    Map<Integer, HSSFCellStyle> styleMap = (copyStyle) ? new HashMap<Integer, HSSFCellStyle>() : null;
    for (int i = sheet.getFirstRowNum(); i <= sheet.getLastRowNum(); i++) {
        HSSFRow srcRow = sheet.getRow(i);
        HSSFRow destRow = newSheet.createRow(i);
        if (srcRow != null) {
            Util.copyRow(sheet, newSheet, srcRow, destRow, styleMap);
            if (srcRow.getLastCellNum() > maxColumnNum) {
                maxColumnNum = srcRow.getLastCellNum();
            }
        }
    }
    for (int i = 0; i <= maxColumnNum; i++) {
        newSheet.setColumnWidth(i, sheet.getColumnWidth(i));
    }
   //Util.copyPictures(newSheet,sheet) ;
}
 
开发者ID:likelet,项目名称:DAtools,代码行数:24,代码来源:Util.java

示例6: createWorkbook

import org.apache.poi.hssf.usermodel.HSSFSheet; //导入方法依赖的package包/类
private HSSFWorkbook createWorkbook() {
    HSSFWorkbook workbook = new HSSFWorkbook();
    HSSFSheet sheet = workbook.createSheet();

    // Add dummy lines
    sheet.createRow(0).createCell(0).setCellValue("First dummy row");
    sheet.createRow(1).createCell(0).setCellValue("Second dummy row");

    HSSFRow row = sheet.createRow(2);
    row.createCell(13).setCellValue("BoundaryPoint FR-BE");
    row.createCell(14).setCellValue("France");
    row.createCell(15).setCellValue("Belgium");

    return workbook;
}
 
开发者ID:powsybl,项目名称:powsybl-core,代码行数:16,代码来源:BoundaryPointXlsParserTest.java

示例7: getXLS

import org.apache.poi.hssf.usermodel.HSSFSheet; //导入方法依赖的package包/类
/**
 * Creates XLS document from given list of {@link PollOption} objects.
 * 
 * @param results List of {@link PollOption} objects.
 * @return XLS document.
 */
public static HSSFWorkbook getXLS(List<PollOption> results) {
    HSSFWorkbook document = new HSSFWorkbook();
    HSSFSheet sheet = document.createSheet("Results");
    HSSFRow rowhead = sheet.createRow(0);
    rowhead.createCell(0).setCellValue("Ime opcije:");
    rowhead.createCell(1).setCellValue("Broj glasova:");

    for (int i = 0; i < results.size(); i++) {
        HSSFRow row = sheet.createRow(i + 1);
        row.createCell(0).setCellValue(results.get(i).getName());
        row.createCell(1).setCellValue(
                Double.valueOf(results.get(i).getVotes()));
    }
    return document;
}
 
开发者ID:fgulan,项目名称:java-course,代码行数:22,代码来源:DBUtility.java

示例8: getXLS

import org.apache.poi.hssf.usermodel.HSSFSheet; //导入方法依赖的package包/类
/**
 * Creates XLS document based on given input parameters.
 * 
 * @param a Start number.
 * @param b End number.
 * @param n Last power.
 * @return Created XLS document.
 */
private HSSFWorkbook getXLS(Integer a, Integer b, Integer n) {
    HSSFWorkbook workbook = new HSSFWorkbook();

    for (int i = 1; i <= n; i++) {
        HSSFSheet sheet = workbook.createSheet(i + "-th power.");
        HSSFRow rowHead = sheet.createRow(0);
        rowHead.createCell(0).setCellValue("x");
        rowHead.createCell(1).setCellValue("x^" + i);

        int rowCounter = 1;
        for (int j = a; j <= b; j++) {
            HSSFRow row = sheet.createRow(rowCounter++);
            row.createCell(0).setCellValue(Double.valueOf(j));
            row.createCell(1).setCellValue(Math.pow(Double.valueOf(j), i));
        }
    }
    return workbook;
}
 
开发者ID:fgulan,项目名称:java-course,代码行数:27,代码来源:PowersServlet.java

示例9: getXLS

import org.apache.poi.hssf.usermodel.HSSFSheet; //导入方法依赖的package包/类
/**
 * Creates XLS document based from given list of bands.
 * 
 * @param results List of bands.
 * @return XLS document.
 */
public static HSSFWorkbook getXLS(List<Band> results) {
    HSSFWorkbook workbook = new HSSFWorkbook();
    HSSFSheet sheet = workbook.createSheet("Voting results");
    HSSFRow rowHead = sheet.createRow(0);
    rowHead.createCell(0).setCellValue("Band name:");
    rowHead.createCell(1).setCellValue("Number of votes:");

    for (int i = 0, size = results.size(); i < size; i++) {
        HSSFRow row = sheet.createRow(i + 1);
        row.createCell(0).setCellValue(results.get(i).getName());
        row.createCell(1).setCellValue(
                Double.valueOf(results.get(i).getVotes()));
    }
    return workbook;
}
 
开发者ID:fgulan,项目名称:java-course,代码行数:22,代码来源:ServerUtilty.java

示例10: writeBody

import org.apache.poi.hssf.usermodel.HSSFSheet; //导入方法依赖的package包/类
void writeBody(HSSFSheet sheet){
		Set<String> keySet = getColumnJson().keySet();
		List<T> ts = getData();
		for (T t:ts) {
//			Class cls = t.getClass();
			int cellNumber = 0;//将cellNumber从0开始
			HSSFRow row = sheet.createRow(addRowNumber());//创建新的一行
			for(String key:keySet){
				try {
					HSSFCell cell = row.createCell(cellNumber++);
					Object value = getValueByKey(t, key);
					setCellValue(cell, value);
					pubMaxValue(key, value);
				} catch (Exception e) {
					throw new RuntimeException("writeBody", e);
				}
			}
		}
	}
 
开发者ID:leiyong0326,项目名称:phone,代码行数:20,代码来源:ExcelExportSuper.java

示例11: createHeader

import org.apache.poi.hssf.usermodel.HSSFSheet; //导入方法依赖的package包/类
public static boolean createHeader(HSSFWorkbook workbook, HSSFSheet sheet,String[] header) throws Exception{
	boolean flag = false;
	try {
		HSSFCellStyle cellStyle = workbook.createCellStyle();
		cellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
	 	cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);

		HSSFRow head_row = sheet.createRow(0); // 创建行
		// 操作head
		for (short h = 0; h < header.length; h++) {
			createcsv(head_row, h, header[h], cellStyle);
		}
		flag = true;
	} catch (Exception e) {
		logger.error(sheet.getSheetName() + " : 抬头标题创建失败");
		throw e;
	}
	return flag;
}
 
开发者ID:wufeisoft,项目名称:ryf_mms2,代码行数:20,代码来源:CreateExcelUtil.java

示例12: createContent

import org.apache.poi.hssf.usermodel.HSSFSheet; //导入方法依赖的package包/类
public void createContent(WebInput wi, DocInfo di)throws ControllerException {
	HSSFWorkbook wb = di.getExcelDocument();
	// 创建HSSFSheet对象
	HSSFSheet sheet = wb.createSheet("sheet0");
	// 创建HSSFRow对象
	HSSFRow row = sheet.createRow((short) 0);
	// 创建HSSFCell对象
	HSSFCell cell = row.createCell((short) 0);
	// 用来处理中文问题
	// cell.setEncoding(HSSFCell.ENCODING_UTF_16);
	// 设置单元格的值
	// cell.setCellValue("Hello World! 你好,中文世界");
	String info = wi.getParameter("info");
	HSSFRichTextString rts = new HSSFRichTextString(info);
	cell.setCellValue(rts);
	HSSFCell cell2 = row.createCell((short) 1);
	cell2.setCellValue(new HSSFRichTextString(
			"Beetle Web Framework 页面生成Excel文件演示!"));
}
 
开发者ID:jbeetle,项目名称:BJAF3.x,代码行数:20,代码来源:GenExcelController.java

示例13: buildExcelDocument

import org.apache.poi.hssf.usermodel.HSSFSheet; //导入方法依赖的package包/类
@Override
protected void buildExcelDocument(Map<String, Object> model,
		HSSFWorkbook workbook, HttpServletRequest request, HttpServletResponse response)
		throws Exception {
	// get data model which is passed by the Spring container
	List<RatingCountBean> listOfRating = (List<RatingCountBean>) model.get("listOfRatingCount");
	
	// create a new Excel sheet
	HSSFSheet sheet = workbook.createSheet("Feedback Report");
	sheet.setDefaultColumnWidth(30);
	
	// create style for header cells
	CellStyle style = workbook.createCellStyle();
	Font font = workbook.createFont();
	font.setFontName("Arial");
	style.setFillForegroundColor(HSSFColor.BLUE.index);
	style.setFillPattern(CellStyle.SOLID_FOREGROUND);
	font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
	font.setColor(HSSFColor.WHITE.index);
	style.setFont(font);
	
	// create header row
	HSSFRow header = sheet.createRow(0);
	
               
               header.createCell(0).setCellValue("Question Number");
	header.getCell(0).setCellStyle(style);
               
	header.createCell(1).setCellValue("Question");
	header.getCell(1).setCellStyle(style);
	
	header.createCell(2).setCellValue("Very Poor");
	header.getCell(2).setCellStyle(style);
	
	header.createCell(3).setCellValue("Poor");
	header.getCell(3).setCellStyle(style);
	
	header.createCell(4).setCellValue("Good");
	header.getCell(4).setCellStyle(style);
	
	header.createCell(5).setCellValue("Best");
	header.getCell(5).setCellStyle(style);
               
               header.createCell(6).setCellValue("Excellent");
	header.getCell(6).setCellStyle(style);
	
	// create data rows
	int rowCount = 1;
	
	for (RatingCountBean rating : listOfRating) {
		HSSFRow aRow = sheet.createRow(rowCount++);
		aRow.createCell(0).setCellValue(rating.getQuestionId());
		aRow.createCell(1).setCellValue(rating.getQuestionText());
		aRow.createCell(2).setCellValue(rating.getRating_one_total_count());
		aRow.createCell(3).setCellValue(rating.getRating_two_total_count());
		aRow.createCell(4).setCellValue(rating.getRating_three_total_count());
                       aRow.createCell(5).setCellValue(rating.getRating_four_total_count());
                       aRow.createCell(6).setCellValue(rating.getRating_five_total_count());
	}
}
 
开发者ID:mustafamym,项目名称:FeedbackCollectionAndMgmtSystem,代码行数:61,代码来源:ExcelBuilder.java

示例14: setData

import org.apache.poi.hssf.usermodel.HSSFSheet; //导入方法依赖的package包/类
/**
 * 设置单元格数据
 *
 * @param sheet
 * @param rowIndex
 * @param data
 */
private static void setData(HSSFSheet sheet, int rowIndex, String... data) {
    setRegionBorder(sheet, rowIndex, 3, 8);
    HSSFRow row = sheet.getRow(rowIndex) == null ? sheet.createRow(rowIndex) : sheet.getRow(rowIndex);
    getCell(row, 0, -1, data.length > 0 ? data[0] : "");
    getCell(row, 1, -1, data.length > 1 ? data[1] : "");
    getCell(row, 2, -1, data.length > 2 ? data[2] : "");
    getCell(row, 3, -1, data.length > 3 ? data[3] : "");
    getCell(row, 9, -1, data.length > 4 ? data[4] : "");
}
 
开发者ID:ajtdnyy,项目名称:PackagePlugin,代码行数:17,代码来源:FileUtil.java

示例15: test_001

import org.apache.poi.hssf.usermodel.HSSFSheet; //导入方法依赖的package包/类
@Test
public void test_001()
{
    HSSFWorkbook v_Workbook = new HSSFWorkbook();
    HSSFSheet    v_Sheet    = v_Workbook.createSheet("测试单元格颜色");
    
    v_Sheet.setColumnWidth(0 ,2560);
    
    for (int v_RowIndex=0; v_RowIndex<4000; v_RowIndex++)
    {
        HSSFRow v_Row = v_Sheet.createRow(v_RowIndex);
        
        for (int v_ColIndex=0; v_ColIndex<1; v_ColIndex++)
        {
            HSSFCell      v_Cell = v_Row.createCell(v_ColIndex);
            HSSFCellStyle v_CellStyle = v_Workbook.createCellStyle();
            
            v_CellStyle.setFillForegroundColor((short)(v_RowIndex + 1));
            v_CellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
            
            v_Cell.setCellStyle(v_CellStyle);
            v_Cell.setCellValue("" + (v_RowIndex + 1));
        }
    }
    
    ExcelHelp.save(v_Workbook ,"/Users/hy/Downloads/测试2003版本的单元格颜色");
}
 
开发者ID:HY-ZhengWei,项目名称:hy.common.report,代码行数:28,代码来源:JU_Excel2003Color.java


注:本文中的org.apache.poi.hssf.usermodel.HSSFSheet.createRow方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。