ByteScout Data Extraction Suite – VB.NET – Read cell color with spreadsheet sdk

Home
/
Articles
/
ByteScout Data Extraction Suite – VB.NET – Read cell color with spreadsheet sdk

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

How to read cell color with spreadsheet sdk in VB.NET and ByteScout Data Extraction Suite

Continuous learning is a crucial part of computer science and this tutorial shows how to read cell color with spreadsheet sdk in VB.NET

These source code samples are assembled by their programming language and functions they apply. ByteScout Data Extraction Suite can read cell color with spreadsheet sdk. It can be applied from VB.NET. 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.

This prolific sample source code in VB.NET for ByteScout Data Extraction Suite contains various functions and other necessary options you should do calling the API to read cell color with spreadsheet sdk. Just copy and paste the code into your VB.NET application’s code and follow the instructions. Complete and detailed tutorials and documentation are available along with installed ByteScout Data Extraction Suite if you’d like to learn more about the topic and the details of the API.

ByteScout provides the free trial version of ByteScout Data Extraction Suite along with the documentation and source code samples.

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

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

Module1.vb

      Imports Bytescout.Spreadsheet

Module Module1

    Sub Main()
        ' Open existing XLS document
        Dim spreadSheet As New Spreadsheet()
spreadSheet.LoadFromFile("input.xls")

        ' Take existing worksheet
        Dim sheet As Worksheet = spreadSheet.Worksheet(0)

        ' Take cell
        Dim cell As 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()
    End Sub

End Module