PM> Install-Package Spire.XLS

using Spire.Xls;
using System.Drawing;

namespace ReplaceDataInWorksheet
{
    internal class Program
    {
        static void Main(string[] args)
        {
            //Initialize an instance of the Workbook class
            Workbook workbook = new Workbook();
            //Load an Excel file
            workbook.LoadFromFile(@"Sample.xlsx");

            //Get the first worksheet
            Worksheet worksheet = workbook.Worksheets[0];

            //Find the cells with the specific string value “Total” in the worksheet
            CellRange[] cells = worksheet.FindAllString("Total", true, true);

            //Iterate through the found cells
            foreach (CellRange cell in cells)
            {
                //Replace the value of the cell with another value
                cell.Text = "Sum";
                //Set a background color for the cell
                cell.Style.Color = Color.Yellow;
            }

            //Save the result file to a specific location
            workbook.SaveToFile("ReplaceDataInWorksheet.xlsx", ExcelVersion.Version2016);
            workbook.Dispose();
        }
    }
}

Imports Spire.Xls
Imports System.Drawing

Namespace ReplaceDataInWorksheet
    Friend Class Program
        Private Shared Sub Main(ByVal args As String())
            'Initialize an instance of the Workbook class
            Dim workbook As Workbook = New Workbook()
            'Load an Excel file
            workbook.LoadFromFile("Sample.xlsx")

            'Get the first worksheet
            Dim worksheet As Worksheet = workbook.Worksheets(0)

            'Find the cells with the specific string value “Total” in the worksheet
            Dim cells As CellRange() = worksheet.FindAllString("Total", True, True)

            'Iterate through the found cells
            For Each cell As CellRange In cells
                'Replace the value of the cell with another value
                cell.Text = "Sum"
                'Set a background color for the cell
                cell.Style.Color = Color.Yellow
            Next

            'Save the result file to a specific location
            workbook.SaveToFile("ReplaceDataInWorksheet.xlsx", ExcelVersion.Version2016)
            workbook.Dispose()
        End Sub
    End Class
End Namespace

using Spire.Xls;
using System.Drawing;

namespace ReplaceDataInCellRange
{
    internal class Program
    {
        static void Main(string[] args)
        {
            //Initialize an instance of the Workbook class
            Workbook workbook = new Workbook();
            //Load an Excel file
            workbook.LoadFromFile(@"Sample.xlsx");

            //Get the first worksheet
            Worksheet worksheet = workbook.Worksheets[0];

            //Get a specific cell range
            CellRange range = worksheet.Range["A1:C9"];            

            //Find the cells with the specific value "Total" in the cell range
            CellRange[] cells = range.FindAllString("Total", true, true);

            //Iterate through the found cells
            foreach (CellRange cell in cells)
            {
                //Replace the value of the cell with another value
                cell.Text = "Sum";
                //Set a background color for the cell
                cell.Style.Color = Color.Yellow;
            }

            //Save the result file to a specific location
            workbook.SaveToFile("ReplaceDataInCellRange.xlsx", ExcelVersion.Version2016);
            workbook.Dispose();
        }
    }
}

Imports Spire.Xls
Imports System.Drawing

Namespace ReplaceDataInCellRange
    Friend Class Program
        Private Shared Sub Main(ByVal args As String())
            'Initialize an instance of the Workbook class
            Dim workbook As Workbook = New Workbook()
            'Load an Excel file
            workbook.LoadFromFile("Sample.xlsx")

            'Get the first worksheet
            Dim worksheet As Worksheet = workbook.Worksheets(0)

            'Get a specific cell range
            Dim range As CellRange = worksheet.Range("A1:C9")

            'Find the cells with the specific value "Total" in the cell range
            Dim cells As CellRange() = range.FindAllString("Total", True, True)

            'Iterate through the found cells
            For Each cell As CellRange In cells
                'Replace the value of the cell with another value
                cell.Text = "Sum"
                'Set a background color for the cell
                cell.Style.Color = Color.Yellow
            Next

            'Save the result file to a specific location
            workbook.SaveToFile("ReplaceDataInCellRange.xlsx", ExcelVersion.Version2016)
            workbook.Dispose()
        End Sub
    End Class
End Namespace

PM> Install-Package Spire.XLS

using Spire.Xls;

namespace SortData
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create a Workbook instance
            Workbook workbook = new Workbook();

            //Load a sample Excel document
            workbook.LoadFromFile("sample.xlsx");

            //Get the first worksheet
            Worksheet worksheet = workbook.Worksheets[0];

            //Specify the column that need to be sorted and the sort mode (ascending or descending)
            workbook.DataSorter.SortColumns.Add(0, SortComparsionType.Values, OrderBy.Ascending);

            //Sort data in the specified cell range
            workbook.DataSorter.Sort(worksheet.Range["A1:D10"]);

            //Save the result document
            workbook.SaveToFile("Sort.xlsx", ExcelVersion.Version2016);
        }
    }
}

Imports Spire.Xls

Namespace SortData
    Class Program
        Private Shared Sub Main(ByVal args() As String)

            'Create a Workbook instance
            Dim workbook As Workbook = New Workbook

            'Load a sample Excel document
            workbook.LoadFromFile("sample.xlsx")

            'Get the first worksheet
            Dim worksheet As Worksheet = workbook.Worksheets(0)

            'Specify the column that need to be sorted and the sort mode (ascending or descending)
            workbook.DataSorter.SortColumns.Add(0, SortComparsionType.Values, OrderBy.Ascending)

            'Sort data in the specified cell range
            workbook.DataSorter.Sort(worksheet.Range("A1:D10"))

            'Save the result document
            workbook.SaveToFile("Sort.xlsx", ExcelVersion.Version2016)
        End Sub
    End Class
End Namespace

PM> Install-Package Spire.XLS

using Spire.Xls;

namespace WrapText
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create a Workbook object
            Workbook workbook = new Workbook();

            //Load a sample Excel file
            workbook.LoadFromFile(@"D:\Files\sample.xlsx");

            //Get the first worksheet
            Worksheet sheet = workbook.Worksheets[0];

            //Wrap text in cell B3
            sheet.Range["B3"].Style.WrapText = true;

            //Unwrap text in cell B7
            sheet.Range["B7"].Style.WrapText = false;

            //Save the result file
            workbook.SaveToFile("WarpText.xlsx", ExcelVersion.Version2010);
        }
    }
}

Imports Spire.Xls

Namespace WrapText
    Class Program
        Private Shared Sub Main(ByVal args As String())

            'Create a Workbook object
            Dim workbook As Workbook = New Workbook()

            'Load a sample Excel file
            workbook.LoadFromFile("D:\Files\sample.xlsx")

            'Get the first worksheet
            Dim sheet As Worksheet = workbook.Worksheets(0)

            'Wrap text in cell B3
            sheet.Range("B3").Style.WrapText = True

            'Unwrap text in cell B7
            sheet.Range("B7").Style.WrapText = False

            'Save the result file
            workbook.SaveToFile("WarpText.xlsx", ExcelVersion.Version2010)
        End Sub
    End Class
End Namespace