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

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

printable version:
ByteScout-Data-Extraction-Suite-C-sharp-Search-text-with-spreadsheet-sdk.pdf

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);
		}
	}
}