private void btnnewChart_Click(object sender, EventArgs e)
{
ExcelBinder excelbinder = new ExcelBinder();
excelbinder.NewDocument();
excelbinder.Visible = true;
excelbinder.SetActiveWorkSheet(1);
excelbinder.SetValue(1, 2, "Student1");
excelbinder.SetValue(1, 3, "Student2");
excelbinder.SetValue(1, 4, "Student3");
excelbinder.SetValue(2, 1, "Term1");
excelbinder.SetValue(2, 2, "80");
excelbinder.SetValue(2, 3, "65");
excelbinder.SetValue(2, 4, "45");
excelbinder.SetValue(3, 1, "Term2");
excelbinder.SetValue(3, 2, "78");
excelbinder.SetValue(3, 3, "72");
excelbinder.SetValue(3, 4, "60");
excelbinder.SetValue(4, 1, "Term3");
excelbinder.SetValue(4, 2, "82");
excelbinder.SetValue(4, 3, "80");
excelbinder.SetValue(4, 4, "65");
excelbinder.SetValue(5, 1, "Term4");
excelbinder.SetValue(5, 2, "75");
excelbinder.SetValue(5, 3, "82");
excelbinder.SetValue(5, 4, "68");
ExcelBinder.ExlChartType ctype = GetChartType(cbChartType.SelectedIndex);
excelbinder.CreateChart(1, 1, 5, 4, 100, 100, 400, 400, ctype);
excelbinder.SaveDocument(Path.Combine(Environment.CurrentDirectory, "testchart" + (int)ctype + ".xlsx"));
excelbinder.CloseDocument();
excelbinder.QuitDocument();
}
/*
* Bubble
* Cluster
* Pie
* ScatterLine
* 3D Surface
* 3D Cone Column
* 3D Pyramid Column
*/
ExcelBinder.ExlChartType GetChartType(int idx)
{
ExcelBinder.ExlChartType t = ExcelBinder.ExlChartType.xlBubble;
switch (idx)
{
case 0: return(ExcelBinder.ExlChartType.xlBubble);
case 1: return(ExcelBinder.ExlChartType.xlBarClustered);
case 2: return(ExcelBinder.ExlChartType.xlPie);
case 3: return(ExcelBinder.ExlChartType.xlXYScatterLines);
case 4: return(ExcelBinder.ExlChartType.xlSurface);
case 5: return(ExcelBinder.ExlChartType.xlConeCol);
case 6: return(ExcelBinder.ExlChartType.xlPyramidCol);
default: return(ExcelBinder.ExlChartType.xlBubble);
}
return(t);
}
