Get Distinct Records from Excel Column using C#
You can get unique records from a excel column by using C#. For this, you need to use freeSpire.xls library which makes it easy to work on excel. Here is simple example that will help […]
Author: codef4devs
C# | Insert Text in New Line of Multiline Text Box by Button Click
Here in this C# example, we will show how to add text in new line of Multiline text box. The text will be inserted in new line when user clicks on a button. For a […]
Math.Truncate() in C# | Get Integral and Fractional Part of Number
Truncate method of Math class is used to find integral part of a specified decimal number or double-precision floating-point number. You can find decimal part of a specified decimal number as well by using Truncate […]
Reading Multiline Textbox Line by Line in C# Windows Form Application
If you need to read a multiline TextBox line by line in C#, you need to use the Lines property of the TextBox. This property gives you an array of strings in return. Each element of this array corresponds to […]
C# – Round Up or Round Down Number to Nearest Multiple of 10
You are given a number, and you need to round it up or down to nearest multiple of 10, means round up or down to a number having 0 as last digit like as given […]
How to Set Excel Sheet Zoom Percentage using C#
If you are automating excel using C# and Microsoft.Office.Interop and you need to set the zoom factor of excel sheet, first you need to activate that particular sheet then set the zoom percentage of ActiveWindow.Zoom […]
C# Code to Delete Mail After Send from Outlook Sent Item
When you send mail using outlook, you can see that mail in sent Item folder. If you have automated your outlook mail sending process using C#, you can see all your mails in sent item […]
C# – Paste Values as Transpose in Excel
Need to paste values as transpose in excel programmatically using C#? This post is going to guide you to do so. What Is Transpose Values in MS Excel? Transpose values in MS Excel is converting […]
Simple Way to Convert XLSX file to CSV file by C#
This article demonstrates the C# code snippet to easily convert excel files to csv files. In this code example, you can define your own desired csv delimiter (comma, semicolon, pipe etc.) To do so, you […]
Calculated Fields – Excel Pivot Table Advanced Feature
Insert Calculated Fields feature of Pivot table enable you to add a virtual column, based on some calculation over existing columns, which is physically not present in dataset but gets available in Pivot Table fields. […]