private short GetXLColour(HSSFWorkbook workbook, System.Drawing.Color SystemColour)
{
short s = 0;
HSSFPalette XlPalette = workbook.GetCustomPalette();
NPOI.HSSF.Util.HSSFColor XlColour = XlPalette.FindColor(SystemColour.R, SystemColour.G, SystemColour.B);
if (XlColour == null)
{
if (NPOI.HSSF.Record.PaletteRecord.STANDARD_PALETTE_SIZE < 255)
{
if (NPOI.HSSF.Record.PaletteRecord.STANDARD_PALETTE_SIZE < 64)
{
//NPOI.HSSF.Record.PaletteRecord.STANDARD_PALETTE_SIZE= 64;
//NPOI.HSSF.Record.PaletteRecord.STANDARD_PALETTE_SIZE += 1;
XlColour = XlPalette.AddColor(SystemColour.R, SystemColour.G, SystemColour.B);
}
else
{
XlColour = XlPalette.FindSimilarColor(SystemColour.R, SystemColour.G, SystemColour.B);
}
s = XlColour.Indexed;
}
}
else
{
s = XlColour.Indexed;
}
return(s);
}
public void Compare(HSSFColor expected, HSSFColor palette)
{
short[] s1 = expected.GetTriplet();
short[] s2 = palette.GetTriplet();
Assert.AreEqual(s1[0], s2[0]);
Assert.AreEqual(s1[1], s2[1]);
Assert.AreEqual(s1[2], s2[2]);
}
public void Compare(HSSFColor expected, HSSFColor palette)
{
Assert.AreEqual(expected.GetHexString(), palette.GetHexString());
}
public static string GetColor(HSSFColor color)
{
StringBuilder stringBuilder = new StringBuilder(7);
stringBuilder.Append('#');
foreach (short s in color.GetTriplet())
{
//if (s < 10)
// stringBuilder.Append('0');
stringBuilder.Append(s.ToString("x2"));
}
string result = stringBuilder.ToString();
if (result.Equals("#ffffff"))
return "white";
if (result.Equals("#c0c0c0"))
return "silver";
if (result.Equals("#808080"))
return "gray";
if (result.Equals("#000000"))
return "black";
return result;
}
private static int GetIndex2(HSSFColor color)
{
FieldInfo f = color.GetType().GetField("Index2", BindingFlags.Static | BindingFlags.Public);
if (f == null)
{
return -1;
}
short s = (short)f.GetValue(color);
return Convert.ToInt32(s);
}
private static int GetIndex2(HSSFColor color)
{
FieldInfo f;
f = color.GetType().GetField("index2", BindingFlags.Static | BindingFlags.Public);
if (f == null)
{
return -1;
}
short s;
try
{
s = (short)f.GetValue(color);
}
catch (ArgumentException)
{
throw;
}
catch (InvalidOperationException)
{
throw;
}
return Convert.ToInt32(s);
}
public void Compare(HSSFColor expected, HSSFColor palette)
{
byte[] s1 = expected.RGB;
byte[] s2 = palette.RGB;
Assert.AreEqual(s1[0], s2[0]);
Assert.AreEqual(s1[1], s2[1]);
Assert.AreEqual(s1[2], s2[2]);
}
private HSSFCellStyle GetCellStyle(HSSFWorkbook workbook, string formatString, HSSFColor colour)
{
HSSFCellStyle cellStyle;
cellStyle = workbook.CreateCellStyle() as HSSFCellStyle;
HSSFDataFormat dataFormat = workbook.CreateDataFormat() as HSSFDataFormat;
if (cellStyle != null)
{
if (dataFormat != null) cellStyle.DataFormat = dataFormat.GetFormat(formatString);
cellStyle.FillForegroundColor = colour.Indexed;
cellStyle.FillPattern = FillPattern.SolidForeground;
//cellStyle.BorderBottom = BorderStyle.THIN;
//cellStyle.BorderLeft = BorderStyle.THIN;
//cellStyle.BorderRight = BorderStyle.THIN;
//cellStyle.BorderTop = BorderStyle.THIN;
}
return cellStyle;
}
IndexedColors(int idx, HSSFColor color)
{
index = idx;
this.hssfColor = color;
}
