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