ByteScout Barcode Suite - C# - Validate cells with dates with spreadsheet sdk - ByteScout

ByteScout Barcode Suite – C# – Validate cells with dates with spreadsheet sdk

  • Home
  • /
  • Articles
  • /
  • ByteScout Barcode Suite – C# – Validate cells with dates with spreadsheet sdk

validate cells with dates with spreadsheet sdk in C# and ByteScout Barcode Suite

Simple tutorial on how to do validate cells with dates with spreadsheet sdk in C#

The documentation is crafted to assist you to apply the features on your side easily. ByteScout Barcode Suite helps with validate cells with dates with spreadsheet sdk in C#. ByteScout Barcode Suite is the set that includes three different SDK products to generate barcodes, read barcodes and read and write spreadsheets: Barcode SDK, Barcode Reader SDK and Spreadsheet SDK.

If you want to quickly learn then these fast application programming interfaces of ByteScout Barcode Suite for C# plus the guideline and the C# code below will help you quickly learn validate cells with dates with spreadsheet sdk. Just copy and paste this C# sample code to your C# application’s code editor, add a reference to ByteScout Barcode Suite (if you haven’t added yet) and you are ready to go! Use of ByteScout Barcode Suite in C# is also described in the documentation included along with the product.

Trial version can be downloaded from our website for free. It contains this and other source code samples for C#.

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 System.Collections.Generic; using System.Text; using System.Diagnostics; using Bytescout.Spreadsheet; using System.IO; namespace HelloWorld { class Program { static void Main(string[] args) { // in this sample we scan cells with ages data for people // then mark all dates where age is between 10 and 19 years and mark these cells with red color // Create new Spreadsheet Spreadsheet document = new Spreadsheet(); document.LoadFromFile("Data.xls"); // Get worksheet by name Worksheet worksheet = document.Workbook.Worksheets.ByName("Sample"); // Years range int RangeMin = 10; int RangeMax = 19; // Minimum age DateTime YearMin = DateTime.Now; // Maximum age DateTime YearMax = DateTime.Now; // Minimum year YearMax = YearMax.AddYears(-RangeMin); // Maximum year YearMin = YearMin.AddYears(-RangeMax); // Check dates for (int i = 1; i < 8; i++) { // Set current cell Cell currentCell = worksheet.Cell(i, 1); DateTime dateBirth = currentCell.ValueAsDateTime; // Check current cell if (dateBirth < YearMin || dateBirth > YearMax) { // Set fill pattern currentCell.FillPattern = Bytescout.Spreadsheet.Constants.PatternStyle.Solid; // Markup wrong cell by red color currentCell.FillPatternForeColor = System.Drawing.Color.Red; } // Set cell format currentCell.NumberFormatString = "dd.mm.yyyy"; } // 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"); } } }

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