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 btnFillColor_Click(object sender, EventArgs e) { ExcelBinder excelbinder = new ExcelBinder(); excelbinder.NewDocument(); excelbinder.Visible = true; excelbinder.SetColor("A1:B2", (int)enumRgbColor.rgbRed); excelbinder.SetColor("A2", (int)enumRgbColor.rgbBlue); excelbinder.SetColor("A3", (int)enumRgbColor.rgbGreen); excelbinder.SaveDocument(Path.Combine(Environment.CurrentDirectory, "testcolor.xlsx")); excelbinder.CloseDocument(); excelbinder.QuitDocument(); }
private void btnInsertImage_Click(object sender, EventArgs e) { ExcelBinder excelbinder = new ExcelBinder(); excelbinder.NewDocument(); excelbinder.Visible = true; excelbinder.InsertImage(Path.Combine(Environment.CurrentDirectory, "tent1.jpg"), 1, 1, 200, 200); excelbinder.InsertImage(Path.Combine(Environment.CurrentDirectory, "tent1.jpg"), 200, 200); excelbinder.SaveDocument(Path.Combine(Environment.CurrentDirectory, "testinsertimage.xlsx")); excelbinder.CloseDocument(); excelbinder.QuitDocument(); }
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(); }
private void btnnewSheet_Click(object sender, EventArgs e) { ExcelBinder excelbinder = new ExcelBinder(); excelbinder.NewDocument(); excelbinder.Visible = true; excelbinder.AddNewSheet("Test1"); excelbinder.SetValue("A1", "test1"); excelbinder.AddNewSheet("Test2"); excelbinder.SetValue("A1", "test2"); excelbinder.SaveDocument(Path.Combine(Environment.CurrentDirectory, "testnewsheet.xlsx")); excelbinder.CloseDocument(); excelbinder.QuitDocument(); }
private void btnHelloWorld_Click(object sender, EventArgs e) { try { ExcelBinder excelbinder = new ExcelBinder(); excelbinder.NewDocument(); excelbinder.Visible = true; excelbinder.SetValue("A1", "Hello world"); excelbinder.SaveDocument(Path.Combine(Environment.CurrentDirectory, "testhelloworld.xlsx")); excelbinder.CloseDocument(); excelbinder.QuitDocument(); } catch (Exception excel) { MessageBox.Show(excel.Message.ToString()); } }
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(); }