C#删除Excel整行，更新单元格内容

最新推荐文章于 2024-09-18 10:08:52 发布

原创最新推荐文章于 2024-09-18 10:08:52 发布 · 1.4k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#excel #poi #vba #sqlite #cookie

这段代码展示了如何使用C#和Microsoft.Office.Interop.Excel库来删除Excel文件中的工作表。程序打开指定路径的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 System.Reflection;
using Excel = Microsoft.Office.Interop.Excel;

namespace DelExcel
{
    public partial class Form1 : Form
    {
        private Excel._Application excelApp = null;
        private Excel.Workbook book = null;
        private Excel.Worksheet sheet = null;
        private Excel.Range range = null;
        string filePath = @"E:\2010.xls";

        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            delExcel(filePath);
        }

        private void delExcel(string filePath)
        {
            excelApp = new Microsoft.Office.Interop.Excel.Application();
            excelApp.Visible = false;

            book = excelApp.Workbooks.Open(filePath, Missing.Value, false, Missing.Value, Missing.Value, Missing.Value, true, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
            int wsCount = book.Worksheets.Count;
            for (int i = 1; i <= wsCount; i++)
            {
                sheet = (Excel.Worksheet)book.Worksheets[i];
                //获取编辑范围
                range = (Excel.Range)sheet.Rows[1, Missing.Value];
                //删除整行
                range.Delete(Excel.XlDirection.xlDown);
                
                //更新单元格内容
                sheet.Cells[1, 3] = "pcID";

                //保存编辑
                book.Save();
            }
            //关闭book
            book.Close(Missing.Value, Missing.Value, Missing.Value);
            //退出excel application，可以将前面的excelApp.Visible = false改为excelApp.Visible = true看看;
            excelApp.Workbooks.Close();
            excelApp.Quit();        
        }
    }
}