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 […]
Author: codef4devs
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. […]
Get Mail Address of Sender from Outlook Mail Item Object by C#
Here is a C# code example that will help you to find the mail ID of sender from Outlook Mail Item Object. We use SenderEmailType property of Outlook MailItem object to determine the email type […]
Extracting Attachment from Outlook Mail Item using C#
Here is an example C# code that helps you work on attachments in an outlook mail item. You can use Attachments property of Outlook MailItem object for saving attached file in outlook mail item by […]
Start, Stop and Restart MySQL Services on Windows 10
This post will help you to know how to start, stop or restart MySQL services on Windows 10 operating system. While working with MySQL, sometimes it becomes necessary to restart or starting, stopping MySQL server. […]
How to Protect an Excel File with Password
Protecting the excel workbook with a password is the best way to prevent others from accessing data in your excel workbook. This ensures that the data in workbook will be accessed by only authorized person, […]