cscの作法 その346

概要

cscの作法、調べてみた。
練習問題、やってみた。

練習問題

closedxmlで数式を設定した、xlsxを作れ。

写真

サンプルコード

using System;
using System.IO;
using ClosedXML.Excel;

namespace App
{
	class Program {
		static void Main(string[] args) {
			var filePath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Desktop), "Book11.xlsx");
			var wb = new XLWorkbook();
			var ws = wb.Worksheets.Add("Sheet1");
			int i;
			int j;
			for (i = 1; i < 11; i++)
			{
				for (j = 1; j < 11; j++)
				{
					ws.Cell(i, j).Value = i * 10 + j - 10;
				}
			}
			ws.Cell(11, 1).FormulaA1 = "SUM(A1:A10)";
			ws.Cell(11, 2).FormulaA1 = "SUM(B1:B10)";
			ws.Cell(11, 3).FormulaA1 = "SUM(C1:C10)";
			ws.Cell(11, 4).FormulaA1 = "SUM(D1:D10)";
			ws.Cell(11, 5).FormulaA1 = "SUM(E1:E10)";
			ws.Cell(11, 6).FormulaA1 = "SUM(F1:F10)";
			ws.Cell(11, 7).FormulaA1 = "SUM(G1:G10)";
			ws.Cell(11, 8).FormulaA1 = "SUM(H1:H10)";
			ws.Cell(11, 9).FormulaA1 = "SUM(I1:I10)";
			ws.Cell(11, 10).FormulaA1 = "SUM(J1:J10)";
			wb.SaveAs(filePath);
			Console.WriteLine("ok");
		}
	}
}

以上。