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

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

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

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

Continuous learning is a crucial part of computer science and this tutorial shows how to get cell color with spreadsheet sdk in C#

The coding instructions are formulated to help you to try-out the features without the requirement to write your own code. ByteScout Data Extraction Suite can get cell color with spreadsheet sdk. It can be applied from C#. ByteScout Data Extraction Suite is the set that includes 3 SDK products for data extraction from PDF, scans, images and from spreadsheets: PDF Extractor SDK, Data Extraction SDK, Barcode Reader SDK.

The following code snippet for ByteScout Data Extraction Suite works best when you need to quickly get cell color with spreadsheet sdk in your C# application. Follow the instructions from scratch to work and copy the C# code. Use of ByteScout Data Extraction Suite in C# is also described in the documentation included along with the product.

All these programming tutorials along with source code samples and ByteScout free trial version are available for download from our website.

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