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.
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