///// <summary>
///// 樣式的值是否改變
///// </summary>
//internal bool StyleValueIsChange
//{
// get { return _styleValueIsChange; }
// set{_styleValueIsChange =value;}
//}
#endregion
#region 方法
internal ICellStyle GetCellStyle(NPOI.HSSF.UserModel.HSSFWorkbook workBook)
{
if (workBook == null)
{
throw new ArgumentNullException("workBook參數不能為NULL。");
}
if (_cellStyle == null || _styleValueIsChange)
{
_cellStyle = workBook.CreateCellStyle();
IFont font = workBook.FindFont((short)_fontBold, _fontColor, (short)(_fontSize * 20), _fontName, _isItalic, _isStrikeout, _fontTypeOffset, (byte)_underline);
if (font == null)
{
font = workBook.CreateFont();
font.FontName = this._fontName;
font.Boldweight = (short)this._fontBold;
font.FontHeightInPoints = (short)this._fontSize;
font.Underline = (byte)this.UnderLine;
font.IsItalic = _isItalic;
font.Color = _fontColor;
font.IsStrikeout = _isStrikeout;
font.TypeOffset = _fontTypeOffset;
}
_cellStyle.SetFont(font);
IDataFormat format = workBook.CreateDataFormat();
_cellStyle.BorderBottom = this._borderBottom;
_cellStyle.BorderLeft = this._borderLeft;
_cellStyle.BorderRight = this._borderRight;
_cellStyle.BorderTop = this._borderTop;
_cellStyle.Alignment = this._alignment;
_cellStyle.VerticalAlignment = this.VerticalAlignment;
if (!string.IsNullOrEmpty(_dataFormart))
{
_cellStyle.DataFormat = format.GetFormat(this._dataFormart);
}
_cellStyle.WrapText = this._warpText;
_styleValueIsChange = false;
}
return(_cellStyle);
}
