ByteScout Spreadsheet SDK – VB.NET – Read Cell Color

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

ByteScout Spreadsheet SDK – VB.NET – Read Cell Color

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


  Click here to get your Free Trial version of the SDK

prev
next