C# Excel操作③ – テックメモ

using System;
using System.Windows.Forms;
// 参照の追加>COM>Microsoft Excel 16.0 Object Library
namespace ProductionManagement
{
    class Excel
    {
        public void CreateBook()
        {
            if (Type.GetTypeFromProgID("Excel.Application") == null) return;

            SaveFileDialog saveFileDialog = new SaveFileDialog();
            saveFileDialog.FileName = "title";
            saveFileDialog.Filter = "xlsx | *.xlsx";
            if (saveFileDialog.ShowDialog() != DialogResult.OK) return;

            var excel = new Microsoft.Office.Interop.Excel.Application();
            excel.DisplayAlerts = false;
            var books = excel.Workbooks;
            var book = books.Add();
            var sheets = book.Sheets;
            var sheet = sheets[1];
            var cells = sheet.cells;

            WriteCell(cells, "Hello World", 2, 2);
            book.SaveCopyAs(saveFileDialog.FileName);

            ComRelease(cells);
            ComRelease(sheet);
            ComRelease(sheets);
            book.Close();
            ComRelease(book);
            ComRelease(books);
            excel.DisplayAlerts = true;
            excel.Quit();
            ComRelease(excel);

            MessageBox.Show("終了しました。");
        }

        private void WriteCell(dynamic cells, string value, int r, int c)
        {
            var cell = cells[r, c];
            cell.value = value;
            ComRelease(cell);
        }

        private void ComRelease(dynamic target)
        {
            System.Runtime.InteropServices.Marshal.ReleaseComObject((object)target);
            target = null;
        }

    }
}

using System;

using System.Windows.Forms;

// 参照の追加>COM>Microsoft Excel 16.0 Object Library

namespace ProductionManagement

{

class Excel

{

public void CreateBook()

{

if (Type.GetTypeFromProgID("Excel.Application") == null) return;

SaveFileDialog saveFileDialog = new SaveFileDialog();

saveFileDialog.FileName = "title";

saveFileDialog.Filter = "xlsx | *.xlsx";

if (saveFileDialog.ShowDialog() != DialogResult.OK) return;

var excel = new Microsoft.Office.Interop.Excel.Application();

excel.DisplayAlerts = false;

var books = excel.Workbooks;

var book = books.Add();

var sheets = book.Sheets;

var sheet = sheets[1];

var cells = sheet.cells;

WriteCell(cells, "Hello World", 2, 2);

book.SaveCopyAs(saveFileDialog.FileName);

ComRelease(cells);

ComRelease(sheet);

ComRelease(sheets);

book.Close();

ComRelease(book);

ComRelease(books);

excel.DisplayAlerts = true;

excel.Quit();

ComRelease(excel);

MessageBox.Show("終了しました。");

}

private void WriteCell(dynamic cells, string value, int r, int c)

{

var cell = cells[r, c];

cell.value = value;

ComRelease(cell);

}

private void ComRelease(dynamic target)

{

System.Runtime.InteropServices.Marshal.ReleaseComObject((object)target);

target = null;

}