C# (CSharp) ExcelBinder.AddNewSheet Examples

Example #1

File: Form1.cs Project: racuca/AutoExcel

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