ByteScout Spreadsheet SDK - VB.NET - Read Cell Color - ByteScout

ByteScout Spreadsheet SDK – VB.NET – Read Cell Color

  • Home
  • /
  • Articles
  • /
  • ByteScout Spreadsheet SDK – VB.NET – Read Cell Color

How to read cell color in VB.NET and ByteScout Spreadsheet SDK

Write code in VB.NET to read cell color with this step-by-step tutorial

ByteScout tutorials are designed to explain the code for both VB.NET beginners and advanced programmers. What is ByteScout Spreadsheet SDK? It is the SDK to create, read, modify and calculate spreadsheets. Formula calculations are supported, import and export to and from JSON, CSV, XML, databases, arrays. It can help you to read cell color in your VB.NET application.

This code snippet below for ByteScout Spreadsheet SDK works best when you need to quickly read cell color in your VB.NET application. This VB.NET sample code is all you need for your app. Just copy and paste the code, add references (if needs to) and you are all set! Test VB.NET sample code examples whether they respond your needs and requirements for the project.

ByteScout free trial version is available for download from our website. It includes all these programming tutorials along with source code samples.

Try ByteScout Spreadsheet SDK today: Get 60 Day Free Trial or sign up for Web API

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

Try ByteScout Spreadsheet SDK today: 60 Day Free Trial (on-premise version) or sign up for Web API (on demand version)

VIDEO

ON-PREMISE VERSION

Get 60 Day Free Trial or Visit ByteScout Spreadsheet SDK page

Explore ByteScout Spreadsheet SDK documentation

WEB API

Sign Up for free Web API key

Explore Web API Documentation

Tutorials:

prev
next