ByteScout Data Extraction Suite - C# - Search text with spreadsheet sdk - ByteScout

ByteScout Data Extraction Suite – C# – Search text with spreadsheet sdk

  • Home
  • /
  • Articles
  • /
  • ByteScout Data Extraction Suite – C# – Search text with spreadsheet sdk

How to search text with spreadsheet sdk in C# using ByteScout Data Extraction Suite

Learn to search text with spreadsheet sdk in C#

The sample source codes on this page shows how to search text with spreadsheet sdk in C#. ByteScout Data Extraction Suite is the bundle that includes three SDK tools for data extraction from PDF, scans, images and from spreadsheets: PDF Extractor SDK, Data Extraction SDK, Barcode Reader SDK and you can use it to search text with spreadsheet sdk with C#.

The following code snippet for ByteScout Data Extraction Suite works best when you need to quickly search text with spreadsheet sdk in your C# application. This C# 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! Enjoy writing a code with ready-to-use sample codes in C#.

ByteScout Data Extraction Suite free trial version is available on our website. C# 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.cs
      
using System; using Bytescout.Spreadsheet; using Bytescout.Spreadsheet.BaseClasses; namespace SearchText { class Program { static void Main(string[] args) { // Open spreadsheet from file Spreadsheet document = new Spreadsheet(); document.LoadFromFile("example.xls"); // Get first worksheet Worksheet worksheet = document.Workbook.Worksheets[0]; // Find cells containing "in" substring Cell cell = worksheet.Find( "in", false /*case insesitive*/, false /*not regexp*/, false /*search forward*/); while (cell != null) { // Print found cell address and value to console CellAddress address = cell.GetAddress(); string message = string.Format( "({0}, {1}): {2}", address.Column, address.Row, cell.ValueAsExcelDisplays); Console.WriteLine(message); cell = worksheet.FindNext(); } document.Dispose(); Console.WriteLine(); Console.WriteLine("Press any key to continue."); Console.ReadKey(true); } } }

ON-PREMISE OFFLINE SDK

60 Day Free Trial or Visit ByteScout Data Extraction Suite Home Page

Explore ByteScout Data Extraction Suite Documentation

Explore Samples

Sign Up for ByteScout Data Extraction 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 Data Extraction Suite Home Page

Explore ByteScout Data Extraction Suite Documentation

Explore Samples

Sign Up for ByteScout Data Extraction Suite Online Training

ON-DEMAND REST WEB API

Get Your API Key

Explore Web API Docs

Explore Web API Samples

Tutorials:

prev
next