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

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

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

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

Step-by-step tutorial on how to read cell color with spreadsheet sdk in VB.NET

An easy to understand guide on how to read cell color with spreadsheet sdk in VB.NET with this source code sample. What is ByteScout Barcode Suite? It is the bundle that privides 3 SDK products to generate barcodes (Barcode SDK), read barcodes (Barcode Reaer SDK) and read and write spreadsheets (Spreadsheet SDK). It can help you to read cell color with spreadsheet sdk in your VB.NET application.

Want to quickly learn? This fast application programming interfaces of ByteScout Barcode Suite for VB.NET plus the guidelines and the code below will help you quickly learn how to read cell color with spreadsheet sdk. IF you want to implement the functionality, just copy and paste this code for VB.NET below into your code editor with your app, compile and run your application. Further improvement of the code will make it more robust.

Trial version of ByteScout Barcode Suite is available for free. Source code samples are included to help you with your VB.NET app.

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