记录 excel 处理.

 1 using System;
 2 using System.Collections.Generic;
 3 using System.Text;
 4 using System.Reflection;
 5 using System.Threading;
 6 using Microsoft.Office.Interop.Excel;
 7 
 8 namespace excelApp {
 9     class Program {
         //private object missing = Missing.Value;
         static void Main(string[] args) {
             Type _excelAppType = null;
             object _excel = null;
             object _documents = null;
             object books = null;
             object book = null;
             try {
                 _excelAppType = Type.GetTypeFromProgID("Excel.Application",true); 
                 _excel = Activator.CreateInstance(_excelAppType, false);
                 //_documents = _excelAppType.InvokeMember("Workbooks",
                 //   BindingFlags.GetProperty, null, _excel, null);
 
                 books = _excelAppType.InvokeMember("Workbooks",
                     BindingFlags.GetProperty, null, _excel, null);
 
                 //book = books.GetType().InvokeMember("Add",BindingFlags.GetProperty, null, books, null);
 
                 //_documents = book.GetType().InvokeMember("Worksheets", BindingFlags.GetProperty, null, book, null);
             } catch (Exception er) {
                 string ss = er.Message;
             }
 
             object result = null;//_excelAppType
 
             object[] argsForOpen = new object[3];
             argsForOpen[0] = @"D:\temp\3012201701100072008052920080529.xls";
             argsForOpen[1] = true;
             argsForOpen[2] = true;
 
             //result = books.GetType().InvokeMember("Open",
             //    System.Reflection.BindingFlags.InvokeMethod, null, books, new Object[] { @"D:\temp\EA000120081010.xml", true, true });
             result = books.GetType().InvokeMember("Open",
                 System.Reflection.BindingFlags.InvokeMethod, null, books, argsForOpen);
 
 
             _documents = result.GetType().InvokeMember("Worksheets", BindingFlags.GetProperty, null, result, null);
 
             object objSheet;
             objSheet = _documents.GetType().InvokeMember("Item", BindingFlags.GetProperty, null, _documents, new object[1] { 1 });
 
             objSheet.GetType().InvokeMember("Protect", BindingFlags.InvokeMethod, null, objSheet, new object[1] { Guid.NewGuid().ToString() });
 
             //
             _excel.GetType().InvokeMember("DisplayAlerts", BindingFlags.SetProperty, null, _excel, new object[1] { false });
 
             //
             result.GetType().InvokeMember("SaveCopyAs", BindingFlags.InvokeMethod, null, result, new Object[1] { @"D:\temp\EA0001888.xls" });
 
             //
             _excel.GetType().InvokeMember("Quit", BindingFlags.InvokeMethod, null, _excel, null);
 
 
             //test();
             Console.WriteLine("ok");
             Console.Read();
 
         }
     }
 }