AutoExcel

using System;using Microsoft.Office.Interop.Excel;using System.Runtime.InteropServices;using System.Reflection;using System.Diagnostics;using System.Drawing;namespace AutoExcel{    //Application:代表Excel应用程序本身，Application公开了大量有关正在    //运行的应用程序，应用于该实例的选项及在该实例中打开的当前对象的信息。    //WorkBook:表示Excel应用程序的单个工作簿，通过提供该类（该类能访问WordBooks    //中的所有对象成员)，以及数据绑定功能和附加事件来扩展该类。    //WorkSheet:该对象是WorkSheets集合成员，它的许多属性，方法和事件都与Application/WorkBook    //相似。另外Sheets是WorkBook对象属性。    //Range:Excel中的单元格对应的对象。    //chartObjects:取得一个对象，该对象表示工作表上的单个嵌入式图表（chartObject)或者嵌入式图表集合(chartObjects)。    //chart:该控件是公开事件的图表对象，可以绑定到数据上。    class AutoExcelTest    {        public static void Main()        {            CloseExcel();            //创建Application对象            Console.WriteLine("Creating new Excel.Application");            Application app = new Application();            if (app == null)            {                Console.WriteLine("ERROR: EXCEL couldn't be started!");                CloseExcel();                return;            }            Console.WriteLine("Making Application visible");app.visible = true;            //创建WorkBook对象集合            Console.WriteLine("Get Workbokks collection");            Workbooks workBooks = app.Workbooks;            //创建一个新的WorkBook对象            Console.WriteLine("Add a new Workbook");            Workbook workBook = workBooks.Add(XlWBATemplate.xlWBATWorksheet);            Console.WriteLine("Get Worksheet collection");            //创建WorkSheet对象集合            Sheets sheets = workBook.Worksheets;            if (sheets == null)            {                Console.WriteLine("Worksheet creating Error!");                CloseExcel();                return;            }            _Worksheet workSheet = (_Worksheet)sheets.get_Item(1);            if (workSheet == null)            {                Console.WriteLine("Error:WorkSheet is null!");                CloseExcel();                return;            }            Console.WriteLine("Setting the value for cell");            //获取单元格G1            Range range1 = workSheet.get_Range("G1", Missing.Value);            if (range1 == null)            {                Console.WriteLine("Error:Range is null");                CloseExcel();                return;            }            const int nCells = 5;            range1.Value2 = nCells;            //获取A1到E1的Range对象（5个单元格）            Range range2 = workSheet.get_Range("A1", "E1");            int[] arr2 = new int[5];            for (int i = 0; i < arr2.GetLength(0); i++)            {                int x = i;                arr2[i] = x + 1;            }            range2.Value2 = arr2;            //获取A3到E4的Range对象（10）            Range range3 = workSheet.get_Range("A3", "E4");            int[,] arr3 = new int[2, 5];            for (int i = 0; i < arr3.GetLength(0); i++)            {                for (int j = 0; j < arr3.GetLength(1); j++)                {                    arr3[i, j] = i * 10 + j;                }            }            range3.Value2 = arr3;            //比较A3到E4的值            Range range4 = workSheet.get_Range("A3", "E4");            Object[,] arr4 = (Object[,])range4.Value2;            for (int i = arr4.GetLength(0); i <= arr4.GetLength(0); i++)            {                for (int j = arr4.GetLength(1); j <= arr4.GetLength(1); j++)                {                    bool isComparision = (double)arr4[i, j] != arr3[i - 1, j - 1];                    if (isComparision)                    {                        Console.WriteLine("Comparision Faild");                        CloseExcel();                        return;                    }                }            }            //获取A5到J6的Range对象（20）            Range range5 = workSheet.get_Range("A6", "J7");            double[,] arr5 = new double[2, 10];            for (int j = 0; j < arr5.GetLength(1); j++)            {                double arg = Math.PI / arr5.GetLength(1) * j;                arr5[0, j] = Math.Sin(arg);                arr5[1, j] = Math.Cos(arg);            }            range5.Value2 = arr5;            range5.Select();            //获取嵌入式图表对象            ChartObjects chartObjs = (ChartObjects)workSheet.ChartObjects(Missing.Value);            ChartObject chartObj = (ChartObject)chartObjs.Add(20/*Left*/, 100/*Top*/, 450/*Width*/, 260/*Height*/);            _Chart chart = (_Chart)chartObj.Chart;            Object[] arr6 = new object[11];            arr6[0] = range5;//Source:表示图表元数据范围            arr6[1] = XlChartType.xl3DColumn; //Gallery:图表类型            arr6[2] = Missing.Value;//Format:内置自动套用格式的选项编号            arr6[3] = XlRowCol.xlRows;//PlotBy:指定每个系列的绘制是按行还是按列            arr6[4] = 0;//GategotyLables:一个整数，指定源范围包含类别标签的行数或列数            arr6[5] = 0;//SeriesLables:一个整数，指定源范围中包含系列标签的行数或列数            arr6[6] = true;//HasLegend:包含图例            arr6[7] = "ExcelTest";//Title:Chart控件标题文本            arr6[8] = "ExcelTest Category Titel";//CategoryTitle:分类轴标题文本            arr6[9] = "ExcelTest Value Tile";//ValueTitle:数值轴标题文本            arr6[10] = Missing.Value;//ExtraTitle:三维图表的系列轴标题或二维图表的第二个数值轴标题            chart.GetType().InvokeMember("ChartWizard", BindingFlags.InvokeMethod, null, chart, arr6);        }        /// <summary>        /// 关闭Excel进程        /// </summary>        private static void CloseExcel()        {            Process[] process = Process.GetProcessesByName("EXCEL");            foreach (Process p in process)            {                p.CloseMainWindow();            }        }    }}