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