ByteScout Barcode Suite – C# – Read cell color with spreadsheet sdk

Home
/
Articles
/
ByteScout Barcode Suite – C# – Read cell color with spreadsheet sdk

printable version:
ByteScout-Barcode-Suite-C-sharp-Read-cell-color-with-spreadsheet-sdk.pdf

How to read cell color with spreadsheet sdk in C# and ByteScout Barcode Suite

Learn to read cell color with spreadsheet sdk in C#

We made thousands of pre-made source code pieces for easy implementation in your own programming projects. Want to read cell color with spreadsheet sdk in your C# app? ByteScout Barcode Suite is designed for it. ByteScout Barcode Suite is the set that includes three different SDK products to generate barcodes, read barcodes and read and write spreadsheets: Barcode SDK, Barcode Reader SDK and Spreadsheet SDK.

The following code snippet for ByteScout Barcode Suite works best when you need to quickly read cell color with spreadsheet sdk in your C# application. IF you want to implement the functionality, just copy and paste this code for C# below into your code editor with your app, compile and run your application. Further improvement of the code will make it more robust.

The trial version of ByteScout Barcode Suite can be downloaded for free from our website. It also includes source code samples for C# and other programming languages.

On-demand (REST Web API) version:
Web API (on-demand version)

On-premise offline SDK for Windows:
60 Day Free Trial (on-premise)

Program.cs

      using System;
using System.Collections.Generic;
using System.Text;

using Bytescout.Spreadsheet;

namespace GetCellColor
{
    class Program
    {
        static void Main(string[] args)
        {
            // Open existing XLS document
            Spreadsheet spreadSheet = new Spreadsheet();
            spreadSheet.LoadFromFile("input.xls");

            // Take existing worksheet
            Worksheet sheet = spreadSheet.Worksheet(0);

            // Take cell
            Cell cell = sheet.Cell(0, 0);

            // Print back color of fill patter
            Console.WriteLine(cell.FillPatternBackColor.ToString());

            // Print fore color of fill pattern
            Console.WriteLine(cell.FillPatternForeColor.ToString());

            // Close spreadsheet
            spreadSheet.Close();


            Console.ReadKey();
        }
    }
}