• 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)";


                Excel.Range rng2 = xsheet.get_Range("A4", Missing.Value);
                rng2.Value2 = "10";

                Excel.Range rng3 = xsheet.get_Range("B4", Missing.Value);
                rng3.Value2 = "20";

                Excel.Range rng4 = xsheet.get_Range("C4", Missing.Value);
                rng4.Value2 = "30";

                Excel.Range rng5 = xsheet.get_Range("D4", Missing.Value);
                rng5.Value2 = "40";

                Excel.Range rng6 = xsheet.get_Range("E4", Missing.Value);
                rng6.Value2 = "50";

                Excel.Range rng7 = xsheet.get_Range("F4", Missing.Value);
                rng7.Value2 = "60";

                Excel.Range rng8 = xsheet.get_Range("G4", Missing.Value);
                rng8.Value2 = "70";

                Excel.Range rng9 = xsheet.get_Range("H4", Missing.Value);
                rng9.Value2 = "80";

                Excel.Range rng10 = xsheet.get_Range("I4", Missing.Value);
                rng10.Value2 = "90";

                Excel.Range rng11 = xsheet.get_Range("A5", Missing.Value);
                rng11.Value2 = DateTime.Now.ToLocalTime().ToString("yyyy-MM--dd HH:mm");

                xbook.SaveAs(@"C:\test.xlsx", Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
                    Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);

                MessageBox.Show("Write Success");
            }
        }
    }

    作者:Allen Chen无影
    邮箱:allen0717@163.com
    本文版权归作者和博客园共有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利.
  • 相关阅读:
    MySQL Explain学习笔记
    postman测试文件上传接口教程
    URLDecoder异常Illegal hex characters in escape (%)
    第三章 jQuery总结 参考文本
    史上最简单的一道面试题!坑人吧
    cookie和session的关联关系
    服务器配置
    Rancher 添加主机无法显示、添加主机无效的解决办法
    .NET Core 跨平台 串口通讯 ,Windows/Linux 串口通讯,flyfire.CustomSerialPort 的使用
    .Net Core 跨平台应用使用串口、串口通信 ,可能出现的问题、更简洁的实现方法
  • 原文地址:https://www.cnblogs.com/allen0118/p/1936876.html
  • Copyright © 2020-2023  润新知