ByteScout Data Extraction Suite – C# – Read cell color with spreadsheet sdk

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

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

How to read cell color with spreadsheet sdk in C# using ByteScout Data Extraction Suite

If you want to learn more then this tutorial will show how to read cell color with spreadsheet sdk in C#

On this page you will learn from code samples for programming in C#.Writing of the code to read cell color with spreadsheet sdk in C# can be executed by programmers of any level using ByteScout Data Extraction Suite. ByteScout Data Extraction Suite: the bundle that includes three SDK tools for data extraction from PDF, scans, images and from spreadsheets: PDF Extractor SDK, Data Extraction SDK, Barcode Reader SDK. It can read cell color with spreadsheet sdk in C#.

Want to save time? You will save a lot of time on writing and testing code as you may just take the C# code from ByteScout Data Extraction Suite for read cell color with spreadsheet sdk below and use it in your application. This C# sample code is all you need for your app. Just copy and paste the code, add references (if needs to) and you are all set! Check C# sample code samples to see if they respond to your needs and requirements for the project.

The trial version of ByteScout Data Extraction 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();
        }
    }
}