ByteScout Spreadsheet SDK – C# – Validate Data in Cell and Mark Wrong With Color

  • Home
  • /
  • Articles
  • /
  • ByteScout Spreadsheet SDK – C# – Validate Data in Cell and Mark Wrong With Color

ByteScout Spreadsheet SDK – C# – Validate Data in Cell and Mark Wrong With Color

Program.cs

using System;
using System.Collections.Generic;
using System.Text;
using System.Diagnostics;
using Bytescout.Spreadsheet;
using System.IO;

namespace HelloWorld
{
class Program
{
static void Main(string[] args)
{
// Create new Spreadsheet
Spreadsheet document = new Spreadsheet();
document.LoadFromFile(“Data.xls”);

// Get worksheet by name
Worksheet worksheet = document.Workbook.Worksheets.ByName(“Sample”);

// Spellcheck words
for (int i = 0; i < 5; i++) { // Set current cell Cell currentCell = worksheet.Cell(0, i); // Spellcheck current cell if ((string)currentCell.Value == "Simpsan") { // Set fill pattern currentCell.FillPattern = Bytescout.Spreadsheet.Constants.PatternStyle.Solid; // Markup wrong word by red color currentCell.FillPatternForeColor = System.Drawing.Color.Red; } } // delete output file if exists already if (File.Exists("Output.xls")){ File.Delete("Output.xls"); } // Save document document.SaveAs("Output.xls"); // Close Spreadsheet document.Close(); // open generated XLS document in default program Process.Start("Output.xls"); } } } [/csharp]


  Click here to get your Free Trial version of the SDK

Tutorials:

prev
next