C# 操作EXCEL

【核心代码】

public class CCExcel
    {
        public Excel.Application appExcel;
        public Excel.Workbooks wbs;
        public Excel.Workbook wb;
        public Excel.Worksheets wss;
        public Excel.Worksheet ws;
        private string fileName;
        private string saveName;

        public CCExcel(string fileName,string saveName)
        {
            //
            //TODO: 在此处添加构造函数逻辑
            //
            this.fileName = fileName;
            this.saveName = saveName;
        }

        public void Exceldata()
        {
            Create();
            //Open(fileName);
            Data2Excel();
            Save(saveName);
            //Save(wb,saveName);
            //appExcel.ActiveWorkbook.SaveCopyAs(fileName);  //判断当前激活的表，并保存这个表。否则，保存时会弹出“是否保存Sheet1.xlsx”的对话框
            wb.Close(Type.Missing, Type.Missing, Type.Missing);
            wbs.Close();
            appExcel.Quit();
            wb = null;
            wbs = null;
            appExcel = null;

            GC.Collect();
        }

        private void Create()//创建一个Excel对象
        {
            appExcel = new Excel.Application();
            wbs = appExcel.Workbooks;
            wb = wbs.Add(true);
            //ws = (Excel.Worksheet)wb.ActiveSheet;//这是一个只读sheets集合
            //Excel.Worksheet worksheet = wb.ActiveSheet as Excel.Worksheet;//这也是一个只读sheets集合
            //Excel.Worksheet ws = (Worksheet)wb.Worksheets[1];//创建工作页sheet单页
            ws = wb.Worksheets[1] as Worksheet;  //第一个sheet页
            ws.Name = "ck";  //这里修改sheet名称
         }

        public void Open(string fileName)
        {
            appExcel = new Excel.Application();
            wbs = appExcel.Workbooks;
            wb = wbs.Add(fileName);
            wb = wbs.Open(fileName,Type.Missing,Type.Missing,Type.Missing,Type.Missing,
                Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,
                Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing);
        }

        private void Data2Excel()
        {
            ws.Cells[4, 1] = 11;
            ws.Cells[4, 2] = 22;
            ws.Cells[4, 3] = 33;
            ws.Cells[4, 4] = 44;
            ws.Cells[4, 5] = 55;
        }

        private void Save(string saveName)//文档另存
        //private bool Save(Microsoft.Office.Interop.Excel.Workbook wb,object saveName)
        {
            try
            {
                wb.SaveAs(saveName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                Excel.XlSaveAsAccessMode.xlExclusive,Type.Missing,Type.Missing,Type.Missing,
                Type.Missing,Type.Missing);
            }
            catch (Exception ex)
            {
                //return false;
                throw ex;
            }
            //return true;
        }
    }