C# Excel

        C#的Office操作十分简单,只要添加如Office操作的DLL文件即可，如果是一些复杂的操作，那么就可以使用一些第三方插件，例如CarlosAg，Aspose，OfficeOCX等等，这些我都使用过，完成一些基本的功能，但是我使用的最多的还是Microsoft的VBA，例如：
      

            Object refmissing = System.Reflection.Missing.Value;

            object[] args = new object[4];

            args[0] = SHDocVw.OLECMDID.OLECMDID_HIDETOOLBARS;

            args[1] = SHDocVw.OLECMDEXECOPT.OLECMDEXECOPT_DONTPROMPTUSER;

            args[2] = refmissing;

            args[3] = refmissing;

   

            Excel.Workbook wbb = (Excel.Workbook)oApplication;

            Excel.ApplicationClass excel = wbb.Application as Excel.ApplicationClass ;

            Excel.Workbook wb = excel.Workbooks[1] ;

            Excel.Worksheet ws = wb.Worksheets[1] as Excel.Worksheet;

            ws.Cells.Font.Name = "Verdana";

            ws.Cells.Font.Size = 14;

            ws.Cells.Font.Bold = true;

            Excel.Range range = ws.Cells;

 

            Excel.Range oCell = range[10, 10] as Excel.Range ;

            oCell.Value2 = "你好";