C# 读写Excel

using System.Reflection;
using Excel=Microsoft.Office.Interop; 

 

 

protected void Button1_Click(object sender, EventArgs e)
    {
        string rootPath = Server.MapPath("//");
        string lastPath = "ExportExcel//CData.xls";
        string templatePath = "JiaBanDaoXiu.xlt";
        Excel.Excel.XlFileFormat version = Excel.Excel.XlFileFormat.xlExcel8;//Excel 2003版本
        //if (System.IO.Path.GetExtension(fileName).ToLower() == ".xlsx") version = Excel.Excel.XlFileFormat.xlOpenXMLWorkbook;//Excel 2007版本
        try
        {
            //创建Application对象
            Excel.Excel.Application xApp = new Excel.Excel.Application();

            xApp.Visible = true;
            //得到WorkBook对象, 可以用两种方式之一: 下面的是打开已有的文件
            if (File.Exists(rootPath + templatePath))
            {
                Label1.Text = "找到模板";
            }
            else
            {
                Label1.Text = "找不到模板文件！";
            }

            Excel.Excel.Workbook xBook = xApp.Workbooks._Open(rootPath + templatePath,
                Missing.Value, Missing.Value, Missing.Value, Missing.Value,
                Missing.Value, Missing.Value, Missing.Value, Missing.Value,
                Missing.Value, Missing.Value, Missing.Value, Missing.Value);

            //指定要操作的Sheet，两种方式：
            Excel.Excel.Worksheet xSheet = (Excel.Excel.Worksheet)xBook.Sheets[1];
            //写入数据

            Excel.Excel.Range rng3 = xSheet.get_Range("C6", Missing.Value);
            rng3.Value2 = "Test";
            rng3.Interior.ColorIndex = 6; //设置Range的背景色

            // 保存方式二：保存WorkSheet
            if (File.Exists(rootPath + lastPath))
                File.Delete(rootPath + lastPath);
            xSheet.SaveAs(rootPath + lastPath,
            version , Missing.Value, Missing.Value, Missing.Value,
            Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
            //string fileName =FilePath+"CData2.xls";
            //Excel.XlFileFormat version = Excel.XlFileFormat.xlExcel8;//Excel 2003版本
            //if (System.IO.Path.GetExtension(fileName).ToLower() == ".xlsx") version = Excel.XlFileFormat.xlOpenXMLWorkbook;//Excel 2007版本
            //xSheet.SaveAs(fileName, version, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
            rng3 = null;
            xSheet = null;
            xBook = null;
           
            xApp.Workbooks.Close();
            xApp.Quit(); //这一句是非常重要的，否则Excel对象不能从内存中退出
            xApp = null;
           
            //this.Load += new System.EventHandler(this.Page_Load);
        }
        catch (System.Exception ex)
        {
            Label1.Text = "ERROR";
            Response.Write(ex.Message + "ERROR1");
        }
               
        
    }
  ===========================================================================================

将Excel操作总结如下：

//创建Application对象

        Excel.Excel.XlFileFormat version = Excel.Excel.XlFileFormat.xlExcel8;//Excel 2003版本
        //if (System.IO.Path.GetExtension(fileName).ToLower() == ".xlsx") version = Excel.Excel.XlFileFormat.xlOpenXMLWorkbook;//Excel 2007版本

        Excel.Excel.Application xApp = new Excel.Excel.Application();
        xApp.Visible = true;

        //得到WorkBook对象, 可以用两种方式之一: 下面的是打开已有的文件

        Excel.Excel.Workbook xBook = xApp.Workbooks._Open("D://JiaBanDaoXiu.xlt",
            Missing.Value, Missing.Value, Missing.Value, Missing.Value,
            Missing.Value, Missing.Value, Missing.Value, Missing.Value,
            Missing.Value, Missing.Value, Missing.Value, Missing.Value);
        //xBook=xApp.Workbooks.Add(Missing.Value);//新建文件的代码

        //指定要操作的Sheet，两种方式：
        Excel.Excel.Worksheet xSheet = (Excel.Excel.Worksheet)xBook.Sheets[1];
        //Excel.Excel.Worksheet xSheet=(Excel.Worksheet)xApp.ActiveSheet;

        读取数据，通过Range对象
        //Excel.Range rng1 = xSheet.get_Range("A1", Type.Missing);
        //Console.WriteLine(rng1.Value2);

        读取，通过Range对象，但使用不同的接口得到Range
        //Excel.Range rng2 = (Excel.Range)xSheet.Cells[3, 1];
        //Console.WriteLine(rng2.Value2);

        //写入数据
        Excel.Excel.Range rng3 = xSheet.get_Range("C6", Missing.Value);
        rng3.Value2 = Label1.Text;
        rng3.Interior.ColorIndex = 6; //设置Range的背景色

        //保存方式一：保存WorkBook
        if (File.Exists("D://CData.xls"))
            File.Delete("D://CData.xls");
        xBook.SaveAs(@"D:/CData.xls",Missing.Value , Missing.Value, Missing.Value, Missing.Value, Missing.Value,
        Excel.Excel.XlSaveAsAccessMode.xlShared, Missing.Value, Missing.Value, Missing.Value,
        Missing.Value, Missing.Value);

        保存方式二：保存WorkSheet
        //xSheet.SaveAs(@"D:/CData12.xls",
        //Missing.Value, Missing.Value, Missing.Value, Missing.Value,
        //Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);

        保存方式三
        xBook.Save();
        xSheet = null;
        xBook = null;
        xApp.Quit(); //这一句是非常重要的，否则Excel对象不能从内存中退出
        xApp = null;