C#操作excel文件

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Excel = Microsoft.Office.Interop.Excel;
using System.IO;
using System.Data;

namespace ConsoleApplication1
{
    class Program
    {
        
        static void Main(string[] args)
        {

            Excel.Application app = null;
            Excel.Workbooks wbs; 
            Excel.Workbook wb; 
            Excel.Worksheet worksheet; 

            try
            {
                app = new Excel.Application();
				//获取exe程序启动路径
                string path = AppDomain.CurrentDomain.BaseDirectory;
                string excelName = path + "file.xls";
                string saveFile = path + "TicketModule";

                wbs = app.Workbooks; 
				//加载excel文档
                wb = wbs.Add(excelName);

                //设置禁止弹出保存和覆盖的询问提示框                
                app.DisplayAlerts = false;                
                app.AlertBeforeOverwriting = false;
                app.UserControl = true;          
				//获取第一个sheet
                worksheet = (Excel.Worksheet)wb.Worksheets[1];
				//修改第一行第一列的数据为"hello"
                worksheet.Cells[ 1, 1] = "hello";
		
                //wb.Save();
                //另存为
                object MissingValue = Type.Missing;
                wb.SaveAs(saveFile, MissingValue, MissingValue, MissingValue, MissingValue, MissingValue,
                Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, MissingValue, MissingValue, MissingValue, MissingValue, MissingValue);
                app.Quit();
            }
            catch (System.Exception ex)
            {
                if (app != null)
                {
                    app.Quit();
                }
            }
           
        }
    }
}