private void btnAddTotalShapes_Click(object sender, EventArgs e) { ExcelBinder excelbinder = new ExcelBinder(); excelbinder.NewDocument(); excelbinder.Visible = true; excelbinder.SetActiveWorkSheet(1); int Left = 10; int Top = 10; excelbinder.InsertShapes(Shapes.ShapeDefine.MsoShapeType.msoShapeLineCallout1, Left, Top, 100, 20); excelbinder.InsertShapes(Shapes.ShapeDefine.MsoShapeType.msoShapeRectangle, Left + 120, Top, 100, 20); excelbinder.InsertShapes(Shapes.ShapeDefine.MsoShapeType.msoShapeRightArrow, Left + 220, Top, 100, 20); excelbinder.InsertShapes(Shapes.ShapeDefine.MsoShapeType.msoShapeLeftArrow, Left + 320, Top, 100, 20); excelbinder.InsertShapes(Shapes.ShapeDefine.MsoShapeType.msoShapeLeftRightArrow, Left + 420, Top, 100, 20); excelbinder.InsertShapes(Shapes.ShapeDefine.MsoShapeType.msoShapeUpArrow, Left + 520, Top, 100, 20); excelbinder.InsertShapes(Shapes.ShapeDefine.MsoShapeType.msoShapeRightTriangle, Left, Top + 150, 150, 150); excelbinder.InsertShapes(Shapes.ShapeDefine.MsoShapeType.msoShapeOctagon, Left + 200, Top + 150, 150, 150); excelbinder.InsertShapes(Shapes.ShapeDefine.MsoShapeType.msoShapeOval, Left + 400, Top + 150, 150, 150); excelbinder.SaveDocument(Path.Combine(Environment.CurrentDirectory, "testshapes.xlsx")); excelbinder.CloseDocument(); excelbinder.QuitDocument(); }
private void btnCopySheet_Click(object sender, EventArgs e) { ExcelBinder excelbinder = new ExcelBinder(); excelbinder.NewDocument(); excelbinder.Visible = true; excelbinder.RenameSheet(3, "RenameTest1"); excelbinder.SetActiveWorkSheet(3); excelbinder.SetValue("A1", "Renamed Test Sheet"); excelbinder.sheetCopy("RenameTest1", "CopyedTest2"); excelbinder.SetActiveWorkSheet("CopyedTest2"); excelbinder.SetValue("A1", "Copyed Test Sheet"); excelbinder.SaveAsDocument(Path.Combine(Environment.CurrentDirectory, "testcopyheet.xls")); excelbinder.CloseDocument(); excelbinder.QuitDocument(); }
private void btnChangeColorShapes_Click(object sender, EventArgs e) { string filename = Path.Combine(Environment.CurrentDirectory, "testshapes.xlsx"); if (File.Exists(filename)) { ExcelBinder excelbinder = new ExcelBinder(); excelbinder.OpenDocument(filename); excelbinder.Visible = true; excelbinder.SetActiveWorkSheet(1); //excelbinder.ChangeColorObjects(Color.Red); } }
private void btnAddShape_Click(object sender, EventArgs e) { ExcelBinder excelbinder = new ExcelBinder(); excelbinder.NewDocument(); excelbinder.Visible = true; excelbinder.SetActiveWorkSheet(1); Shapes.ShapeDefine.MsoShapeType stype = GetShapeType(cbShapeType.SelectedIndex); excelbinder.InsertShapes(stype, 100, 100, 150, 20); excelbinder.SaveDocument(Path.Combine(Environment.CurrentDirectory, "testshapes" + (int)stype + ".xlsx")); excelbinder.CloseDocument(); excelbinder.QuitDocument(); }
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(); }