基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：813200300

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

C# 读取excel内容后，进行筛选重置

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Threading.Tasks;
using Excel = Microsoft.Office.Interop.Excel;

namespace WXYLcomponentdatabase
{
    internal class Readexcel
    {
        public DataTable WXYLdatabase_dt = new DataTable();
        public DataTable filteredTable = new DataTable();
        public void readexcel()
        {
       
            string currentpath = System.Environment.CurrentDirectory;
            Excel.Application app = new Excel.Application();         
            Excel.Workbook workbook = app.Workbooks.Open(@currentpath "\\WXYLdatabase.xlsx", Type.Missing, Type.Missing, Type.Missing, "zzyhezy");


            Excel.Worksheet worksheet1 = workbook.Sheets[1];
            Excel.Worksheet worksheet2 = workbook.Sheets[2];


            for (int i = 1; i <= worksheet1.UsedRange.Columns.Count; i )
            {
                WXYLdatabase_dt.Columns.Add(worksheet1.Cells[1, i].Value2.ToString());
            }
            for (int j = 2; j <= worksheet1.UsedRange.Rows.Count; j )
            {
                DataRow dr = WXYLdatabase_dt.NewRow();
                for (int i = 1; i <= worksheet1.UsedRange.Columns.Count; i )
                {
                    dr[i - 1] = worksheet1.Cells[j, i].Value2;
                    
                }
                
                WXYLdatabase_dt.Rows.Add(dr);
            }
            for (int j = 2; j <= worksheet2.UsedRange.Rows.Count; j )
            {
                DataRow dr = WXYLdatabase_dt.NewRow();
                for (int i = 1; i <= worksheet2.UsedRange.Columns.Count; i )
                {
                    dr[i - 1] = worksheet2.Cells[j, i].Value2;

                }
                WXYLdatabase_dt.Rows.Add(dr);
            }



            // 关闭 Excel 对象
            workbook.Close(false, Type.Missing, Type.Missing);

        }

    }
}