C# excel操作方法

1 打开指定excel 

Microsoft.Office.Interop.Excel.Application myExcel = new Microsoft.Office.Interop.Excel.Application();//引用Excel对象 
Microsoft.Office.Interop.Excel.Workbook book = myExcel.Application.Workbooks.Add(@textBox1.Text);
myExcel.Visible = false; //使Excel可视
 Microsoft.Office.Interop.Excel.Worksheet workSheet = (Microsoft.Office.Interop.Excel.Worksheet)myExcel.Worksheets[1];//打开指定Worksheets

 2 新建excel

Microsoft.Office.Interop.Excel.Application myExcel = new Microsoft.Office.Interop.Excel.Application();
myExcel.Application.Workbooks.Add(true);
myExcel.Visible = true;//让Excel文件可见

3 获取列数据

 int iRowCount = workSheet.UsedRange.Rows.Count;//获取数据总行数
int iColCount = workSheet.UsedRange.Columns.Count;//获取数据总列数
string[] sValue1 = new string[iRowCount];// 预编号
string[] sValue2 = new string[iRowCount];// 宗地代码

            for (int i = 4; i < iRowCount; i++)
            {
               sValue1[i] = ((Range)workSheet.Cells[i, 2]).Text;//获取列值
               sValue1[i] = ((Microsoft.Office.Interop.Excel.Range)workSheet.Cells[i, 19]).Text;//预编号
                sValue2[i] = ((Microsoft.Office.Interop.Excel.Range)workSheet.Cells[i, 20]).Text;//宗地代码
               ((Range)workSheet.Cells[i , 3]).Value2 = sValue1[i] //写入列值
            }