C#/VB.NET – Copy Cell Ranges from One Workbook to Another

When you’re copying data from a workbook to another, you may not always need to copy the entire worksheet. Sometimes, you may only need to copy a selected cell ranges that contain the crucial information you want to reference in another workbook. In this article, I am going to show you how to copy cell …

C#/VB.NET – Accept or Reject Tracked Changes in Excel

Track Changes feature will let the user know what changes have been made to the file since the administrator has saved the file. When you receive the edited version of your manuscript with Track Changes turned on, you have the full authority to accept or reject each revision. In this article, I am going to …

C#/VB.NET – Set Excel Row Height and Column Width

When creating a new Excel document or editing an existing Excel document, you may need to adjust the row height and column width so that the content won’t go beyond the bounds of a cell.  In this article, I am going to introduce how to set row height or column width to a certain value, …

C#/VB.NET – Split Excel by Worksheets

If you have a large Excel document that contains multiple worksheets, you may find it frustrating to search for the useful information within them. In that case, you can split each worksheet into a separate Excel file for easier access. In this article, I am going to introduce how to accomplish this task by using …

C#/VB.NET – Highlight Duplicate Values in a Column

When we write data to excel, we may input data repeatedly because of carelessness. This article will introduce how to detect whether there is duplicate data in a column, and highlight the duplicate data by using Free Spire.XLS for .NET. INSTALL SPIRE.XLS.DLL Download the latest free version of Spire.XLS from this link, and manually add the …