Useful Windows CMD Commands to Work on Files and Folders
The Windows command line (CMD) is one of the most useful utilities on a Windows PC. You can interact with the Operating System directly with the help of CMD and you can do a lot […]
Author: codef4devs
Using InputBox in Excel VBA
InputBox is an inbuilt function in Excel VBA that is used to get a value from the user. InputBox asks the user to enter the value and then can store the value in the variable […]
Export C# DataTable to MS Excel
Here, in this post, we are going to show you an C# code example of exporting a C# datatable data to MS Excel with headers. Step1: Add reference to Microsoft Excel Interop in your application. […]
Excel VBA Code to Remove Duplicate Values in a Data Range
We use Remove Duplicates feature of excel application to remove duplicate data in a column. Same task we can do by using VBA code. Range.RemoveDuplicates method of exvel VBA helps you to do this. We […]
How to Get All Files Available in a Directory By C#
This post shows an example of listing name of all files with extension, available in a folder. We need to import System.IO namespace in our program and Directory.GetFiles() method helps you to get the list […]
Creating A Directory by C# Code
In this post, we will demonstrate an example of creating a directory by using C# code. For creating a directory in file system, you need to import System.IO namespace in program and CreateDirectory() method of […]
How to Check if a File Exists by Using C#
When you need to check whether a particular file exists on a specified path, you can use File.Exists(string) method of C#. This method requires full file name i.e. file name along with its extension and […]
How to Copy Visible Cells only in Excel Filter by C#
After applying filter to excel range, rows not satisfying the filter condition get hidden and only rows satisfying the filter condition are visible. Refer our previous post for detailed Excel AutoFilter by C# information. Below […]
Using Auto Filter on Excel Range by C#
Here in this article, we are going to provide you an overview of applying and working with filters on Excel range. C# Syntax of Applying Filters in Excel The below code line applies filter on […]
Find Last Used Row or Column of Excel in C#
While working with excel using C# you can require to find the last used row or column in a range. Here in this post, we are providing you the code snippets that will simplify your […]