private void ReadBytes(Bytes bytes)
{
byte[] byteArray = bytes.ByteArray;
_height = BitConverter.ToUInt16(byteArray, 0);
SetOptionsValue(bytes.Get(2, 2));
_colorIndex = BitConverter.ToUInt16(byteArray, 4);
_weight = FontWeightConverter.Convert(BitConverter.ToUInt16(byteArray, 6));
_escapement = (EscapementTypes)BitConverter.ToUInt16(byteArray, 8);
_underline = (UnderlineTypes)byteArray[10];
_fontFamily = (FontFamilies)byteArray[11];
_characterSet = (CharacterSets)byteArray[12];
//skip byte index 13
_fontName = UnicodeBytes.Read(bytes.Get(14, bytes.Length - 14), 8);
}
private void SetDefaults()
{
_height = 200;
_italic = false;
_underlined = false;
_struckOut = false;
_colorIndex = 32767;
_weight = FontWeight.Normal;
_escapement = EscapementTypes.Default;
_underline = UnderlineTypes.Default;
_fontFamily = FontFamilies.Default;
_characterSet = CharacterSets.Default;
_notUsed = 0;
_fontName = "Arial";
OnChange();
}
private void SetDefaults()
{
_height = 200;
_italic = false;
_underlined = false;
_struckOut = false;
_color = new Color(32767);
_weight = FontWeight.Normal;
_escapement = EscapementTypes.Default;
_underline = UnderlineTypes.Default;
_fontFamily = FontFamilies.Default;
_characterSet = CharacterSets.Default;
_notUsed = 0;
_fontName = "Arial";
OnChange();
}
private void ReadBytes(Bytes bytes)
{
byte[] byteArray = bytes.ByteArray;
_height = BitConverter.ToUInt16(byteArray, 0);
SetOptionsValue(bytes.Get(2, 2));
_color = _doc.Workbook.Palette.GetColor(BitConverter.ToUInt16(byteArray, 4));
_weight = FontWeightConverter.Convert(BitConverter.ToUInt16(byteArray, 6));
_escapement = (EscapementTypes) BitConverter.ToUInt16(byteArray, 8);
_underline = (UnderlineTypes) byteArray[10];
_fontFamily = (FontFamilies) byteArray[11];
_characterSet = (CharacterSets) byteArray[12];
//skip byte index 13
_fontName = UnicodeBytes.Read(bytes.Get(14, bytes.Length - 14), 8);
}
/// <summary>
/// 创建一个表格单元格的样式，fontSize=0表示使用默认大小11,默认居中
/// </summary>
/// <param name="doc"></param>
/// <param name="cellLine">是否使用边框线</param>
/// <param name="underline">字体是下划线样式，默认没有下划线</param>
/// <param name="fontSize">字体大小，0表示11</param>
/// <returns></returns>
public static AppLibrary.WriteExcel.XF NewXf(XlsDocument doc, CellLine cellLine, UnderlineTypes underline = UnderlineTypes.None, int fontSize = 0)
{
int size = fontSize;
if (fontSize == 0)
{
size = 10;
}
AppLibrary.WriteExcel.XF xf = doc.NewXF();
xf.Font.FontName = "宋体";
xf.Font.Height = (ushort)(size * 20);
xf.Font.Underline = underline;
xf.TextWrapRight = true;
xf.HorizontalAlignment = AppLibrary.WriteExcel.HorizontalAlignments.Centered;
xf.VerticalAlignment = AppLibrary.WriteExcel.VerticalAlignments.Centered;
if (cellLine.ShowTop)
{
xf.TopLineStyle = 1;
}
if (cellLine.ShowRight)
{
xf.RightLineStyle = 1;
}
if (cellLine.ShowBottom)
{
xf.BottomLineStyle = 1;
}
if (cellLine.ShowLeft)
{
xf.LeftLineStyle = 1;
}
return(xf);
}