org.apache.poi.ss.usermodel.Sheet.createRow()方法的使用及代码示例

x33g5p2x  于2022-01-29 转载在 其他  
字(11.2k)|赞(0)|评价(0)|浏览(301)

本文整理了Java中org.apache.poi.ss.usermodel.Sheet.createRow()方法的一些代码示例，展示了Sheet.createRow()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。Sheet.createRow()方法的具体详情如下：
包路径：org.apache.poi.ss.usermodel.Sheet
类名称：Sheet
方法名：createRow

Sheet.createRow介绍

[英]Create a new row within the sheet and return the high level representation
[中]在图纸中创建新行并返回高级表达

代码示例

代码示例来源：origin: spring-projects/spring-framework

@Override
  protected void buildExcelDocument(Map<String, Object> model, Workbook workbook,
      HttpServletRequest request, HttpServletResponse response) throws Exception {
    Sheet sheet = workbook.createSheet("Test Sheet");
    Row row = sheet.createRow(0);
    Cell cell = row.createCell(0);
    cell.setCellValue("Test Value");
  }
};

代码示例来源：origin: org.apache.poi/poi

Sheet sheet = (sheetName == null) ? workbook.createSheet() : workbook.createSheet(sheetName);
Row currentRow;
Cell currentCell;
  currentRow = sheet.createRow(rowIndex);
      currentCell = currentRow.createCell(cellIndex);
      setCellValue(currentCell, cellValue);

代码示例来源：origin: org.apache.poi/poi

public void copyUpdatedCells(Sheet sheet) {
  RowColKey[] keys = new RowColKey[_sharedCellsByRowCol.size()];
  _sharedCellsByRowCol.keySet().toArray(keys);
  Arrays.sort(keys);
  for (int i = 0; i < keys.length; i++) {
    RowColKey key = keys[i];
    Row row = sheet.getRow(key.getRowIndex());
    if (row == null) {
      row = sheet.createRow(key.getRowIndex());
    }
    Cell destCell = row.getCell(key.getColumnIndex());
    if (destCell == null) {
      destCell = row.createCell(key.getColumnIndex());
    }
    ForkedEvaluationCell srcCell = _sharedCellsByRowCol.get(key);
    srcCell.copyValue(destCell);
  }
}

代码示例来源：origin: stackoverflow.com

public class SO{
public static void main(String[] args) {

  try {
    FileInputStream is = new FileInputStream(new File("D:\\Users\\user2777005\\Desktop\\bob.xlsx"));
    XSSFWorkbook wb = new XSSFWorkbook(is);
    String header = "123456789123456789123456789123456789123456789123456789123456789123456789123456789123456789123456789";
    Sheet sheet = wb.getSheet("Sheet1");
    sheet.setColumnWidth(0, 18000);
    Row row = sheet.createRow(0);
    Cell cell = row.createCell(0);

    if(header.length() > 50){ //Length of String for my test
      sheet.setColumnWidth(0, 18000); //Set column width, you'll probably want to tweak the second int
      CellStyle style = wb.createCellStyle(); //Create new style
      style.setWrapText(true); //Set wordwrap
      cell.setCellStyle(style); //Apply style to cell
      cell.setCellValue(header); //Write header
    }

    wb.write(new FileOutputStream(new File("D:\\Users\\user2777005\\Desktop\\bob.xlsx")));
  } catch (IOException e) {
    e.printStackTrace();
  }
}
}

代码示例来源：origin: stackoverflow.com

Workbook wb = new HSSFWorkbook();
Sheet s1 = wb.createSheet();
for (int i=0; i<test.size(); i++) {
  String firstname = 
  Row r = s1.createRow(i);

  Map<String,String> personData = test.get(i);

  Cell fn = r.createCreateCell(0, Cell.CELL_TYPE_STRING);
  fn.setCellValue(data.get("personfirstname"));

  Cell ln = r.createCreateCell(1, Cell.CELL_TYPE_STRING);
  ln.setCellValue(data.get("personlastname"));
}

代码示例来源：origin: stackoverflow.com

Workbook workbook = new XSSFWorkbook();  // OR new HSSFWorkbook()
Sheet sheet = workbook.createSheet("Sheet1");
Map<String, Object> properties = new HashMap<String, Object>();

// create your spreadsheet without borders
...

// create property set for vertical borders
properties.put(CellUtil.BORDER_LEFT, CellStyle.BORDER_MEDIUM);
properties.put(CellUtil.BORDER_RIGHT, CellStyle.BORDER_MEDIUM);

// Apply the borders to a 3x3 region starting at D4
for (int ix=3; ix <= 5; ix++) {
 row = sheet.createRow(ix);
 for (int iy = 3; iy <= 5; iy++) {
  cell = row.createCell(iy);
  CellUtil.setCellStyleProperties(cell, properties);
 }
}

代码示例来源：origin: stackoverflow.com

Workbook wb = WorkbookFactory.create(new File("MyExcel.xls"));
Sheet s = wb.getSheetAt(0);

// Get the 11th row, creating if not there
Row r1 = s.getRow(10);
if (r1 == null) r1 = s.createRow(10);

// Get the 3rd column, creating if not there
Cell c2 = r1.getCell(2, Row.CREATE_NULL_AS_BLANK);
// Set a string to be the value
c2.setCellValue("Hello, I'm the cell C10!");

// Save
FileOutputStream out = new FileOutputStream("New.xls");
wb.write(out);
out.close();

代码示例来源：origin: spring-projects/spring-framework

@Override
  protected void buildExcelDocument(Map<String, Object> model, Workbook workbook,
      HttpServletRequest request, HttpServletResponse response) throws Exception {
    Sheet sheet = workbook.createSheet("Test Sheet");
    Row row = sheet.createRow(0);
    Cell cell = row.createCell(0);
    cell.setCellValue("Test Value");
  }
};

代码示例来源：origin: stackoverflow.com

XSSFWorkbook wb = new XSSFWorkbook();
CellStyle borderStyle = wb.createCellStyle();
borderStyle.setBorderBottom(CellStyle.BORDER_THIN);
borderStyle.setBorderLeft(CellStyle.BORDER_THIN);
borderStyle.setBorderRight(CellStyle.BORDER_THIN);
borderStyle.setBorderTop(CellStyle.BORDER_THIN);
borderStyle.setAlignment(CellStyle.ALIGN_CENTER);
Sheet sheet = wb.createSheet("Test Sheet");
Row row = sheet.createRow(1);
for (int i = 1; i <= 5; ++i) {
  Cell cell = row.createCell(i);
  cell.setCellStyle(borderStyle);
  if (i == 1) {
    cell.setCellValue("Centred Text");
  } 
}
sheet.addMergedRegion(new CellRangeAddress(1, 1, 1, 5));

代码示例来源：origin: stackoverflow.com

import java.io.*;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.*;
import au.com.bytecode.opencsv.CSVReader;

class Test {
  public static void main(String[] args) throws IOException {
    Workbook wb = new HSSFWorkbook();
    CreationHelper helper = wb.getCreationHelper();
    Sheet sheet = wb.createSheet("new sheet");

    CSVReader reader = new CSVReader(new FileReader("data.csv"));
    String[] line;
    int r = 0;
    while ((line = reader.readNext()) != null) {
      Row row = sheet.createRow((short) r++);

      for (int i = 0; i < line.length; i++)
        row.createCell(i)
          .setCellValue(helper.createRichTextString(line[i]));
    }

    // Write the output to a file
    FileOutputStream fileOut = new FileOutputStream("workbook.xls");
    wb.write(fileOut);
    fileOut.close();
  }
}

代码示例来源：origin: org.apache.poi/poi

private void copyRange(CellRangeAddress sourceRange, int deltaX, int deltaY, Sheet sourceClone) { //NOSONAR, it's a bit complex but monolith method, does not make much sense to divide it
  if(deltaX != 0)
    horizontalFormulaShifter = FormulaShifter.createForColumnCopy(sourceSheet.getWorkbook().getSheetIndex(sourceSheet), 
        sourceSheet.getSheetName(), sourceRange.getFirstColumn(), sourceRange.getLastColumn(), deltaX, sourceSheet.getWorkbook().getSpreadsheetVersion());
  if(deltaY != 0)
    verticalFormulaShifter = FormulaShifter.createForRowCopy(sourceSheet.getWorkbook().getSheetIndex(sourceSheet), 
        sourceSheet.getSheetName(), sourceRange.getFirstRow(), sourceRange.getLastRow(), deltaY, sourceSheet.getWorkbook().getSpreadsheetVersion());
  
  for(int rowNo = sourceRange.getFirstRow(); rowNo <= sourceRange.getLastRow(); rowNo++) {   
    Row sourceRow = sourceClone.getRow(rowNo); // copy from source copy, original source might be overridden in process!
    for (int columnIndex = sourceRange.getFirstColumn(); columnIndex <= sourceRange.getLastColumn(); columnIndex++) {  
      Cell sourceCell = sourceRow.getCell(columnIndex);
      if(sourceCell == null)
        continue;
      Row destRow = destSheet.getRow(rowNo + deltaY);
      if(destRow == null)
        destRow = destSheet.createRow(rowNo + deltaY);
      
      Cell newCell = destRow.getCell(columnIndex + deltaX);
      if(newCell != null)
        newCell.setCellType(sourceCell.getCellType());
      else newCell = destRow.createCell(columnIndex + deltaX, sourceCell.getCellType());
      cloneCellContent(sourceCell, newCell, null);
      if(newCell.getCellType() == CellType.FORMULA)
        adjustCellReferencesInsideFormula(newCell, destSheet, deltaX, deltaY);
    }
  }
}

代码示例来源：origin: stackoverflow.com

Workbook wb = new XSSFWorkbook();
CreationHelper createHelper = wb.getCreationHelper();
Sheet sheet = wb.createSheet("AHyperLink");
Cell cell = sheet.createRow(0).createCell(0);
cell.setCellValue("Google");
Hyperlink link = createHelper.createHyperlink(Hyperlink.LINK_URL);
link.setAddress("http://www.google.com/");
cell.setHyperlink(link);

代码示例来源：origin: stackoverflow.com

public static void exportToXls()
{
 Workbook wb = new HSSFWorkbook();
 ...
 Sheet sheetA = wb.createSheet("sheetA"); 
 Sheet sheetB = wb.createSheet("sheetB");
 Sheet sheetC = wb.createSheet("sheetC");
 ...
 // export the appropriate list to the appropriate sheet
 for (YourObject item : listOrderedByA)
 { 
  rowNo++;
  row = sheetA.createRow((short)rowNo); 
  ...
  // define the columns
 }
 // and similarly for the other lists (ordered by B or C)

代码示例来源：origin: spring-projects/spring-framework

@Override
  protected void buildExcelDocument(Map<String, Object> model, Workbook workbook,
      HttpServletRequest request, HttpServletResponse response) throws Exception {
    Sheet sheet = workbook.createSheet("Test Sheet");
    Row row = sheet.createRow(0);
    Cell cell = row.createCell(0);
    cell.setCellValue("Test Value");
  }
};

代码示例来源：origin: youseries/ureport

org.apache.poi.ss.usermodel.Row row = sheet.getRow(rowNumber);
if(row==null){
  row=sheet.createRow(rowNumber);
    continue;
  cell=row.createCell(i);
  com.bstek.ureport.model.Cell cellInfo=colCell.get(col);
  if(cellInfo==null){
    org.apache.poi.ss.usermodel.Row rr=sheet.getRow(j);
    if(rr==null){
      rr=sheet.createRow(j);
        cc=rr.createCell(c);
row=sheet.createRow(rowNumber);
  continue;
cell=row.createCell(i);
com.bstek.ureport.model.Cell cellInfo=colCell.get(col);
if(cellInfo==null){
  org.apache.poi.ss.usermodel.Row rr=sheet.getRow(j);
  if(rr==null){
    rr=sheet.createRow(j);

代码示例来源：origin: pentaho/pentaho-kettle

stepData.sheet = stepData.wb.createSheet();
stepData.file = null;
stepData.clearStyleCache( numOfFields );
Row xlsRow = stepData.sheet.createRow( 0 );
Cell cell = xlsRow.createCell( 5 );
CellStyle cellStyle = stepData.wb.createCellStyle();
cellStyle.setBorderRight( BorderStyle.THICK );
cell = xlsRow.createCell( 6 );
cellStyle.setDataFormat( format.getFormat( "##0,000.0" ) );
cell.setCellStyle( cellStyle );

代码示例来源：origin: hyberbin/J-Excel

/**
 * 初始化一行
 * @param sheet
 * @param row
 * @param length
 * @return
 */
public static Row createRow(Sheet sheet,int row,int length){
  Row sheetRow = sheet.createRow(row);
  for(int i=0;i<length;i++){
    sheetRow.createCell(i);
  }
  return sheetRow;
}

代码示例来源：origin: stackoverflow.com

public static void differentColorInSingleCell(){
  Workbook wb = new HSSFWorkbook();
  Sheet sheet = wb.createSheet("Sheet1");
  Cell cell = sheet.createRow(0).createCell(0);
  Font Font1 = wb.createFont();
  Font1.setColor(HSSFColor.RED.index);
  Font Font2 = wb.createFont();
  Font2.setColor(HSSFColor.BLUE.index);
  CellStyle style = wb.createCellStyle();
  style.setFont(Font1);
  cell.setCellStyle(style);
  RichTextString richString = new HSSFRichTextString("RED, BLUE");
  richString.applyFont(4, 9, Font2);
  cell.setCellValue(richString);
  //Write the file Now
}

代码示例来源：origin: stackoverflow.com

// setup code
String sname = "TestSheet", cname = "TestName", cvalue = "TestVal";
Workbook wb = new HSSFWorkbook();
Sheet sheet = wb.createSheet(sname);
sheet.createRow(0).createCell((short) 0).setCellValue(cvalue);

// 1. create named range for a single cell using areareference
Name namedCell = wb.createName();
namedCell.setNameName(cname);
String reference = sname+"!A1:A1"; // area reference
namedCell.setRefersToFormula(reference);

代码示例来源：origin: stackoverflow.com

Workbook wb = new HSSFWorkbook();
 //Workbook wb = new XSSFWorkbook();
 CreationHelper createHelper = wb.getCreationHelper();
 Sheet sheet = wb.createSheet("new sheet");
 // Create a row and put some cells in it. Rows are 0 based.
 Row row = sheet.createRow((short)0);
 // Create a cell and put a value in it.
 Cell cell = row.createCell(0);
 cell.setCellValue(1);
 // Or do it on one line.
 row.createCell(1).setCellValue(1.2);
 row.createCell(2).setCellValue(
    createHelper.createRichTextString("This is a string"));
 row.createCell(3).setCellValue(true);
 // Write the output to a file
 FileOutputStream fileOut = new FileOutputStream("workbook.xls");
 wb.write(fileOut);
 fileOut.close();

内容来源于网络，如有侵权，请联系作者删除！

sheet

相关文章

    查看更多
    微信公众号

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多

    Sheet类方法

    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com