private int TopBorderOnly(XlsFile xls, int row, int col)
{
TFlxFormat tf3 = xls.GetCellVisibleFormatDef(row, col);
TFlxBorders tfBorderF = new TFlxBorders();
TFlxOneBorder oborder = new TFlxOneBorder();
oborder.Style = TFlxBorderStyle.Thin;
tfBorderF.Top = oborder;
tf3.Borders = tfBorderF;
return xls.AddFormat(tf3);
}
private int NoColorAndRightBorder(XlsFile xls, int row, int col)
{
TFlxFormat tf3 = xls.GetCellVisibleFormatDef(row, col);
TFlxFont tfont = new TFlxFont();
tfont.Style = TFlxFontStyles.Bold;
tf3.Font = tfont;
TFlxBorders tfBorderF = new TFlxBorders();
TFlxOneBorder oborder = new TFlxOneBorder();
oborder.Style = TFlxBorderStyle.Thin;
tfBorderF.Right = oborder;
tf3.Borders = tfBorderF;
return xls.AddFormat(tf3);
}
private int ColorAndRightBorder(XlsFile xls, int row, int col)
{
TFlxFormat tf4 = xls.GetCellVisibleFormatDef(row, col);
TFlxFont tfont = new TFlxFont();
tfont.Style = TFlxFontStyles.Bold;
tf4.Font = tfont;
TFlxBorders tfBorderF1 = new TFlxBorders();
TFlxOneBorder oborder1 = new TFlxOneBorder();
oborder1.Style = TFlxBorderStyle.Thin;
tfBorderF1.Right = oborder1;
tf4.Borders = tfBorderF1;
TFlxFillPattern tfpattern3 = new TFlxFillPattern();
tfpattern3.BgColor = Colors.LightGray;
tf4.FillPattern = tfpattern3;
return xls.AddFormat(tf4);
}
private int NoColorAndLeftBorder(XlsFile xls, int row, int col)
{
TFlxFormat tf3 = xls.GetCellVisibleFormatDef(row, col);
tf3.HAlignment = THFlxAlignment.left;
TFlxBorders tfBorderF = new TFlxBorders();
TFlxOneBorder oborder = new TFlxOneBorder();
oborder.Style = TFlxBorderStyle.Thin;
tfBorderF.Left = oborder;
tf3.Borders = tfBorderF;
return xls.AddFormat(tf3);
}
private int ColorAndLeftBorder(XlsFile xls, int row, int col)
{
TFlxFormat tf4 = xls.GetCellVisibleFormatDef(row, col);
tf4.HAlignment = THFlxAlignment.left;
TFlxBorders tfBorderF1 = new TFlxBorders();
TFlxOneBorder oborder1 = new TFlxOneBorder();
oborder1.Style = TFlxBorderStyle.Thin;
tfBorderF1.Left = oborder1;
tf4.Borders = tfBorderF1;
TFlxFillPattern tfpattern3 = new TFlxFillPattern();
tfpattern3.BgColor = Colors.LightGray;
tf4.FillPattern = tfpattern3;
return xls.AddFormat(tf4);
}
