Question

C#怎么在一个已经存在的EXCEL里写入数据

Answer 1

1. 添加excel类库引用

2. //加载excel
               Application app = new Application();
               Workbooks wb = app.Workbooks;
               _Workbook _wb = wb.Add("excel路径");           

   //获取sheet
               Sheets sh = _wb.Sheets;

               _Worksheet _wsh = (_Worksheet)sh.get_Item(1);

   _wsh.Cells[3, 2] = person.Name;//3为excel行，2为excel列

   _wsh.SaveAs("填写完成后要保存的路径",
                   Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

   
               _wb.Close();
               wb.Close();

Answer 2

Excel 2016 怎么使用通配符查找数据

Answer 3

进入编辑栏中编辑

Answer 4

c# 读写数据实例提供