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();
}
}