using System;
using System.Diagnostics;
using Bytescout.Spreadsheet;
using Bytescout.Spreadsheet.BaseClasses;

namespace SearchAndReplaceText
{
	class Program
	{
		static void Main(string[] args)
		{
			// Open spreadsheet from file
			Spreadsheet document = new Spreadsheet();
			document.LoadFromFile("example.xls");

			string valueToFind = ",";
			string valueToReplaceWith = ";";
			string outputFileName = "output.xls";

			// Get first worksheet
			Worksheet worksheet = document.Workbook.Worksheets[0];

			// Find cells
            Cell cell = worksheet.Find(
				valueToFind, false /*case insesitive*/, false /*not regexp*/, false /*search forward*/);

			// Iterate through all cells and perform replace
			while (cell != null)
			{
				// Print found cell address and value to console
				CellAddress address = cell.GetAddress();

				Console.WriteLine("({0}, {1}) - {2}", address.Row, address.Column, cell.ValueAsString);

				// Perform replace 
				cell.Value = cell.ValueAsString.Replace(valueToFind, valueToReplaceWith);

				cell = worksheet.FindNext();
			}

			// Save output file
			document.SaveAs(outputFileName);
			Console.WriteLine("\nOutput File Saved at {0}\n", outputFileName);

			document.Dispose();

			// Open output file
			Process.Start(outputFileName);

			Console.WriteLine();
			Console.WriteLine("Press any key to continue ...");
			Console.ReadKey(true);
		}
	}
}