使用C#在Excel文档中创建图表

using MSExcel = Microsoft.Office.Interop.Excel;

using System.IO;

using System.Reflection;

class Program

{

  static void Main(string[] args)

  {

    string path;

    MSExcel.Application excelApp;

    MSExcel.Workbook excelDoc;

    path = @"d:/test.xlsx";

    excelApp = new MSExcel.ApplicationClass();

    if(File.Exists(path))

    {

      File.Delete(path);

    }

    Object nothing = Missing.Value;

    excelDoc = excelApp.Workbooks.Add(nothing);

    MSExcel.Worksheet ws = (MSExcel.Worksheet)excelDoc.Sheet[1];

    MSExcel.Range r;

    r = ws.get_Range("A1","A1");

    r.Value2 = "3";

    r = ws.get_Range("A2","A2");

    r.Value2 = "5.7";

    r = ws.get_Range("A3","A3");

    r.Value2 = "4.8";

    r = ws.get_Range("A4","A4");

    r.Value2 = "9.2";

    r = ws.get_Range("A5","A5");

    r.Value2 = "6.4";

    excelDoc.Charts.Add(nothing,nothing,nothing,nothing);

    excelDoc.ActiveChart.ChartType = MSExcel.XlChartType.xlColumnClustered;

    excelDoc.ActiveChart.SetSourceData(ws.get_Range("A1","A5"),MSExcel.XlRowCol.xlColumns);

    excelDoc.ActiveChart.Location(MSExcel.XlChartLocation.xlLocationAsObject,"sheet1");

    excelDoc.ActiveChart.HasTitle = true;

    excelDoc.ActiveChart.ChartTitle.Text = "创建图表";

    excelDoc.ActiveChart.hasDataTable = false;

    object format = MSExcel.XlFileFormat.xlWorkbookDefault;

    excelDoc.SaveAs(path,format,nothing,nothing,nothing,nothing,

        MSExcel.XlSaveAsAccessMode.xlExclusive,nothing,nothing,nothing,nothing,nothing);

    excelDoc.Close(nothing,nothing,nothing);

    excelApp.Quit();

  }

}