Application操纵Excel

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

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            //建立Excel Application
            Excel.Application myExcel = new Microsoft.Office.Interop.Excel.Application();
            myExcel.Application.Workbooks.Add(true);

            //建立Workbook,Worksheet
            Excel.Workbook mybook = myExcel.Workbooks[1];
            Excel.Worksheet mysheet = (Excel.Worksheet)mybook.ActiveSheet;
            myExcel.Visible = true;

            //选取并合并单元格
            mysheet.get_Range(mysheet.Cells[1, 1], mysheet.Cells[9, 9]).HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
            Excel.Range myrange = mysheet.get_Range(mysheet.Cells[1, 1], mysheet.Cells[9, 9]);
            myrange.Merge(null);

            //填充数据
            myrange.set_Value(Excel.XlRangeValueDataType.xlRangeValueDefault, 12345.6789);
            mysheet.Cells[10, 1] = "Cloud";
            mysheet.get_Range(mysheet.Cells[10, 1], mysheet.Cells[10, 1]).Select();
            mysheet.get_Range(mysheet.Cells[10, 1], mysheet.Cells[10, 1]).Font.Bold = true;
            mysheet.get_Range(mysheet.Cells[10, 1], mysheet.Cells[10, 1]).Font.Size = 10;
            mysheet.get_Range(mysheet.Cells[10, 1], mysheet.Cells[10, 1]).HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;

            //页面设置
            mysheet.PageSetup.Orientation = Excel.XlPageOrientation.xlPortrait;     //纸张方向:纵向
            mysheet.PageSetup.PaperSize = Excel.XlPaperSize.xlPaperA4;              //纸张类型:A4
            String str = "这个是页眉";
            mysheet.PageSetup.CenterHeader = str;                                   //页眉
            mysheet.PageSetup.CenterHorizontally = true;                            //水平对齐
            mysheet.PageSetup.LeftFooter = "第&P页,共&N页";                         //页脚
            //纸张边距
            mysheet.PageSetup.LeftMargin = 1.9 / 0.035;
            mysheet.PageSetup.RightMargin = 1.9 / 0.035;
            mysheet.PageSetup.TopMargin = 1.2 / 0.035;
            mysheet.PageSetup.BottomMargin = 2.3 / 0.035;
        }
    }
}