学习（一）C#利用窗体打开Excel文件进行正常访问和写入

来源：互联网发布：淘宝卖家好评不返现编辑：程序博客网时间：2024/05/19 17:58

首先，在对Excel文件进行操作时，首先应该注意引用（word为一起加的，这里为非必要）

using MSWord = Microsoft.Office.Interop.Word;using MSExcel = Microsoft.Office.Interop.Excel;

（1）、能打开指定的Excel文件

  private void button1_Click(object sender, EventArgs e)        {            Form2 myform = new Form2();            myform.ShowDialog();            MessageBox.Show("hello world");            OpenExcel(@"D:\工作簿2.xls");        }

（2）、定义一个方法打开文件（主要是初始化）

static void OpenExcel(string filename)//定义方法OpenExcel        {            MSExcel.Application excelApp = null;            excelApp = new MSExcel.Application();            excelApp.Visible = true;            excelApp.DisplayAlerts = false;//保存Excel的时候，不弹出是否保存的窗口直接进行保存            excelApp.AlertBeforeOverwriting = false;            MSExcel.Workbook excelbook = null;            MSExcel.Worksheet excelsheet = null;            excelbook = excelApp.Workbooks.Open(filename, Type.Missing,                false, Type.Missing, Type.Missing, Type.Missing, Type.Missing,                Type.Missing, Type.Missing, Type.Missing, Type.Missing,                Type.Missing, Type.Missing, Type.Missing, Type.Missing);            //表1            excelsheet = excelbook.Sheets["hello1"] as MSExcel.Worksheet;            string str1 = excelsheet.Cells[1, 1].Text.ToString();            string str2 = excelsheet.Cells[1, 2].Text.ToString();            MSExcel.Range rang1 = excelsheet.get_Range("E3:F5");            string str3 = rang1.Cells[1, 1].Text.ToString();            string str4 = rang1.Cells[1, 2].Text.ToString();            excelsheet.Cells[5, 1] = "yoyou";            excelsheet.Cells[8, 4] = "yoyo12u";            excelbook.Save();            excelbook.Close();            excelApp.Quit();//逐级关闭，不可省略        }

其中：

 MSExcel.Application excelApp = null;            excelApp = new MSExcel.Application();//打开Excel程序，使之运行            excelApp.Visible = true;            excelApp.DisplayAlerts = false;//保存Excel的时候，不弹出是否保存的窗口直接进行保存            excelApp.AlertBeforeOverwriting = false;

为初始化操作。

尤其注意最后逐级关闭打开的系统，即为最后三行。

完整如下：

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 MSWord = Microsoft.Office.Interop.Word;using MSExcel = Microsoft.Office.Interop.Excel;namespace MyTest1{    public partial class Form1 : Form    {        public Form1()        {            InitializeComponent();        }        static void OpenExcel(string filename)        {            MSExcel.Application excelApp = null;            excelApp = new MSExcel.Application();            excelApp.Visible = true;            excelApp.DisplayAlerts = false;//保存Excel的时候，不弹出是否保存的窗口直接进行保存            excelApp.AlertBeforeOverwriting = false;            MSExcel.Workbook excelbook = null;            MSExcel.Worksheet excelsheet = null;            excelbook = excelApp.Workbooks.Open(filename, Type.Missing,                false, Type.Missing, Type.Missing, Type.Missing, Type.Missing,                Type.Missing, Type.Missing, Type.Missing, Type.Missing,                Type.Missing, Type.Missing, Type.Missing, Type.Missing);            //表1            excelsheet = excelbook.Sheets["hello1"] as MSExcel.Worksheet;            string str1 = excelsheet.Cells[1, 1].Text.ToString();            string str2 = excelsheet.Cells[1, 2].Text.ToString();            MSExcel.Range rang1 = excelsheet.get_Range("E3:F5");            string str3 = rang1.Cells[1, 1].Text.ToString();            string str4 = rang1.Cells[1, 2].Text.ToString();            excelsheet.Cells[5, 1] = "yoyou";            excelsheet.Cells[8, 4] = "yoyo12u";            excelbook.Save();            excelbook.Close();            excelApp.Quit();        }        private void button1_Click(object sender, EventArgs e)        {            Form2 myform = new Form2();            myform.ShowDialog();            MessageBox.Show("hello world");            OpenExcel(@"D:\工作簿2.xls");        }    }}

阅读全文

0 0