public void Translate_6FigureHexVal_ReturnSameRGBAndFullAlpha()
{
var result = HTMLColorTranslator.Translate("#1A3F44");
Assert.AreEqual(result.A, 0xFF);
Assert.AreEqual(result.R, 0x1A);
Assert.AreEqual(result.G, 0x3F);
Assert.AreEqual(result.B, 0x44);
}
public void Translate_NamedColor_ReturnsRGBEquivalent()
{
var result = HTMLColorTranslator.Translate("slateblue");
Assert.AreEqual(result.A, 0xFF);
Assert.AreEqual(result.R, 106);
Assert.AreEqual(result.G, 90);
Assert.AreEqual(result.B, 205);
}
public void Translate_3FigureHexVal_ReturnsRGBWhereSingleDigitIsExpandedToTwoOfSameDigit()
{
var result = HTMLColorTranslator.Translate("#F2B");
Assert.AreEqual(result.A, 0xFF);
Assert.AreEqual(result.R, 0xFF);
Assert.AreEqual(result.G, 0x22);
Assert.AreEqual(result.B, 0xBB);
}
/// <summary>
/// Creates the captcha image.
/// </summary>
public byte[] DrawCaptcha(string message, string foreColor, string backColor, float fontSize, string fontName)
{
var fColor = Color.FromArgb(HTMLColorTranslator.Translate(foreColor).R, HTMLColorTranslator.Translate(foreColor).G,
HTMLColorTranslator.Translate(foreColor).B);
var bColor = string.IsNullOrWhiteSpace(backColor)
? Color.Transparent
: Color.FromArgb(HTMLColorTranslator.Translate(backColor).R, HTMLColorTranslator.Translate(backColor).G,
HTMLColorTranslator.Translate(backColor).B);
var captchaFont = new Font(fontName, fontSize, FontStyle.Regular, GraphicsUnit.Pixel);
var captchaSize = MeasureString(message, captchaFont);
const int margin = 8;
var height = (int)captchaSize.Height + margin;
var width = (int)captchaSize.Width + margin;
var rectF = new Rectangle(0, 0, width: width, height: height);
using (var pic = new Bitmap(width: width, height: height))
{
using (var graphics = Graphics.FromImage(pic))
{
graphics.SmoothingMode = SmoothingMode.AntiAlias;
graphics.SmoothingMode = SmoothingMode.HighQuality;
graphics.CompositingQuality = CompositingQuality.HighQuality;
graphics.InterpolationMode = InterpolationMode.High;
graphics.TextRenderingHint = TextRenderingHint.AntiAlias;
using (var font = captchaFont)
{
using (var format = new StringFormat())
{
format.FormatFlags = StringFormatFlags.DirectionRightToLeft;
var rect = DrawRoundedRectangle(graphics, rectF, 15, new Pen(bColor)
{
Width = 1.1f
}, bColor);
graphics.DrawString(message, font, new SolidBrush(fColor), rect, format);
using (var stream = new MemoryStream())
{
DistortImage(height, width, pic);
pic.Save(stream, ImageFormat.Png);
return(stream.ToArray());
}
}
}
}
}
}
public void Translate_3FigureHexVal_CaseInsensitive()
{
var result = HTMLColorTranslator.Translate("#f2b");
Assert.AreEqual(result.A, 0xFF);
Assert.AreEqual(result.R, 0xFF);
Assert.AreEqual(result.G, 0x22);
Assert.AreEqual(result.B, 0xBB);
result = HTMLColorTranslator.Translate("#f2B");
Assert.AreEqual(result.A, 0xFF);
Assert.AreEqual(result.R, 0xFF);
Assert.AreEqual(result.G, 0x22);
Assert.AreEqual(result.B, 0xBB);
}
public void Translate_6FigureHexVal_CaseInsensitive()
{
var result = HTMLColorTranslator.Translate("#1a3f4b");
Assert.AreEqual(result.A, 0xFF);
Assert.AreEqual(result.R, 0x1A);
Assert.AreEqual(result.G, 0x3F);
Assert.AreEqual(result.B, 0x4B);
result = HTMLColorTranslator.Translate("#1a3F4b");
Assert.AreEqual(result.A, 0xFF);
Assert.AreEqual(result.R, 0x1A);
Assert.AreEqual(result.G, 0x3F);
Assert.AreEqual(result.B, 0x4B);
}
public void Translate_NamedColor_CaseInsensitive()
{
var result = HTMLColorTranslator.Translate("SLATEBLUE");
Assert.AreEqual(result.A, 0xFF);
Assert.AreEqual(result.R, 106);
Assert.AreEqual(result.G, 90);
Assert.AreEqual(result.B, 205);
result = HTMLColorTranslator.Translate("SlateBlue");
Assert.AreEqual(result.A, 0xFF);
Assert.AreEqual(result.R, 106);
Assert.AreEqual(result.G, 90);
Assert.AreEqual(result.B, 205);
result = HTMLColorTranslator.Translate("sLaTeBlUe");
Assert.AreEqual(result.A, 0xFF);
Assert.AreEqual(result.R, 106);
Assert.AreEqual(result.G, 90);
Assert.AreEqual(result.B, 205);
}
public void Translate_TrailingOrLeadingWhitespace_Trims()
{
var result = HTMLColorTranslator.Translate(" #1A3F44");
Assert.AreEqual(result.A, 0xFF);
Assert.AreEqual(result.R, 0x1A);
Assert.AreEqual(result.G, 0x3F);
Assert.AreEqual(result.B, 0x44);
result = HTMLColorTranslator.Translate(" #F2B ");
Assert.AreEqual(result.A, 0xFF);
Assert.AreEqual(result.R, 0xFF);
Assert.AreEqual(result.G, 0x22);
Assert.AreEqual(result.B, 0xBB);
result = HTMLColorTranslator.Translate("slateblue ");
Assert.AreEqual(result.A, 0xFF);
Assert.AreEqual(result.R, 106);
Assert.AreEqual(result.G, 90);
Assert.AreEqual(result.B, 205);
result = HTMLColorTranslator.Translate(" SlateBlue ");
Assert.AreEqual(result.A, 0xFF);
Assert.AreEqual(result.R, 106);
Assert.AreEqual(result.G, 90);
Assert.AreEqual(result.B, 205);
}
public IActionResult DownExcel(string data)
{
List <JObject> dowExcels = JsonConvert.DeserializeObject <List <JObject> >(data);
IWorkbook workbook;
workbook = new HSSFWorkbook();
//赋予表格默认样式，因为样式文件存储只能有4000个
ICellStyle cellStyle = workbook.CreateCellStyle();
cellStyle.VerticalAlignment = VerticalAlignment.Center; //垂直居中
cellStyle.WrapText = true; //自动换行
cellStyle.Alignment = HorizontalAlignment.Center; //水平居中
cellStyle.FillPattern = FillPattern.NoFill; //背景色是必须要这数据
cellStyle.FillForegroundColor = IndexedColors.White.Index; //默认背景色
foreach (var item in dowExcels)
{
var columnlen = item["config"] != null ? item["config"]["columnlen"] : null;
var rowlen = item["config"] != null ? item["config"]["rowlen"] : null;
var borderInfo = item["config"] != null ? item["config"]["borderInfo"] : null;
var merge = item["config"] != null ? item["config"]["merge"] : null;
var Cjarray = item["celldata"];
//读取了模板内所有sheet内容
ISheet sheet = workbook.CreateSheet(item["name"].ToString());
//判断是否有值，并且赋予样式
if (Cjarray != null)
{
for (int i = 0; i < Cjarray.Count(); i++)
{
//判断行，存不存在，不存在创建
IRow row = sheet.GetRow(int.Parse(Cjarray[i]["r"].ToString()));
if (row == null)
{
row = sheet.CreateRow(int.Parse(Cjarray[i]["r"].ToString()));
}
var ct = Cjarray[i]["v"]["ct"];
var cct = Cjarray[i]["v"];
if (ct != null && ct["s"] != null)
{
//合并单元格的走这边
string celldatas = "";
//合并单元格时，会导致文字丢失，提前处理文字信息
for (int j = 0; j < ct["s"].Count(); j++)
{
var stv = ct["s"][j];
celldatas += stv["v"] != null ? stv["v"].ToString() : "";
}
//判断列，不存在创建
ICell Cell = row.GetCell(int.Parse(Cjarray[i]["c"].ToString()));
if (Cell == null)
{
HSSFRichTextString richtext = new HSSFRichTextString(celldatas);
Cell = row.CreateCell(int.Parse(Cjarray[i]["c"].ToString()));
for (int k = 0; k < ct["s"].Count(); k++)
{
IFont font = workbook.CreateFont();
var stv = ct["s"][k];
//文字颜色
if (stv["fc"] != null)
{
var rGB = HTMLColorTranslator.Translate(stv["fc"].ToString());
var color = Color.FromArgb(rGB.R, rGB.G, rGB.B);
font.Color = ((HSSFWorkbook)workbook).GetCustomPalette().FindSimilarColor(color.R, color.G, color.B).Indexed;
}
else
{
font.Color = HSSFColor.Black.Index;
}
//是否加粗
if (stv["bl"] != null)
{
font.IsBold = !string.IsNullOrEmpty(stv["bl"].ToString()) && (stv["bl"].ToString() == "1" ? true : false);
font.Boldweight = stv["bl"].ToString() == "1" ? (short)FontBoldWeight.Bold : (short)FontBoldWeight.None;
}
else
{
font.IsBold = false;
font.Boldweight = (short)FontBoldWeight.None;
}
//是否斜体
if (stv["it"] != null)
{
font.IsItalic = !string.IsNullOrEmpty(stv["it"].ToString()) && (stv["it"].ToString() == "1" ? true : false);
}
else
{
font.IsItalic = false;
}
//下划线
if (stv["un"] != null)
{
font.Underline = stv["un"].ToString() == "1" ? FontUnderlineType.Single : FontUnderlineType.None;
}
else
{
font.Underline = FontUnderlineType.None;
}
//字体
if (stv["ff"] != null)
{
font.FontName = stv["ff"].ToString();
}
//文字大小
if (stv["fs"] != null)
{
font.FontHeightInPoints = double.Parse(stv["fs"].ToString());
}
Cell.CellStyle.SetFont(font);
richtext.ApplyFont(celldatas.IndexOf(stv["v"].ToString()), celldatas.IndexOf(stv["v"].ToString()) + stv["v"].ToString().Length, font);
Cell.SetCellValue(richtext);
}
//背景颜色
if (cct["bg"] != null)
{
ICellStyle cellStyle1 = workbook.CreateCellStyle();
cellStyle1.CloneStyleFrom(cellStyle);
if (cct["bg"] != null)
{
var rGB = HTMLColorTranslator.Translate(cct["bg"].ToString());
var color = Color.FromArgb(rGB.R, rGB.G, rGB.B);
cellStyle1.FillPattern = FillPattern.SolidForeground;
cellStyle1.FillForegroundColor = ((HSSFWorkbook)workbook).GetCustomPalette().FindSimilarColor(color.R, color.G, color.B).Indexed;
}
Cell.CellStyle = cellStyle1;
}
else
{
Cell.CellStyle = cellStyle;
}
}
}
else
{
//没有合并单元格的走这边
//判断列，不存在创建
ICell Cell = row.GetCell(int.Parse(Cjarray[i]["c"].ToString()));
if (Cell == null)
{
Cell = row.CreateCell(int.Parse(Cjarray[i]["c"].ToString()));
IFont font = workbook.CreateFont();
ct = Cjarray[i]["v"];
//字体颜色
if (ct["fc"] != null)
{
var rGB = HTMLColorTranslator.Translate(ct["fc"].ToString());
var color = Color.FromArgb(rGB.R, rGB.G, rGB.B);
font.Color = ((HSSFWorkbook)workbook).GetCustomPalette().FindSimilarColor(color.R, color.G, color.B).Indexed;
}
else
{
font.Color = HSSFColor.Black.Index;
}
//是否加粗
if (ct["bl"] != null)
{
font.IsBold = !string.IsNullOrEmpty(ct["bl"].ToString()) && (ct["bl"].ToString() == "1" ? true : false);
font.Boldweight = ct["bl"].ToString() == "1" ? (short)FontBoldWeight.Bold : (short)FontBoldWeight.None;
}
else
{
font.IsBold = false;
font.Boldweight = (short)FontBoldWeight.None;
}
//斜体
if (ct["it"] != null)
{
font.IsItalic = !string.IsNullOrEmpty(ct["it"].ToString()) && (ct["it"].ToString() == "1" ? true : false);
}
else
{
font.IsItalic = false;
}
//下划线
if (ct["un"] != null)
{
font.Underline = ct["un"].ToString() == "1" ? FontUnderlineType.Single : FontUnderlineType.None;
}
else
{
font.Underline = FontUnderlineType.None;
}
//字体
if (ct["ff"] != null)
{
font.FontName = ct["ff"].ToString();
}
//文字大小
if (ct["fs"] != null)
{
font.FontHeightInPoints = double.Parse(ct["fs"].ToString());
}
Cell.CellStyle.SetFont(font);
//判断背景色
if (ct["bg"] != null)
{
ICellStyle cellStyle1 = workbook.CreateCellStyle();
cellStyle1.CloneStyleFrom(cellStyle);
if (ct["bg"] != null)
{
var rGB = HTMLColorTranslator.Translate(ct["bg"].ToString());
var color = Color.FromArgb(rGB.R, rGB.G, rGB.B);
cellStyle1.FillPattern = FillPattern.SolidForeground;
cellStyle1.FillForegroundColor = ((HSSFWorkbook)workbook).GetCustomPalette().FindSimilarColor(color.R, color.G, color.B).Indexed;
}
Cell.CellStyle = cellStyle1;
}
else
{
Cell.CellStyle = cellStyle;
}
Cell.SetCellValue(ct["v"] != null ? ct["v"].ToString() : "");
}
}
}
sheet.ForceFormulaRecalculation = true;
}
//判断是否要设置列宽度
if (columnlen != null)
{
foreach (var cols in columnlen)
{
var p = cols as JProperty;
sheet.SetColumnWidth(int.Parse(p.Name), int.Parse(p.Value.ToString()) * 38);
}
}
//判断是否要设置行高度
if (rowlen != null)
{
foreach (var rows in rowlen)
{
var p = rows as JProperty;
sheet.GetRow(int.Parse(p.Name)).HeightInPoints = float.Parse(p.Value.ToString());
}
}
//判断是否要加边框
if (borderInfo != null)
{
for (int i = 0; i < borderInfo.Count(); i++)
{
var bordervalue = borderInfo[i]["value"];
if (bordervalue != null)
{
var rowindex = bordervalue["row_index"];
var colindex = bordervalue["col_index"];
var l = bordervalue["l"];
var r = bordervalue["r"];
var t = bordervalue["t"];
var b = bordervalue["b"];
if (rowindex != null)
{
IRow rows = sheet.GetRow(int.Parse(bordervalue["row_index"].ToString()));
if (colindex != null)
{
ICell cell = rows.GetCell(int.Parse(bordervalue["col_index"].ToString()));
if (b != null)
{
cell.CellStyle.BorderBottom = ExcelHepler.GetBorderStyle(int.Parse(b["style"].ToString()));
var rGB = HTMLColorTranslator.Translate(b["color"].ToString());
var bcolor = Color.FromArgb(rGB.R, rGB.G, rGB.B);
cell.CellStyle.BottomBorderColor = ((HSSFWorkbook)workbook).GetCustomPalette().FindSimilarColor(bcolor.R, bcolor.G, bcolor.B).Indexed;
}
else
{
cell.CellStyle.BorderBottom = BorderStyle.None;
cell.CellStyle.BottomBorderColor = HSSFColor.COLOR_NORMAL;
}
if (t != null)
{
cell.CellStyle.BorderTop = ExcelHepler.GetBorderStyle(int.Parse(t["style"].ToString()));
var rGB = HTMLColorTranslator.Translate(t["color"].ToString());
var tcolor = Color.FromArgb(rGB.R, rGB.G, rGB.B);
cell.CellStyle.TopBorderColor = ((HSSFWorkbook)workbook).GetCustomPalette().FindSimilarColor(tcolor.R, tcolor.G, tcolor.B).Indexed;
}
else
{
cell.CellStyle.BorderBottom = BorderStyle.None;
cell.CellStyle.BottomBorderColor = HSSFColor.COLOR_NORMAL;
}
if (l != null)
{
cell.CellStyle.BorderLeft = ExcelHepler.GetBorderStyle(int.Parse(l["style"].ToString()));
var rGB = HTMLColorTranslator.Translate(l["color"].ToString());
var lcolor = Color.FromArgb(rGB.R, rGB.G, rGB.B);
cell.CellStyle.LeftBorderColor = ((HSSFWorkbook)workbook).GetCustomPalette().FindSimilarColor(lcolor.R, lcolor.G, lcolor.B).Indexed;
}
else
{
cell.CellStyle.BorderBottom = BorderStyle.None;
cell.CellStyle.BottomBorderColor = HSSFColor.COLOR_NORMAL;
}
if (r != null)
{
cell.CellStyle.BorderRight = ExcelHepler.GetBorderStyle(int.Parse(r["style"].ToString()));
var rGB = HTMLColorTranslator.Translate(r["color"].ToString());
var rcolor = Color.FromArgb(rGB.R, rGB.G, rGB.B);
cell.CellStyle.RightBorderColor = ((HSSFWorkbook)workbook).GetCustomPalette().FindSimilarColor(rcolor.R, rcolor.G, rcolor.B).Indexed;
}
else
{
cell.CellStyle.BorderBottom = BorderStyle.None;
cell.CellStyle.BottomBorderColor = HSSFColor.COLOR_NORMAL;
}
}
}
}
}
}
//判断是否要合并单元格
if (merge != null)
{
foreach (var imerge in merge)
{
var firstmer = imerge.First();
int r = int.Parse(firstmer["r"].ToString()); //主单元格的行号,开始行号
int rs = int.Parse(firstmer["rs"].ToString()); //合并单元格占的行数,合并多少行
int c = int.Parse(firstmer["c"].ToString()); //主单元格的列号,开始列号
int cs = int.Parse(firstmer["cs"].ToString()); //合并单元格占的列数,合并多少列
CellRangeAddress region = new CellRangeAddress(r, r + rs - 1, c, c + cs - 1);
sheet.AddMergedRegion(region);
}
}
}
var dir = Path.Combine(Directory.GetCurrentDirectory(), @"wwwroot\Files");
if (!Directory.Exists(dir))
{
Directory.CreateDirectory(dir);
}
var fileId = Guid.NewGuid();
var fileName = $"{fileId}.xls";
FileStream stream = new FileStream(Path.Combine(dir, fileName), FileMode.OpenOrCreate);
workbook.Write(stream);
stream.Seek(0, SeekOrigin.Begin);
workbook.Close();
stream.Close();
return(Ok(fileId));
}
public void Translate_HexValueNot3Or6Long_Throws()
{
Assert.IsInstanceOf(typeof(ArgumentException), Assert.Catch(() => HTMLColorTranslator.Translate("#22")));
Assert.IsInstanceOf(typeof(ArgumentException), Assert.Catch(() => HTMLColorTranslator.Translate("#F423")));
Assert.IsInstanceOf(typeof(ArgumentException), Assert.Catch(() => HTMLColorTranslator.Translate("#F3A45DD")));
}
public void Translate_UnrecognisedInput_Throws()
{
Assert.IsInstanceOf(typeof(ArgumentException), Assert.Catch(() => HTMLColorTranslator.Translate("NOT A HTML COLOR")));
}
public void Translate_NullInput_Throws()
{
Assert.IsInstanceOf(typeof(NullReferenceException), Assert.Catch(() => HTMLColorTranslator.Translate(null)));
}
