public void testCanComputeWidthHSSF() { IWorkbook wb = new HSSFWorkbook(); // cannot check on result because on some machines we get back false here! SheetUtil.CanComputeColumnWidth(wb.GetFontAt((short)0)); wb.Close(); }
/// <summary> /// 创建并初始化工作簿 /// </summary> private void Init() { workbook = new HSSFWorkbook(); IFont font = workbook.GetFontAt((short)0); font.FontName = "宋体"; SetInformation(); }
/// <summary> /// Sets the format properties of the given style based on the given map. /// </summary> /// <param name="style">The cell style</param> /// <param name="workbook">The parent workbook.</param> /// <param name="properties">The map of format properties (String -> Object).</param> private static void SetFormatProperties( ICellStyle style, HSSFWorkbook workbook, Hashtable properties) { style.Alignment = (HorizontalAlignment)GetShort(properties, ALIGNMENT); style.BorderBottom = (BorderStyle)GetShort(properties, BORDER_BOTTOM); style.BorderLeft = (BorderStyle)GetShort(properties, BORDER_LEFT); style.BorderRight = (BorderStyle)GetShort(properties, BORDER_RIGHT); style.BorderTop = (BorderStyle)GetShort(properties, BORDER_TOP); style.BottomBorderColor = (GetShort(properties, BOTTOM_BORDER_COLOR)); style.DataFormat = (GetShort(properties, DATA_FORMAT)); style.FillBackgroundColor = (GetShort(properties, FILL_BACKGROUND_COLOR)); style.FillForegroundColor = (GetShort(properties, FILL_FOREGROUND_COLOR)); style.FillPattern = (FillPattern)GetShort(properties, FILL_PATTERN); style.SetFont(workbook.GetFontAt(GetShort(properties, FONT))); style.IsHidden = (GetBoolean(properties, HIDDEN)); style.Indention = (GetShort(properties, INDENTION)); style.LeftBorderColor = (GetShort(properties, LEFT_BORDER_COLOR)); style.IsLocked = (GetBoolean(properties, LOCKED)); style.RightBorderColor = (GetShort(properties, RIGHT_BORDER_COLOR)); style.Rotation = (GetShort(properties, ROTATION)); style.TopBorderColor = (GetShort(properties, TOP_BORDER_COLOR)); style.VerticalAlignment = (VerticalAlignment)GetShort(properties, VERTICAL_ALIGNMENT); style.WrapText = (GetBoolean(properties, WRAP_TEXT)); }