How to validate a CSV File in C# .Net Framework

File validation is the very foundation of workflow stability. Without it, the whole house of cards can easily come crashing down with just a single broken file. Proper validation for CSV files is actually quite difficult to implement, with a great deal of different things that need to be checked. In today’s post, I will be showing you a very easy way of getting CSV validation into your project. Let’s dive in!

First we are going to install our API client with the following command:

Install-Package Cloudmersive.APIClient.NET.DocumentAndDataConvert -Version 3.2.8

Now we are going to go ahead with calling our CSV validation function, as you see demonstrated below:

using System;
using System.Diagnostics;
using Cloudmersive.APIClient.NET.DocumentAndDataConvert.Api;
using Cloudmersive.APIClient.NET.DocumentAndDataConvert.Client;
using Cloudmersive.APIClient.NET.DocumentAndDataConvert.Model;
namespace Example
{
public class ValidateDocumentCsvValidationExample
{
public void main()
{
// Configure API key authorization: Apikey
Configuration.Default.AddApiKey("Apikey", "YOUR_API_KEY");
// Uncomment below to setup prefix (e.g. Bearer) for API key, if needed
// Configuration.Default.AddApiKeyPrefix("Apikey", "Bearer");
var apiInstance = new ValidateDocumentApi();
var inputFile = new System.IO.Stream(); // System.IO.Stream | Input file to perform the operation on.
try
{
// Validate a CSV file document (CSV)
DocumentValidationResult result = apiInstance.ValidateDocumentCsvValidation(inputFile);
Debug.WriteLine(result);
}
catch (Exception e)
{
Debug.Print("Exception when calling ValidateDocumentApi.ValidateDocumentCsvValidation: " + e.Message );
}
}
}
}

Simple.