C#/VB.NET How to Accept or Reject Tracked Changes in Excel?

-

The revision function can track all the revisions of the document and understand the revision process, which is a very useful function for the team to collaborate on document editing and review. When sending the workbook to others for review, we can enable the revision function. After the shared workbook is modified, the user can choose to accept or reject the data information modified by others when viewing the document. This article will introduce you in detail how to accept or reject revisions in Excel. 

  • Accept All Tracked Changes in a Workbook

  • Reject All Tracked Changes in a Workbook

Programming Environment

In this test, Free Spire.XLS for .NET is introduced into the program. The Spire.XLS.dll file can be referenced by:

Method 1: Download Free Spire.XLS for .NET locally, unzip it, and install it. After the installation is complete, find Spire.XLS.dll in the BIN folder under the installation path. Then open the "Solution Explorer" in Visual Studio, right-click "References", "Add Reference", and add a reference to the dll file in the BIN folder of the local path to the program.

Method 2: Install via NuGet. It can be installed by the following 2 methods:

(1) You can open the "Solution Explorer" in Visual Studio, right-click "References", "Manage NuGet Packages", then search for "Free Spire.XLS", and click "Install". Wait for the program installation to complete.

(2) Copy the following content to the PM console installation.

Install-Package FreeSpire.XLS -Version 12.7

Accept All Tracked Changes in a Workbook

  • Create a Workbook object.
  • Load a sample Excel document using Workbook.LoadFromFile() method.
  • Determine if the workbook has tracked changes using Workbook.HasTrackedChanges property.
  • Accept all tracked changes in the workbook using Workbook.AcceptAllTrackedChanges() method.
  • Save the result document using Workbook.SaveToFile() method.

Full Code

C#

using Spire.Xls; 

namespace AcceptTrackedChanges

{

    class Program

    {

        static void Main(string[] args)

        {

            //Create a Workbook object

            Workbook workbook = new Workbook();

            //Load a sample Excel document

            workbook.LoadFromFile("Sample.xlsx");

 

            //Determine if the workbook has tracked changes

            if (workbook.HasTrackedChanges)

            {

                //Accept all tracked changes in the workbook

                workbook.AcceptAllTrackedChanges();

            }

            //Save the result document

            workbook.SaveToFile("AcceptChanges.xlsx", FileFormat.Version2013);

        }

    }

}

VB.NET

Imports Spire.Xls

Namespace AcceptTrackedChanges

    Friend Class Program

        Private Shared Sub Main(ByVal args As String())

            'Create a Workbook object

            Dim workbook As Workbook = New Workbook()

            'Load a sample Excel document

            workbook.LoadFromFile("Sample.xlsx")

            'Determine if the workbook has tracked changes

            If workbook.HasTrackedChanges Then

                'Accept all tracked changes in the workbook

                workbook.AcceptAllTrackedChanges()

            End If

            'Save the result document

            workbook.SaveToFile("AcceptChanges.xlsx", FileFormat.Version2013)

        End Sub

    End Class

End Namespace

Effective Shot


Reject All Tracked Changes in a Workbook

  • Create a Workbook object.
  • Load a sample Excel document using Workbook.LoadFromFile() method.
  • Determine if the workbook has tracked changes using Workbook.HasTrackedChanges property.
  • Reject all tracked changes in the workbook using Workbook.RejectAllTrackedChanges() method.
  • Save the result document using Workbook.SaveToFile() method.

Full Code

C#

using Spire.Xls; 

namespace AcceptTrackedChanges

{

    class Program

    {

        static void Main(string[] args)

        {

            //Create a Workbook object

            Workbook workbook = new Workbook();

            //Load a sample Excel document

            workbook.LoadFromFile("Sample.xlsx");

            //Determine if the workbook has tracked changes

            if (workbook.HasTrackedChanges)

            {

                //Reject all tracked changes in the workbook

                workbook.RejectAllTrackedChanges();

            }

            //Save the result document

            workbook.SaveToFile("RejectChanges.xlsx", FileFormat.Version2013);

        }

    }

}

VB.NET

Imports Spire.Xls 

Namespace AcceptTrackedChanges

    Friend Class Program

        Private Shared Sub Main(ByVal args As String())

            'Create a Workbook object

            Dim workbook As Workbook = New Workbook()

            'Load a sample Excel document

            workbook.LoadFromFile("Sample.xlsx")

 

            'Determine if the workbook has tracked changes

            If workbook.HasTrackedChanges Then

                'Reject all tracked changes in the workbook

                workbook.RejectAllTrackedChanges()

            End If

            'Save the result document

            workbook.SaveToFile("RejectChanges.xlsx", FileFormat.Version2013)

        End Sub

    End Class

End Namespace

Effective Shot


Conclusion:

 In this post, you have learned how to accept or reject tracked changes in Excel in C#/VB.NET. Not only that, we also have other functions, such as, C#/VB.NET: Split Excel Sheets into Separate Files, Insert HTML-Formatted Rich Text into Excel Cell and so on. Apart from that, if you'd like to learn more, you can visit this link to explore more about for Spire.XLS for .NET.


Comments

Post a Comment

Popular posts from this blog

How to Change Font Color in Word via Java

-
Image
To make it easier for readers to grasp the main points of an article, we sometimes need to modify the color of the font to highlight the key points. This article will explain how to change the font color in Word programmatically. To explain how to do this, this article will be divided into two parts.I have attached the C#/VB.NET code for your reference, along with the steps I took to sort things out.     Change Font Color of a Paragraph     Change Font Color of a Specific Text Programming Environment First, you’re required to add the Spire.Doc.jar file as a dependency in your Java program. The JAR file can be downloaded from this link. Method 1: Introduced manually. Download Free Spire.Doc for Java locally, unzip it, and find the Spire.Doc.jar file in the lib folder. Open the following interface in IDEA, and import the jar file in the local path into the Java program: Method 2: If you use Maven , you can easily import the JAR file in your ap...
Read more
-
Image
 Multimedia information can be presented conveniently by using PowerPoint, and the information form is multimedia and expressive. But it is inevitable that in some cases we will need to convert PowerPoint to HTML format. Because HTML documents can be independent of various operating system platforms (such as Unix, Windows, etc.). And it can add content such as pictures, sounds, animations, videos, etc., and can also jump from one file to another, and connect with files on hosts around the world. Through HTML, rich and colorful design styles can be displayed, jumps between pages can be realized, and multimedia effects can be displayed. This article will introduce in detail how to convert PowerPoint to HTML through C#/VB.NET code. Convert a PowerPoint Presentation to HTML Convert a Specific PowerPoint Slide to HTML Programming Environment   In this test, Free Spire.Presentation for .NET is introduced into the program. The Spire.Presentation.dll file can be referenced by...
Read more

How to Convert OpenDocument Presentation (.odp) to PDF via Java Application

-
Image
  OpenDocument Format (ODF) is a document file format that contains OpenDocument presentations. It consists of a collection of pages (slides) containing text, graphics and multimedia content, which can be displayed in front of an audience in a controlled manner. But at work, you may need to convert it to a PDF document. Today I will introduce a method for you to convert ODP documents to PDF format quickly and efficiently. The following are the steps and methods I have organized, and the Java code is attached for your reference. OK, here we go. Programming Environment First, you’re required to add the Spire.Presentation.jar file as a dependency in your Java program. The JAR file can be downloaded from this link. Method 1: Introduced manually. Download Free Spire. Presentation for Java locally, unzip it, and find the Spire. Presentation .jar file in the lib folder. Open the following interface in IDEA, and import the jar file in the local path into the Java program: Metho...
Read more