C#读写Excel表格（续）二

亦凉 2022-08-09 11:59 204阅读 0赞

**![大笑][laugh.gif]昨天手残，误删除系统 驱动文件，导致系统崩溃，之前保存在C盘上的数据全部丢失，之前做的关于EXCEL的代码也全部丢失。该死的驱动文件，一直在后台启动各种应用，拖得我系统资源紧张，一怒之下，直接干掉TA。哪知重启系统后，系统就崩溃了。![鄙视][despise.gif]**

**这里再次把关于C\#读写EXCEL的心得贴出来，方便自己今后复习。**

# \---------------------------准备工作 #

**1，我启动VS2010，新建一个窗体应用程序。界面如下：**

![Center][]

**2，我在工程目录下创建了一个名为：1.xlsx的Excel表格。**

![Center 1][]

#  #

# \---------------------------步骤 #

**1，打开Excel文件(已经存在)**

**2， 读写数据**

**3， 关闭Excel文件**

**4，释放系统资源**

#  #

# \---------------------------添加引用 #

这里请参考[ 我之前做的笔记][Link 1]

# \---------------------------添加名称空间 #

using EXCEL = Microsoft.Office.Interop.Excel;
    using System.Reflection;
    using Microsoft.Office.Interop.Excel;

# \--------------------------写数据按钮被单击事件代码 #

//---写数据按钮被单击事件
            private void writeDataBtn_Click(object sender, EventArgs e)
            {
                try
                {
                    EXCEL.ApplicationClass excel = new EXCEL.ApplicationClass();
                    string filepath = System.Windows.Forms.Application.StartupPath + @"\1.xlsx";
                    _Workbook book = excel.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, Missing.Value, Missing.Value);
    
                    _Worksheet sheet = null;
                    excel.Visible = false;
                    //----
                    excel.DisplayAlerts = false;
                    //---获取sheet
                    sheet = (_Worksheet)book.Worksheets.get_Item(1);
                    //----写数据
                    sheet.Cells[2, 2] = "墨临";
                    sheet.Cells[2, 4] = "男";
                    sheet.Cells[3, 3] = "0";
                    sheet.Cells[4, 2] = "180";
                    sheet.Cells[4, 4] = "10KG";
    
                    ///---保存
                    book.Save();
                    book.Close(false, Missing.Value, Missing.Value);
                    excel.Quit();
                    sheet = null;
                    book = null;
                    excel = null;
                    GC.Collect();   ///--系统回收资源
                    GC.WaitForPendingFinalizers();
                    MessageBox.Show("写数据成功");
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }

#  #

# \--------------------------读数据按钮被单击事件代码 #

//---读取数据
            private void readDataBtn_Click(object sender, EventArgs e)
            {
                try
                {
                    EXCEL.ApplicationClass excel = new EXCEL.ApplicationClass();
                    string filepath = System.Windows.Forms.Application.StartupPath + @"\1.xlsx";
                    _Workbook book = excel.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, Missing.Value, Missing.Value);
    
                    _Worksheet sheet = null;
                    excel.Visible = false;
                    //----
                    excel.DisplayAlerts = false;
                    //---获取sheet
                    sheet = (_Worksheet)book.Worksheets.get_Item(1);
                    //----读数据
                    Microsoft.Office.Interop.Excel.Range range = (Microsoft.Office.Interop.Excel.Range)sheet.Cells[2, 2];
                    textBox1.Text = (string)range.Text;
                    
    
                    ///---保存
                    book.Save();
                    book.Close(false, Missing.Value, Missing.Value);
                    excel.Quit();
                    sheet = null;
                    book = null;
                    excel = null;
                    GC.Collect();
                    GC.WaitForPendingFinalizers();
                    MessageBox.Show("读取据成功");
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }

这里是EXCEL 中的数据布局：

![Center 2][]

#  #

# \--------------------------注意 #

值得注意的是：

**对单元格操作的时候，单元格的行列索引是从1开始的，不是从0开始的。**

正在尝试对EXCEL的操作封装成类，方便今后使用。![大笑][laugh.gif]

[laugh.gif]: /images/20220731/97b935d396ff432e8f5bbb9cd5c253cc.png
[despise.gif]: /images/20220731/75fd4d38cd3043879a2050808812dbfe.png
[Center]: /images/20220731/06de7eb7bee94d3b89f6b158103367a3.png
[Center 1]: /images/20220731/53d766d37a2b42c38df9a2f37127aef7.png
[Link 1]: http://blog.csdn.net/hk_5788/article/details/49228073
[Center 2]: /images/20220731/0f547167db5a415891c42f14227cfcef.png