向Excel中插入数据

最新推荐文章于 2018-01-16 17:35:48 发布

jrl5365

最新推荐文章于 2018-01-16 17:35:48 发布

阅读量533

点赞数

分类专栏： C# 文章标签： excel

本文链接：https://blog.csdn.net/jrl5365/article/details/1540338

版权

C# 专栏收录该内容

29 篇文章 0 订阅

订阅专栏

using Excel=Microsoft.Office.Interop.Excel;
using ExcelC=Microsoft.Office.Core;

     Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
            app.Workbooks.Open(@"D:/CExcel/bin/Debug/Simple.xls",
                     0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "",
                     true, false, 0, true, false, false);
            //Excel.Workbook wbook = app.Workbooks[0];
            Excel.Worksheet wsheet = (Excel.Worksheet)app.Workbooks.get_Item(1).Sheets.get_Item(1);
            Excel.Range ran = (Excel.Range)wsheet.Cells[1, 1];
            MessageBox.Show(app.Workbooks[1].FullName + ":" + ran.Text);

app.Workbooks.Close();
app.Quit();