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

x33g5p2x  于2022-01-18 转载在 其他  
字(11.6k)|赞(0)|评价(0)|浏览(256)

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

CellStyle.setRotation介绍

[英]set the degree of rotation for the text in the cell
[中]设置单元格中文本的旋转度

代码示例

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

/**
 * Sets the format properties of the given style based on the given map.
 *
 * @param style cell style
 * @param workbook parent workbook
 * @param properties map of format properties (String -> Object)
 * @see #getFormatProperties(CellStyle)
 */
private static void setFormatProperties(CellStyle style, Workbook workbook, Map<String, Object> properties) {
  style.setAlignment(getHorizontalAlignment(properties, ALIGNMENT));
  style.setVerticalAlignment(getVerticalAlignment(properties, VERTICAL_ALIGNMENT));
  style.setBorderBottom(getBorderStyle(properties, BORDER_BOTTOM));
  style.setBorderLeft(getBorderStyle(properties, BORDER_LEFT));
  style.setBorderRight(getBorderStyle(properties, BORDER_RIGHT));
  style.setBorderTop(getBorderStyle(properties, BORDER_TOP));
  style.setBottomBorderColor(getShort(properties, BOTTOM_BORDER_COLOR));
  style.setDataFormat(getShort(properties, DATA_FORMAT));
  style.setFillPattern(getFillPattern(properties, FILL_PATTERN));
  style.setFillForegroundColor(getShort(properties, FILL_FOREGROUND_COLOR));
  style.setFillBackgroundColor(getShort(properties, FILL_BACKGROUND_COLOR));
  style.setFont(workbook.getFontAt(getInt(properties, FONT)));
  style.setHidden(getBoolean(properties, HIDDEN));
  style.setIndention(getShort(properties, INDENTION));
  style.setLeftBorderColor(getShort(properties, LEFT_BORDER_COLOR));
  style.setLocked(getBoolean(properties, LOCKED));
  style.setRightBorderColor(getShort(properties, RIGHT_BORDER_COLOR));
  style.setRotation(getShort(properties, ROTATION));
  style.setTopBorderColor(getShort(properties, TOP_BORDER_COLOR));
  style.setWrapText(getBoolean(properties, WRAP_TEXT));
}

代码示例来源：origin: Vatavuk/excel-io

@Override
  public void accept(final CellStyle style) {
    style.setRotation(this.value);
  }
}

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

CellStyle styleVertical = wb.createCellStyle();
styleVertical.setRotation(0xff);

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

CellStyle cssVertical = wb.createCellStyle();
cssVertical.setFont(f);
cssVertical.setRotation((short)90);

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

public void withRotation( final StyleSheet element ) {
 if ( element == null ) {
  return;
 }
 Object raw =  element.getStyleProperty( TextStyleKeys.TEXT_ROTATION, null );
 if ( raw == null ) {
  return;
 }
 TextRotation rotation = TextRotation.class.cast( raw );
 if ( isXLSX ) {
  //xlsx has different rotation degree boundaries
  final short numericValue = rotation.getNumericValue();
  hssfCellStyle.setRotation( numericValue < 0 ? (short) ( 90 - numericValue ) : numericValue );
 } else {
  hssfCellStyle.setRotation( rotation.getNumericValue() );
 }
}

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

@Test
public void testRotationXLSX() {
 when( workbook.createCellStyle() ).thenReturn( xlsStyle );
 ExcelCellStyleBuilder builder = new ExcelCellStyleBuilder( workbook );
 StyleSheet element = mock( StyleSheet.class );
 when( element.getStyleProperty( eq( TextStyleKeys.TEXT_ROTATION ), any() ) ).thenReturn( TextRotation.D_90 );
 builder.withRotation( element );
 builder.build();
 verify( xlsStyle, times( 1 ) ).setRotation( eq( (short) 90 ) );
 when( element.getStyleProperty( eq( TextStyleKeys.TEXT_ROTATION ), any() ) ).thenReturn( TextRotation.D_270 );
 builder.withRotation( element );
 builder.build();
 verify( xlsStyle, times( 1 ) ).setRotation( eq( (short) -90 ) );
}

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

@Test
public void testNullRotation() {
 when( workbook.createCellStyle() ).thenReturn( xlsStyle );
 ExcelCellStyleBuilder builder = new ExcelCellStyleBuilder( workbook );
 builder.withRotation( null );
 builder.build();
 verify( xlsStyle, times( 0 ) ).setRotation( anyShort() );
}

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

/**
 * Sets the format properties of the given style based on the given map.
 *
 * @param style cell style
 * @param workbook parent workbook
 * @param properties map of format properties (String -> Object)
 * @see #getFormatProperties(CellStyle)
 */
private static void setFormatProperties(CellStyle style, Workbook workbook, Map<String, Object> properties) {
  style.setAlignment(getHorizontalAlignment(properties, ALIGNMENT));
  style.setVerticalAlignment(getVerticalAlignment(properties, VERTICAL_ALIGNMENT));
  style.setBorderBottom(getBorderStyle(properties, BORDER_BOTTOM));
  style.setBorderLeft(getBorderStyle(properties, BORDER_LEFT));
  style.setBorderRight(getBorderStyle(properties, BORDER_RIGHT));
  style.setBorderTop(getBorderStyle(properties, BORDER_TOP));
  style.setBottomBorderColor(getShort(properties, BOTTOM_BORDER_COLOR));
  style.setDataFormat(getShort(properties, DATA_FORMAT));
  style.setFillPattern(getFillPattern(properties, FILL_PATTERN));
  style.setFillForegroundColor(getShort(properties, FILL_FOREGROUND_COLOR));
  style.setFillBackgroundColor(getShort(properties, FILL_BACKGROUND_COLOR));
  style.setFont(workbook.getFontAt(getInt(properties, FONT)));
  style.setHidden(getBoolean(properties, HIDDEN));
  style.setIndention(getShort(properties, INDENTION));
  style.setLeftBorderColor(getShort(properties, LEFT_BORDER_COLOR));
  style.setLocked(getBoolean(properties, LOCKED));
  style.setRightBorderColor(getShort(properties, RIGHT_BORDER_COLOR));
  style.setRotation(getShort(properties, ROTATION));
  style.setTopBorderColor(getShort(properties, TOP_BORDER_COLOR));
  style.setWrapText(getBoolean(properties, WRAP_TEXT));
}

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

/**
 * Sets the format properties of the given style based on the given map.
 *
 * @param style cell style
 * @param workbook parent workbook
 * @param properties map of format properties (String -> Object)
 * @see #getFormatProperties(CellStyle)
 */
private static void setFormatProperties(CellStyle style, Workbook workbook, Map<String, Object> properties) {
  style.setAlignment(getShort(properties, ALIGNMENT));
  style.setBorderBottom(getShort(properties, BORDER_BOTTOM));
  style.setBorderLeft(getShort(properties, BORDER_LEFT));
  style.setBorderRight(getShort(properties, BORDER_RIGHT));
  style.setBorderTop(getShort(properties, BORDER_TOP));
  style.setBottomBorderColor(getShort(properties, BOTTOM_BORDER_COLOR));
  style.setDataFormat(getShort(properties, DATA_FORMAT));
  style.setFillBackgroundColor(getShort(properties, FILL_BACKGROUND_COLOR));
  style.setFillForegroundColor(getShort(properties, FILL_FOREGROUND_COLOR));
  style.setFillPattern(getShort(properties, FILL_PATTERN));
  style.setFont(workbook.getFontAt(getShort(properties, FONT)));
  style.setHidden(getBoolean(properties, HIDDEN));
  style.setIndention(getShort(properties, INDENTION));
  style.setLeftBorderColor(getShort(properties, LEFT_BORDER_COLOR));
  style.setLocked(getBoolean(properties, LOCKED));
  style.setRightBorderColor(getShort(properties, RIGHT_BORDER_COLOR));
  style.setRotation(getShort(properties, ROTATION));
  style.setTopBorderColor(getShort(properties, TOP_BORDER_COLOR));
  style.setVerticalAlignment(getShort(properties, VERTICAL_ALIGNMENT));
  style.setWrapText(getBoolean(properties, WRAP_TEXT));
}

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

/**
 * Sets the format properties of the given style based on the given map.
 *
 * @param style cell style
 * @param workbook parent workbook
 * @param properties map of format properties (String -> Object)
 * @see #getFormatProperties(CellStyle)
 */
private static void setFormatProperties(CellStyle style, Workbook workbook, Map<String, Object> properties) {
  style.setAlignment(getShort(properties, ALIGNMENT));
  style.setBorderBottom(getShort(properties, BORDER_BOTTOM));
  style.setBorderLeft(getShort(properties, BORDER_LEFT));
  style.setBorderRight(getShort(properties, BORDER_RIGHT));
  style.setBorderTop(getShort(properties, BORDER_TOP));
  style.setBottomBorderColor(getShort(properties, BOTTOM_BORDER_COLOR));
  style.setDataFormat(getShort(properties, DATA_FORMAT));
  style.setFillBackgroundColor(getShort(properties, FILL_BACKGROUND_COLOR));
  style.setFillForegroundColor(getShort(properties, FILL_FOREGROUND_COLOR));
  style.setFillPattern(getShort(properties, FILL_PATTERN));
  style.setFont(workbook.getFontAt(getShort(properties, FONT)));
  style.setHidden(getBoolean(properties, HIDDEN));
  style.setIndention(getShort(properties, INDENTION));
  style.setLeftBorderColor(getShort(properties, LEFT_BORDER_COLOR));
  style.setLocked(getBoolean(properties, LOCKED));
  style.setRightBorderColor(getShort(properties, RIGHT_BORDER_COLOR));
  style.setRotation(getShort(properties, ROTATION));
  style.setTopBorderColor(getShort(properties, TOP_BORDER_COLOR));
  style.setVerticalAlignment(getShort(properties, VERTICAL_ALIGNMENT));
  style.setWrapText(getBoolean(properties, WRAP_TEXT));
}

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

/**
 * Sets the format properties of the given style based on the given map.
 *
 * @param style cell style
 * @param workbook parent workbook
 * @param properties map of format properties (String -> Object)
 * @see #getFormatProperties(CellStyle)
 */
private static void setFormatProperties(CellStyle style, Workbook workbook, Map<String, Object> properties) {
  style.setAlignment(getShort(properties, ALIGNMENT));
  style.setBorderBottom(getShort(properties, BORDER_BOTTOM));
  style.setBorderLeft(getShort(properties, BORDER_LEFT));
  style.setBorderRight(getShort(properties, BORDER_RIGHT));
  style.setBorderTop(getShort(properties, BORDER_TOP));
  style.setBottomBorderColor(getShort(properties, BOTTOM_BORDER_COLOR));
  style.setDataFormat(getShort(properties, DATA_FORMAT));
  style.setFillBackgroundColor(getShort(properties, FILL_BACKGROUND_COLOR));
  style.setFillForegroundColor(getShort(properties, FILL_FOREGROUND_COLOR));
  style.setFillPattern(getShort(properties, FILL_PATTERN));
  style.setFont(workbook.getFontAt(getShort(properties, FONT)));
  style.setHidden(getBoolean(properties, HIDDEN));
  style.setIndention(getShort(properties, INDENTION));
  style.setLeftBorderColor(getShort(properties, LEFT_BORDER_COLOR));
  style.setLocked(getBoolean(properties, LOCKED));
  style.setRightBorderColor(getShort(properties, RIGHT_BORDER_COLOR));
  style.setRotation(getShort(properties, ROTATION));
  style.setTopBorderColor(getShort(properties, TOP_BORDER_COLOR));
  style.setVerticalAlignment(getShort(properties, VERTICAL_ALIGNMENT));
  style.setWrapText(getBoolean(properties, WRAP_TEXT));
}

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

/**
 * Sets the format properties of the given style based on the given map.
 *
 * @param style cell style
 * @param workbook parent workbook
 * @param properties map of format properties (String -> Object)
 * @see #getFormatProperties(CellStyle)
 */
private static void setFormatProperties(CellStyle style, Workbook workbook, Map<String, Object> properties) {
  style.setAlignment(getShort(properties, ALIGNMENT));
  style.setBorderBottom(getShort(properties, BORDER_BOTTOM));
  style.setBorderLeft(getShort(properties, BORDER_LEFT));
  style.setBorderRight(getShort(properties, BORDER_RIGHT));
  style.setBorderTop(getShort(properties, BORDER_TOP));
  style.setBottomBorderColor(getShort(properties, BOTTOM_BORDER_COLOR));
  style.setDataFormat(getShort(properties, DATA_FORMAT));
  style.setFillBackgroundColor(getShort(properties, FILL_BACKGROUND_COLOR));
  style.setFillForegroundColor(getShort(properties, FILL_FOREGROUND_COLOR));
  style.setFillPattern(getShort(properties, FILL_PATTERN));
  style.setFont(workbook.getFontAt(getShort(properties, FONT)));
  style.setHidden(getBoolean(properties, HIDDEN));
  style.setIndention(getShort(properties, INDENTION));
  style.setLeftBorderColor(getShort(properties, LEFT_BORDER_COLOR));
  style.setLocked(getBoolean(properties, LOCKED));
  style.setRightBorderColor(getShort(properties, RIGHT_BORDER_COLOR));
  style.setRotation(getShort(properties, ROTATION));
  style.setTopBorderColor(getShort(properties, TOP_BORDER_COLOR));
  style.setVerticalAlignment(getShort(properties, VERTICAL_ALIGNMENT));
  style.setWrapText(getBoolean(properties, WRAP_TEXT));
}

代码示例来源：origin: com.github.nic-luo/rober-office

toStyle.setRotation(fromStyle.getRotation());        //旋转
toStyle.setVerticalAlignment(fromStyle.getVerticalAlignment());
toStyle.setWrapText(fromStyle.getWrapText());

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

CellStyle

相关文章

    查看更多
    微信公众号

    热门标签

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

    最新文章

    更多

    CellStyle类方法

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