C# (CSharp) ExcelBinder.SetColor Examples

Example #1

File: Form1.cs Project: racuca/AutoExcel

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