org.apache.poi.hssf.usermodel.HSSFSheet.getSheetName()方法的使用及代码示例

x33g5p2x  于2022-01-20 转载在 其他  
字(11.5k)|赞(0)|评价(0)|浏览(172)

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

HSSFSheet.getSheetName介绍

[英]Returns the name of this sheet
[中]返回此工作表的名称

代码示例

代码示例来源：origin: com.haulmont.yarg/yarg

/**
 * Returns EscherAggregate from sheet
 *
 * @param sheet - HSSFSheet
 * @return - EscherAggregate from sheet
 */
protected EscherAggregate getEscherAggregate(HSSFSheet sheet) {
  EscherAggregate agg = sheetToEscherAggregate.get(sheet.getSheetName());
  if (agg == null) {
    agg = sheet.getDrawingEscherAggregate();
    sheetToEscherAggregate.put(sheet.getSheetName(), agg);
  }
  return agg;
}

代码示例来源：origin: cuba-platform/yarg

/**
 * Returns EscherAggregate from sheet
 *
 * @param sheet - HSSFSheet
 * @return - EscherAggregate from sheet
 */
protected EscherAggregate getEscherAggregate(HSSFSheet sheet) {
  EscherAggregate agg = sheetToEscherAggregate.get(sheet.getSheetName());
  if (agg == null) {
    agg = sheet.getDrawingEscherAggregate();
    sheetToEscherAggregate.put(sheet.getSheetName(), agg);
  }
  return agg;
}

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

private File writingToExcel() {
  HSSFWorkbook workbook = new HSSFWorkbook();
  HSSFSheet sheet = workbook.createSheet("Sample-sheet");
  Row row = sheet.createRow(0);
  Cell cell = row.createCell(0);
  cell.setCellValue("My Sample Value");

  File file = new File(sheet.getSheetName());
  return file;
}

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

protected void processSheetHeader( Element htmlBody, HSSFSheet sheet ) {
  Element h2 = htmlDocumentFacade.createHeader2();
  h2.appendChild( htmlDocumentFacade.createText( sheet.getSheetName() ) );
  htmlBody.appendChild( h2 );
}

代码示例来源：origin: org.openl.rules/org.openl.lib.poi.dev

protected void processSheetHeader( Element htmlBody, HSSFSheet sheet )
{
  Element h2 = htmlDocumentFacade.createHeader2();
  h2.appendChild( htmlDocumentFacade.createText( sheet.getSheetName() ) );
  htmlBody.appendChild( h2 );
}

代码示例来源：origin: gradle.plugin.net.mbonnin/strings2xls

public static void run(ImportConfig config) throws IOException, ParserConfigurationException, TransformerException {
  if (config == null) {
    System.err.println("Cannot import, missing config");
    return;
  }
  if (StringUtils.isEmpty(config.inputFile)) {
    System.err.println("Cannot import, missing input file name");
    return;
  }
  HSSFWorkbook wb = new HSSFWorkbook(new FileInputStream(new File(config.inputFile)));
  HSSFSheet sheet = wb.getSheetAt(0);
  HSSFSheet sheetMapping = null;
  if (!StringUtils.isEmpty(config.mappingFile)) {
    HSSFWorkbook wbMapping = new HSSFWorkbook(new FileInputStream(new File(config.mappingFile)));
    sheetMapping = wbMapping.getSheetAt(0);
  }
  String outputDirName = config.outputDirName;
  if (StringUtils.isEmpty(outputDirName)) {
    outputDirName = sheet.getSheetName();
  }
  if (config.outputFileName == null) {
    config.outputFileName = "strings.xml";
  }
  ToolImport tool = new ToolImport(null);
  tool.mConfig = config;
  tool.outResDir = new File("out/" + outputDirName + "/res");
  tool.outResDir.mkdirs();
  tool.prepareMapping(sheetMapping);
  tool.parse(sheet);
}

代码示例来源：origin: TomasKypta/android-lang-tool

public static void run(ImportConfig config) throws IOException, ParserConfigurationException, TransformerException {
  if (config == null) {
    System.err.println("Cannot import, missing config");
    return;
  }
  if (StringUtils.isEmpty(config.inputFile)) {
    System.err.println("Cannot import, missing input file name");
    return;
  }
  HSSFWorkbook wb = new HSSFWorkbook(new FileInputStream(new File(config.inputFile)));
  HSSFSheet sheet = wb.getSheetAt(0);
  HSSFSheet sheetMapping = null;
  if (!StringUtils.isEmpty(config.mappingFile)) {
    HSSFWorkbook wbMapping = new HSSFWorkbook(new FileInputStream(new File(config.mappingFile)));
    sheetMapping = wbMapping.getSheetAt(0);
  }
  String outputDirName = config.outputDirName;
  if (StringUtils.isEmpty(outputDirName)) {
    outputDirName = sheet.getSheetName();
  }
  if (config.outputFileName == null) {
    config.outputFileName = "strings.xml";
  }
  ToolImport tool = new ToolImport(null);
  tool.mConfig = config;
  tool.outResDir = new File("out/" + outputDirName + "/res");
  tool.outResDir.mkdirs();
  tool.prepareMapping(sheetMapping);
  tool.parse(sheet);
}

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

if (tmpSheet.getSheetName().startsWith(sheetName)) {

代码示例来源：origin: micromata/projectforge

+ clazz
    + " in sheet='"
    + sheet.getSheetName()
    + "', row="
    + i);
} catch (final InstantiationException ex) {
 throw new IllegalArgumentException(
   "Can't create bean " + ex.toString() + " in sheet='" + sheet.getSheetName() + "', row=" + i);
} catch (final IllegalAccessException ex) {
 throw new IllegalArgumentException(
   "Getter is not visible " + ex.toString() + " in sheet='" + sheet.getSheetName() + "', row=" + i);
} catch (final InvocationTargetException ex) {
 log.error(ex.getMessage(), ex);
   + ex.toString()
   + " in sheet='"
   + sheet.getSheetName()
   + "', row="
   + i);
} catch (final NoSuchMethodException ex) {
 throw new IllegalArgumentException(
   "Getter is not existant " + ex.toString() + " in sheet='" + sheet.getSheetName() + "', row=" + i);

代码示例来源：origin: TomasKypta/android-lang-tool

private void split(HSSFSheet inSheet) throws IOException, TransformerException {
  Row inTitleRow = inSheet.getRow(0);
  for (Map.Entry<Integer, String> entry : mSplittingMap.entrySet()) {
    System.out.println("Splitting into file: " + entry.getValue());
    File outputFile = new File(mIntermediateXlsDir, entry.getValue());
    FileOutputStream fos = null;
    try {
      fos = new FileOutputStream(outputFile);
      HSSFWorkbook wb = new HSSFWorkbook();
      HSSFSheet outSheet = wb.createSheet(inSheet.getSheetName());
      copyTitleRow(inTitleRow, outSheet);
      Integer actFileStart = entry.getKey();
      Integer nextFileStart = mSplittingMap.higherKey(entry.getKey());
      if (nextFileStart == null) {
        nextFileStart = inSheet.getLastRowNum() + 2;
      }
      copyRowRange(inSheet, outSheet, actFileStart, nextFileStart);
      wb.write(fos);
    } finally {
      if (fos != null) {
        fos.close();
      }
    }
  }
}

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

protected void processSheetName( HSSFSheet sheet, Element flow )
{
  Element titleBlock = foDocumentFacade.createBlock();
  Triplet triplet = new Triplet();
  triplet.bold = true;
  triplet.italic = false;
  triplet.fontName = "Arial";
  getFontReplacer().update( triplet );
  setBlockProperties( titleBlock, triplet );
  titleBlock.setAttribute( "font-size", "200%" );
  Element titleInline = foDocumentFacade.createInline();
  titleInline.appendChild( foDocumentFacade.createText( sheet
      .getSheetName() ) );
  titleBlock.appendChild( titleInline );
  flow.appendChild( titleBlock );
  Element titleBlock2 = foDocumentFacade.createBlock();
  Element titleInline2 = foDocumentFacade.createInline();
  titleBlock2.appendChild( titleInline2 );
  flow.appendChild( titleBlock2 );
}

代码示例来源：origin: org.openl.rules/org.openl.lib.poi.dev

protected void processSheetName( HSSFSheet sheet, Element flow )
{
  Element titleBlock = foDocumentFacade.createBlock();
  Triplet triplet = new Triplet();
  triplet.bold = true;
  triplet.italic = false;
  triplet.fontName = "Arial";
  getFontReplacer().update( triplet );
  setBlockProperties( titleBlock, triplet );
  titleBlock.setAttribute( "font-size", "200%" );
  Element titleInline = foDocumentFacade.createInline();
  titleInline.appendChild( foDocumentFacade.createText( sheet
      .getSheetName() ) );
  titleBlock.appendChild( titleInline );
  flow.appendChild( titleBlock );
  Element titleBlock2 = foDocumentFacade.createBlock();
  Element titleInline2 = foDocumentFacade.createInline();
  titleBlock2.appendChild( titleInline2 );
  flow.appendChild( titleBlock2 );
}

代码示例来源：origin: cuba-platform/yarg

@Override
public void inlineToXls(HSSFPatriarch patriarch, HSSFCell resultCell, Object paramValue, Matcher paramsMatcher) {
  try {
    Image image = new Image(paramValue, paramsMatcher);
    if (image.isValid()) {
      HSSFSheet sheet = resultCell.getSheet();
      HSSFWorkbook workbook = sheet.getWorkbook();
      int pictureIdx = workbook.addPicture(image.imageContent, Workbook.PICTURE_TYPE_JPEG);
      CreationHelper helper = workbook.getCreationHelper();
      ClientAnchor anchor = helper.createClientAnchor();
      anchor.setCol1(resultCell.getColumnIndex());
      anchor.setRow1(resultCell.getRowIndex());
      anchor.setCol2(resultCell.getColumnIndex());
      anchor.setRow2(resultCell.getRowIndex());
      if (patriarch == null) {
        throw new IllegalArgumentException(String.format("No HSSFPatriarch object provided. Charts on this sheet could cause this effect. Please check sheet %s", resultCell.getSheet().getSheetName()));
      }
      HSSFPicture picture = patriarch.createPicture(anchor, pictureIdx);
      Dimension size = ImageUtils.getDimensionFromAnchor(picture);
      double actualHeight = size.getHeight() / EMU_PER_PIXEL;
      double actualWidth = size.getWidth() / EMU_PER_PIXEL;
      picture.resize((double) image.width / actualWidth, (double) image.height / actualHeight);
    }
  } catch (IllegalArgumentException e) {
    throw new ReportFormattingException("An error occurred while inserting bitmap to xls file", e);
  }
}

代码示例来源：origin: com.haulmont.yarg/yarg

@Override
public void inlineToXls(HSSFPatriarch patriarch, HSSFCell resultCell, Object paramValue, Matcher paramsMatcher) {
  try {
    Image image = new Image(paramValue, paramsMatcher);
    if (image.isValid()) {
      HSSFSheet sheet = resultCell.getSheet();
      HSSFWorkbook workbook = sheet.getWorkbook();
      int pictureIdx = workbook.addPicture(image.imageContent, Workbook.PICTURE_TYPE_JPEG);
      CreationHelper helper = workbook.getCreationHelper();
      ClientAnchor anchor = helper.createClientAnchor();
      anchor.setCol1(resultCell.getColumnIndex());
      anchor.setRow1(resultCell.getRowIndex());
      anchor.setCol2(resultCell.getColumnIndex());
      anchor.setRow2(resultCell.getRowIndex());
      if (patriarch == null) {
        throw new IllegalArgumentException(String.format("No HSSFPatriarch object provided. Charts on this sheet could cause this effect. Please check sheet %s", resultCell.getSheet().getSheetName()));
      }
      HSSFPicture picture = patriarch.createPicture(anchor, pictureIdx);
      Dimension size = ImageUtils.getDimensionFromAnchor(picture);
      double actualHeight = size.getHeight() / EMU_PER_PIXEL;
      double actualWidth = size.getWidth() / EMU_PER_PIXEL;
      picture.resize((double) image.width / actualWidth, (double) image.height / actualHeight);
    }
  } catch (IllegalArgumentException e) {
    throw new ReportFormattingException("An error occurred while inserting bitmap to xls file", e);
  }
}

代码示例来源：origin: com.haulmont.yarg/yarg

SheetRange sheetRange = new SheetRange(mergedRegion, currentSheet.getSheetName());
if (mergeRegionsForRangeNames.get(name) == null) {
  ArrayList<SheetRange> list = new ArrayList<SheetRange>();

代码示例来源：origin: cuba-platform/yarg

SheetRange sheetRange = new SheetRange(mergedRegion, currentSheet.getSheetName());
if (mergeRegionsForRangeNames.get(name) == null) {
  ArrayList<SheetRange> list = new ArrayList<>();

代码示例来源：origin: cuba-platform/yarg

areaDependencyManager.addDependency(new Area(band.getName(), Area.AreaAlign.VERTICAL, templateRange),
    new Area(band.getName(), Area.AreaAlign.VERTICAL, resultRange));
bandsToResultRanges.put(band, new Range(resultSheet.getSheetName(),
    resultRange.getFirstCell().getCol() + 1, resultRange.getFirstCell().getRow() + 1,
    resultRange.getLastCell().getCol() + 1, resultRange.getLastCell().getRow() + 1

代码示例来源：origin: com.haulmont.yarg/yarg

if (regionsList != null)
  for (SheetRange sheetRange : regionsList) {
    if (resultSheet.getSheetName().equals(sheetRange.getSheetName())) {
      CellRangeAddress cra = sheetRange.getCellRangeAddress();
      if (cra != null) {

代码示例来源：origin: bedatadriven/activityinfo

HSSFWorkbook book = exporter.getBook();
assertThat(book.getSheetAt(0).getSheetName(), equalTo("Construction Rehabilitation of "));
assertThat(book.getSheetAt(1).getSheetName(), equalTo("Construction Rehabilitation"));
assertThat(book.getSheetAt(2).getSheetName(), equalTo("Construction Rehabil 2"));

代码示例来源：origin: cuba-platform/yarg

if (regionsList != null)
  for (SheetRange sheetRange : regionsList) {
    if (resultSheet.getSheetName().equals(sheetRange.getSheetName())) {
      CellRangeAddress cra = sheetRange.getCellRangeAddress();
      if (cra != null) {

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

HSSFSheet

相关文章

    查看更多
    微信公众号

    热门标签

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

    最新文章

    更多

    HSSFSheet类方法

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