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