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: ApikeyConfiguration.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.

Image for post
Image for post

Written by

There’s an API for that. Cloudmersive is a leader in Highly Scalable Cloud APIs.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store