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); }