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 btnRenameSheet_Click(object sender, EventArgs e)
{
ExcelBinder excelbinder = new ExcelBinder();
excelbinder.OpenDocument(Path.Combine(Environment.CurrentDirectory, "testnewsheet.xlsx"));
excelbinder.Visible = true;
excelbinder.RenameSheet(4, "RenameTest1");
excelbinder.SaveDocument(Path.Combine(Environment.CurrentDirectory, "testnewsheet.xlsx"));
excelbinder.CloseDocument();
excelbinder.QuitDocument();
}