C# 将数据写入到Excel

C# 将数据写入到Excel

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using Excel = Microsoft.Office.Interop.Excel;
using System.Reflection;
namespace WinformWriteToExcel
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        private void btnWriteToExcel_Click(object sender, EventArgs e)
        {
            Excel.Application xapp = new Excel.Application();  
            string filepath = @"D:\template.xlsx";
            Excel.Workbook xbook = xapp.Workbooks._Open(filepath, Missing.Value, Missing.Value,
                                    Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
                                    Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
            Excel.Worksheet xsheet = (Excel.Worksheet)xbook.Sheets[1];
            Excel.Range rng = xsheet.get_Range("F1", Missing.Value);
            rng.Value2 = "allen(test)";