ByteScout Barcode Suite - VB.NET - Search text with spreadsheet sdk - ByteScout

ByteScout Barcode Suite – VB.NET – Search text with spreadsheet sdk

  • Home
  • /
  • Articles
  • /
  • ByteScout Barcode Suite – VB.NET – Search text with spreadsheet sdk

How to search text with spreadsheet sdk in VB.NET using ByteScout Barcode Suite

Step-by-step tutorial on how to search text with spreadsheet sdk in VB.NET

These source code samples are assembled by their programming language and functions they apply. ByteScout Barcode Suite 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) and you can use it to search text with spreadsheet sdk with VB.NET.

These VB.NET code samples for VB.NET guide developers to speed up coding of the application when using ByteScout Barcode Suite. Simply copy and paste in your VB.NET project or application you and then run your app! Enjoy writing a code with ready-to-use sample VB.NET codes.

ByteScout Barcode Suite free trial version is available on our website. VB.NET and other programming languages are supported.

On-demand (REST Web API) version:
 Web API (on-demand version)

On-premise offline SDK for Windows:
 60 Day Free Trial (on-premise)

Program.vb
      
Imports Bytescout.Spreadsheet Imports Bytescout.Spreadsheet.BaseClasses Class Program Friend Shared Sub Main(args As String()) ' Open spreadsheet from file Dim document As New Spreadsheet() document.LoadFromFile("example.xls") ' Get first worksheet Dim worksheet As Worksheet = document.Workbook.Worksheets(0) ' Find cells containing "in" substring Dim cell As Cell = worksheet.Find("in", False, False, False) 'case insesitive, not regexp, search forward While cell IsNot Nothing ' Print found cell address and value to console Dim address As CellAddress = cell.GetAddress() Dim message As String = String.Format("({0}, {1}): {2}", address.Column, address.Row, cell.ValueAsExcelDisplays) Console.WriteLine(message) cell = worksheet.FindNext() End While document.Dispose() Console.WriteLine() Console.WriteLine("Press any key to continue.") Console.ReadKey(True) End Sub End Class

ON-PREMISE OFFLINE SDK

60 Day Free Trial or Visit ByteScout Barcode Suite Home Page

Explore ByteScout Barcode Suite Documentation

Explore Samples

Sign Up for ByteScout Barcode Suite Online Training

ON-DEMAND REST WEB API

Get Your API Key

Explore Web API Docs

Explore Web API Samples

VIDEO

ON-PREMISE OFFLINE SDK

60 Day Free Trial or Visit ByteScout Barcode Suite Home Page

Explore ByteScout Barcode Suite Documentation

Explore Samples

Sign Up for ByteScout Barcode Suite Online Training

ON-DEMAND REST WEB API

Get Your API Key

Explore Web API Docs

Explore Web API Samples

Tutorials:

prev
next