public void ExcelColorTest()
{
ListSerializable <User> users = new UserList();
users.Add(new User("Toto", "Titi"));
users.Add(new User("Tata", "Roro"));
string currentDirectory = Directory.GetCurrentDirectory();
string ExcelFile = Path.Combine(currentDirectory, "test.xlsx");
ExcelWriter <User> writer = new ExcelWriter <User>("Users", new StringList {
"Name", "Firstname"
});
writer.Write <UserList>(users, ExcelFile);
ExcelColor color = null;
using (ExcelPackage excel = new ExcelPackage(new FileInfo(ExcelFile)))
{
var worksheet = excel.Workbook.Worksheets["Users"];
color = worksheet.Cells["A1:B2"].Style.Font.Color;
color.SetColor(System.Drawing.Color.White);
}
System.Windows.Media.Color colorTransform = Color.ToMediaColor(color);
Assert.AreEqual(colorTransform.ToDrawingColor().ToArgb(), System.Drawing.Color.White.ToArgb());
FileManager.Delete(ExcelFile);
}
private static void SetColor(ExcelColor excelColor, ExcelCell.Color color)
{
if (IsEmptyColor(color))
{
return;
}
if (color.theme.HasValue)
{
excelColor.SetColor(color.theme.Value);
if (color.tint.HasValue)
{
excelColor.Tint = color.tint.Value;
}
}
else
{
excelColor.SetColor(ColorTranslator.FromHtml("#" + color.rgb));
}
}
public void SetColorArgb(int alpha, int red, int green, int blue)
{
var color = System.Drawing.Color.FromArgb(alpha, red, green, blue);
m_excelColor.SetColor(color);
}
