元技術者のぶーろぐ

using System.Numerics;
public class NumberList<T> where T :INumber<T> {
	protected List<T> Numbers { get; set; }
	public  NumberList() {
		Numbers = new ();
	}
	public NumberList(IEnumerable<T> Values):
		this() {
		Numbers.AddRange(Values);
	}
	public void Append(T Value) {
		Numbers.Add(Value);
	}
	public T Sum() {
		T sum = T.Zero;
		foreach(var v in Numbers) {
			sum += v;
		}
		return sum;
	}
	public void Map(Func<T,T> Operation) {
		for(int i=0; i < Numbers.Count; i++) {
			Numbers[i] = Operation(Numbers[i]);
		}
	}
	public IEnumerator<T> GetEnumerator() {
		foreach(var v in Numbers) {
			yield return v;
		}
	}
}
List<int> inumbers = new () { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 };
NumberList<int> ilst = new (inumbers);
Console.WriteLine(ilst.Sum());
ilst.Map((v)=>v*v);
foreach(var v in ilst) {
	Console.Write($"{v},");
}
Console.WriteLine();
List<double> dnumbers = new () { 0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1.0 };
NumberList<double> dlst = new (dnumbers);
Console.WriteLine(dlst.Sum());
dlst.Map(Math.Sqrt);
foreach(var v in dlst) {
	Console.Write($"{v.ToString("0.0000")},");
}
Console.WriteLine();

55
1,4,9,16,25,36,49,64,81,100,
5.5
0.32,0.45,0.55,0.63,0.71,0.77,0.84,0.89,0.95,1.00,

string jsonstr = """
[
    {"Name": "T.Sumomo", "Email": "t.sumomo@momo.com"},
    {"Name": "J.Sumomo", "Email": "j.sumomo@momo.com"},
    {"Name": "S.Sumomo", "Email": "s.sumomo@momo.com"}
]
""";

int x = 100;
int y = 200;
string replstr = $$"""
    { "X" : {{x}}, "Y": {{y}} }
""";

string example = """"
string jsonstr = """
[
    {"Name": "T.Sumomo", "Email": "t.sumomo@momo.com"},
    {"Name": "J.Sumomo", "Email": "j.sumomo@momo.com"},
    {"Name": "S.Sumomo", "Email": "s.sumomo@momo.com"}
]
""";
"""";

using(var wb = new XLWorkbook()) {
    var ws = wb.Worksheets.Add("MySheet");
    // セル結合
    ws.Range(1,1,1,10).Merge();
    ws.Cell(1,1).Value = "ClosedXML Test";
    // 文字配置
    ws.Cell(1,1).Style.Alignment.SetHorizontal(XLAlignmentHorizontalValues.Center);

    for(int i=1; i <= 10; i++) {
        for(int j=1; j <= 10; j++) {
            ws.Cell(i+2,j).Value = i*j;
        }
        var xrng = ws.Range(i+2,1,i+2,10);
        if ((i%2) == 0) {
            // セル背景色
            xrng.Style.Fill.SetPatternType(XLFillPatternValues.Solid);
            xrng.Style.Fill.SetBackgroundColor(XLColor.AirForceBlue);
        }
    }

    for(int i=0; i < 10; i++) {
        // Excel関数
        char c = (char)('A'+i);
        ws.Cell(13,i+1).SetFormulaA1($"=SUM({c}3:{c}12)");
    }

    // 罫線
    var rng = ws.Range(3,1,13,10);
    rng.Style.Border.SetOutsideBorder(XLBorderStyleValues.Thin);
    rng.Style.Border.SetInsideBorder(XLBorderStyleValues.Thin);

    // 幅自動調整
    ws.Columns(1,10).AdjustToContents();

	// 保存
    wb.SaveAs(filename);
}

public async Task<IActionResult> OnPostAsync() {
	・・・
	// ダウンロード
	using(MemoryStream stm = new MemoryStream()) {
	    wb.SaveAs(stm);
	    await stm.FlushAsync();
	    byte[] buf = stm.ToArray();
	    return File(buf,"application/octet-stream",FileName);
	}
}