PM> Install-Package Spire.XLS

using System.Drawing;
using Spire.Xls;

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

            //Load a sample Excel file
            workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\data.xlsx");

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

            //Set background color for Range ["A1:E1"] and ["A2:A10"]
            worksheet.Range["A1:E1"].Style.Color = Color.MediumSeaGreen;
            worksheet.Range["A2:A10"].Style.Color = Color.LightYellow;

            //Set background color for cell E6
            worksheet.Range["E6"].Style.Color = Color.Red;

            //Set pattern style for Range ["B4:D5"]
            worksheet.Range["B4:D5"].Style.FillPattern = ExcelPatternType.Percent125Gray;

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

    }
}

Imports System.Drawing
Imports Spire.Xls

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

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

            'Load a sample Excel file
            workbook.LoadFromFile("C:\Users\Administrator\Desktop\data.xlsx")

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

            'Set background color for Range["A1:E1"] and ["A2:A10"]
            worksheet.Range("A1:E1").Style.Color = Color.MediumSeaGreen
            worksheet.Range("A2:A10").Style.Color = Color.LightYellow

            'Set background color for cell E6
            worksheet.Range("E6").Style.Color = Color.Red

            'Set pattern style for Range["B4:D5"]
            worksheet.Range("B4:D5").Style.FillPattern = ExcelPatternType.Percent125Gray

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

PM> Install-Package Spire.XLS

using Spire.Xls;

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

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

            //Add a text hyperlink that leads to a webpage
            CellRange cell1 = sheet.Range["B3"];
            HyperLink urlLink = sheet.HyperLinks.Add(cell1);
            urlLink.Type = HyperLinkType.Url;
            urlLink.TextToDisplay = "Link to a website";
            urlLink.Address = "https://www.google.com/";

            //Add a text hyperlink that leads to an email address
            CellRange cell2 = sheet.Range["E3"];
            HyperLink mailLink = sheet.HyperLinks.Add(cell2);
            mailLink.Type = HyperLinkType.Url;
            mailLink.TextToDisplay = "Link to an email address";
            mailLink.Address = "mailto:abc@outlook.com";

            //Add a text hyperlink that leads to an external file
            CellRange cell3 = sheet.Range["B7"];
            HyperLink fileLink = sheet.HyperLinks.Add(cell3);
            fileLink.Type = HyperLinkType.File;
            fileLink.TextToDisplay = "Link to an external file";
            fileLink.Address = "C:\\Users\\Administrator\\Desktop\\Report.xlsx";

            //Add a text hyperlink that leads to a cell in another sheet
            CellRange cell4 = sheet.Range["E7"];
            HyperLink linkToSheet = sheet.HyperLinks.Add(cell4);
            linkToSheet.Type = HyperLinkType.Workbook;
            linkToSheet.TextToDisplay = "Link to a cell in sheet2";
            linkToSheet.Address = "Sheet2!B5";

            //Add a text hyperlink that leads to a UNC address
            CellRange cell5 = sheet.Range["B11"];
            HyperLink uncLink = sheet.HyperLinks.Add(cell5);
            uncLink.Type = HyperLinkType.Unc;
            uncLink.TextToDisplay = "Link to a UNC address";
            uncLink.Address = "\\\\192.168.0.121";

            //Autofit column width
            sheet.AutoFitColumn(2);
            sheet.AutoFitColumn(5);

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

Imports Spire.Xls

Namespace AddTextHyperlinks
    Friend Class Program
        Private Shared Sub Main(ByVal args As String())
            'Create a Workbook instance
            Dim workbook As Workbook = New Workbook()

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

            'Add a text hyperlink that leads to a webpage
            Dim cell1 As CellRange = sheet.Range("B3")
            Dim urlLink As HyperLink = sheet.HyperLinks.Add(cell1)
            urlLink.Type = HyperLinkType.Url
            urlLink.TextToDisplay = "Link to a website"
            urlLink.Address = "https://www.google.com/"

            'Add a text hyperlink that leads to an email address
            Dim cell2 As CellRange = sheet.Range("E3")
            Dim mailLink As HyperLink = sheet.HyperLinks.Add(cell2)
            mailLink.Type = HyperLinkType.Url
            mailLink.TextToDisplay = "Link to an email address"
            mailLink.Address = "mailto:abc@outlook.com"

            'Add a text hyperlink that leads to an external file
            Dim cell3 As CellRange = sheet.Range("B7")
            Dim fileLink As HyperLink = sheet.HyperLinks.Add(cell3)
            fileLink.Type = HyperLinkType.File
            fileLink.TextToDisplay = "Link to an external file"
            fileLink.Address = "C:\\Users\\Administrator\\Desktop\\Report.xlsx"

            'Add a text hyperlink that leads to a cell in another sheet
            Dim cell4 As CellRange = sheet.Range("E7")
            Dim linkToSheet As HyperLink = sheet.HyperLinks.Add(cell4)
            linkToSheet.Type = HyperLinkType.Workbook
            linkToSheet.TextToDisplay = "Link to a cell in sheet2"
            linkToSheet.Address = "Sheet2!B5"

            'Add a text hyperlink that leads to a UNC address
            Dim cell5 As CellRange = sheet.Range("B11")
            Dim uncLink As HyperLink = sheet.HyperLinks.Add(cell5)
            uncLink.Type = HyperLinkType.Unc
            uncLink.TextToDisplay = "Link to a UNC address"
            uncLink.Address = "\\\\192.168.0.121"

            'Autofit column width
            sheet.AutoFitColumn(2)
            sheet.AutoFitColumn(5)

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

using Spire.Xls;

namespace AddImageHyperlinks
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create a Workbook instance
            Workbook workbook = new Workbook();
            //Get the first worksheet 
            Worksheet sheet = workbook.Worksheets[0];

            //Insert an image into the worksheet
            ExcelPicture picture = sheet.Pictures.Add(5, 3, "Logo.png");
            sheet.Columns[2].ColumnWidth = 11;
            sheet.Rows[4].RowHeight = 60;

            //Add a hyperlink to the image 
            picture.SetHyperLink("https://www.e-iceblue.com", true);
            
            //Save the result file
            workbook.SaveToFile("AddImageHyperlink.xlsx", ExcelVersion.Version2013);
        }
    }
}

Imports Spire.Xls

Namespace AddImageHyperlinks
    Friend Class Program
        Private Shared Sub Main(ByVal args As String())
            'Create a Workbook instance
            Dim workbook As Workbook = New Workbook()
            'Get the first worksheet 
            Dim sheet As Worksheet = workbook.Worksheets(0)

            'Insert an image into the worksheet
            Dim picture As ExcelPicture = sheet.Pictures.Add(5, 3, "Logo.png")
            sheet.Columns(2).ColumnWidth = 11
            sheet.Rows(4).RowHeight = 60

            'Add a hyperlink to the image 
            picture.SetHyperLink("https://www.e-iceblue.com", True)

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

using Spire.Doc;
using Spire.Doc.Documents;
using Spire.Doc.Fields;

namespace ExtractImages
{
    class Program
    {
        static void Main(string[] args)
        {
            // Initialize a Document object
            Document document = new Document();

            // Load the Word file
            document.LoadFromFile("C:\\Users\\Administrator\\Desktop\\input.docx");

            // Counter for image files
            int index = 0;

            // Loop through each section in the document
            foreach (Section section in document.Sections)
            {
                // Loop through paragraphs in the section
                foreach (Paragraph paragraph in section.Paragraphs)
                {
                    // Loop through objects in the paragraph
                    foreach (DocumentObject docObject in paragraph.ChildObjects)
                    {
                        // Check if the object is an image
                        if (docObject.DocumentObjectType == DocumentObjectType.Picture)
                        {
                            // Save the image as a PNG file
                            DocPicture picture = docObject as DocPicture;
                            picture.Image.Save(string.Format("output/image_{0}.png", index), System.Drawing.Imaging.ImageFormat.Png);
                            index++;
                        }
                    }
                }
            }

            // Dispose resources
            document.Dispose();
        }
    }
}

PM> Install-Package Spire.Doc

using Spire.Doc;
using Spire.Doc.Documents;

namespace AddBookmarkToParagraph
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create a Document object
            Document doc = new Document();

            // Load a Word file
            doc.LoadFromFile("C:\\Users\\Administrator\\Desktop\\input.docx");

            // Get a specified paragraph
            Paragraph paragraph = doc.Sections[0].Paragraphs[2];

            // Create a bookmark start
            BookmarkStart start = paragraph.AppendBookmarkStart("myBookmark");

            // Insert it at the beginning of the paragraph
            paragraph.Items.Insert(0, start);

            // Append a bookmark end at the end of the paragraph
            paragraph.AppendBookmarkEnd("myBookmark");

            // Save the file
            doc.SaveToFile("AddBookmarkToParagraph.docx", FileFormat.Docx2019);

            // Dispose resources
            doc.Dispose();
        }
    }
}

using Spire.Doc;
using Spire.Doc.Documents;

namespace AddBookmarkToText
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create a Document object
            Document doc = new Document();

            // Load a Word file
            doc.LoadFromFile("C:\\Users\\Administrator\\Desktop\\input.docx");

            // Specify the string to find
            string stringToFind = "Privacy Policy";

            // Find the selected text from the document
            TextSelection[] finds = doc.FindAllString(stringToFind, false, true);
            TextSelection specificText = finds[1];

            // Find the paragraph where the text is located
            Paragraph para = specificText.GetAsOneRange().OwnerParagraph;

            // Get the index of the text in the paragraph
            int index = para.ChildObjects.IndexOf(specificText.GetAsOneRange());

            // Create a bookmark start
            BookmarkStart start = para.AppendBookmarkStart("myBookmark");

            // Insert the bookmark start at the index position
            para.ChildObjects.Insert(index, start);

            // Create a bookmark end
            BookmarkEnd end = para.AppendBookmarkEnd("myBookmark");

            // Insert the bookmark end at the end of the selected text
            para.ChildObjects.Insert(index + 2, end);

            // Save the document to another file
            doc.SaveToFile("AddBookmarkToText.docx", FileFormat.Docx2019);

            // Dispose resources
            doc.Dispose();
        }
    }
}

using Spire.Doc;

namespace RemoveBookmarks
{
    class Program
    {
        static void Main(string[] args)
        {

            // Create a Document object
            Document doc = new Document();

            // Load a Word file
            doc.LoadFromFile("C:\\Users\\Administrator\\Desktop\\Bookmarks.docx");

            // Get a specific bookmark by its index
            Bookmark bookmark = doc.Bookmarks[0];

            // Remove the bookmark
            doc.Bookmarks.Remove(bookmark);

            // Remove all bookmarks at once
            // doc.Bookmarks.Clear();

            // Save the document.
            doc.SaveToFile("RemoveBookmark.docx", FileFormat.Docx2019);

            // Dispose resources
            doc.Dispose();
        }
    }
}

PM> Install-Package Spire.Doc

using Spire.Doc;
using Spire.Doc.Documents;

namespace ModifyText
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create a new document object
            Document document = new Document();

            // Load an existing Word file
            document.LoadFromFile("C:\\Users\\Administrator\\Desktop\\input.docx");

            // Get a specific section
            Section section = document.Sections[0];

            // Get a specific paragraph
            Paragraph paragraph = section.Paragraphs[0];

            // Modify the text of the paragraph 
            paragraph.Text = "Updated Title";

            // Save the document to a different Word file
            document.SaveToFile("ModifyText.docx", FileFormat.Docx);

            // Dispose resource
            document.Dispose();
        }
    }
}

using Spire.Doc;
using Spire.Doc.Documents;
using Spire.Doc.Fields;
using System.Drawing;

namespace ChangeTextFont
{
    class Program
    {
        static void Main(string[] args)
        {

            // Create a new document object
            Document document = new Document();

            // Load an existing Word file
            document.LoadFromFile("C:\\Users\\Administrator\\Desktop\\input.docx");

            // Get a specific section
            Section section = document.Sections[0];

            // Get a specific paragraph
            Paragraph paragraph = section.Paragraphs[2];

            // Iterate through the child objects in the paragraph
            for (int i = 0; i < paragraph.ChildObjects.Count; i++)
            {

                // Determine if a child object is text range
                if (paragraph.ChildObjects[i] is TextRange)
                {
                    // Get a specific text range
                    TextRange textRange = (TextRange)paragraph.ChildObjects[i];

                    // Reset font name for it
                    textRange.CharacterFormat.FontName = "Corbel Light";

                    // Reset font size for it
                    textRange.CharacterFormat.FontSize = 11;

                    // Reset text color for it
                    textRange.CharacterFormat.TextColor = Color.Blue;

                    // Apply italic to the text range 
                    textRange.CharacterFormat.Italic = true;
                }
            }

            // Save the document to a different Word file
            document.SaveToFile("ChangeFont.docx", FileFormat.Docx);

            // Dispose resource
            document.Dispose();
        }
    }
}

using Spire.Doc;
using Spire.Doc.Documents;

namespace AddNewElementsToWord
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create a new document object
            Document document = new Document();

            // Load an existing Word file
            document.LoadFromFile("C:\\Users\\Administrator\\Desktop\\input.docx");

            // Get the last section
            Section lastSection = document.LastSection;

            // Add a paragraph to the section
            Paragraph paragraph = lastSection.AddParagraph();

            // Add text to the paragraph
            paragraph.AppendText("This text and the image shown below are added programmatically using C# and Spire.Doc for .NET.");

            // Add an image to the paragraph
            paragraph.AppendPicture("C:\\Users\\Administrator\\Desktop\\logo.png");

            // Create a paragraph style
            ParagraphStyle style = new ParagraphStyle(document);
            style.Name = "FontStyle";
            style.CharacterFormat.FontName = "Times New Roman";
            style.CharacterFormat.FontSize = 12;
            document.Styles.Add(style);

            // Apply the style to the paragraph
            paragraph.ApplyStyle(style.Name);

            // Save the document to a different Word file
            document.SaveToFile("AddNewElements.docx", FileFormat.Docx);

            // Dispose resource
            document.Dispose();
        }
    }
}

using Spire.Doc;

namespace RemoveParagraphs
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create a new document object
            Document document = new Document();

            // Load an existing Word file
            document.LoadFromFile("C:\\Users\\Administrator\\Desktop\\input.docx");

            // Get a specific section
            Section section = document.Sections[0];

            // Remove a specific paragraph
            section.Paragraphs.RemoveAt(0);

            // Save the document to a different Word file
            document.SaveToFile("RemoveParagraph.docx", FileFormat.Docx);

            // Dispose resource
            document.Dispose();
        }
    }
}

PM> Install-Package Spire.Doc

using Spire.Doc;
using Spire.Doc.Documents;
using Spire.Doc.Fields;
using System.Drawing;

namespace CreateSimpleWordDocument
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create a Document object
            Document document = new Document();

            // Add a section
            Section section = document.AddSection();

            // Set page margins
            section.PageSetup.Margins.All = 60f;

            // Add a title paragraph
            Paragraph title_para = section.AddParagraph();
            TextRange textRange = title_para.AppendText("This Is Title");
            title_para.ApplyStyle(BuiltinStyle.Title);
            textRange.CharacterFormat.FontName = "Times Now Roman";

            // Add a couple of heading paragraphs
            Paragraph heading_one = section.AddParagraph();
            textRange = heading_one.AppendText("Heading 1");
            heading_one.ApplyStyle(BuiltinStyle.Heading1);
            textRange.CharacterFormat.FontName = "Times Now Roman";

            Paragraph heading_two = section.AddParagraph();
            textRange = heading_two.AppendText("Heading 2");
            heading_two.ApplyStyle(BuiltinStyle.Heading2);
            textRange.CharacterFormat.FontName = "Times Now Roman";

            Paragraph heading_three = section.AddParagraph();
            textRange = heading_three.AppendText("Heading 3");
            heading_three.ApplyStyle(BuiltinStyle.Heading3);
            textRange.CharacterFormat.FontName = "Times Now Roman";

            Paragraph heading_four = section.AddParagraph();
            textRange = heading_four.AppendText("Heading 4");
            heading_four.ApplyStyle(BuiltinStyle.Heading4);
            textRange.CharacterFormat.FontName = "Times Now Roman";

            // Add a normal paragraph
            Paragraph normal_para = section.AddParagraph();
            normal_para.AppendText("This is a sample paragraph.");

            // Create a paragraph style
            ParagraphStyle style = new ParagraphStyle(document);
            style.Name = "paraStyle";
            style.CharacterFormat.FontName = "Times New Roman";
            style.CharacterFormat.FontSize = 13f;
            style.CharacterFormat.TextColor = Color.Brown;
            document.Styles.Add(style);

            // Apply the custom style to the paragraph
            normal_para.ApplyStyle("paraStyle");

            // Save the document
            document.SaveToFile("AddText.docx", FileFormat.Docx);

            // Dispose resources
            document.Dispose();
        }
    }
}

using Spire.Doc;
using Spire.Doc.Documents;
using System.Drawing;

namespace AddImage
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create a Document object
            Document document = new Document();

            // Add a section
            Section section = document.AddSection();

            // Set page margins
            section.PageSetup.Margins.All = 60f;

            // Add a paragraph
            Paragraph image_para = section.AddParagraph();

            // Append an image
            image_para.AppendPicture(Image.FromFile("C:\\Users\\Administrator\\Desktop\\logo.png"));
      
            //Save the document
            document.SaveToFile("AddImage.docx", FileFormat.Docx);

            // Dispose resources
            document.Dispose();
        }
    }
}

using Spire.Doc;
using Spire.Doc.Documents;

namespace AddTable
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create a Document object
            Document document = new Document();

            // Add a section
            Section section = document.AddSection();

            // Set page margins
            section.PageSetup.Margins.All = 60f;

            // Define table data as a 2D array
            string[,] data = new string[4, 4]
            {
                { "Product", "Unit Price", "Quantity", "Sub Total" },
                { "A", "$29", "120", "$3,480" },
                { "B", "$35", "110", "$3,850" },
                { "C", "$68", "140", "$9,520" }
            };

            // Add a table
            Table table = section.AddTable(showBorder: true);

            // Set row number and column number
            table.ResetCells(data.GetLength(0), data.GetLength(1));

            // Write data to cells
            for (int r = 0; r < data.GetLength(0); r++)
            {
                TableRow row = table.Rows[r];
                row.Height = 20;
                row.HeightType = TableRowHeightType.Exactly;

                for (int c = 0; c < data.GetLength(1); c++)
                {
                    var cell = row.Cells[c];
                    cell.CellFormat.VerticalAlignment = VerticalAlignment.Middle;
                    var textRange = cell.AddParagraph().AppendText(data[r, c]);
                    textRange.CharacterFormat.FontName = "Times New Roman";
                    textRange.CharacterFormat.FontSize = 14;
                }
            }

            // Automatically adjusts the column widths of a table to fit its contents
            table.AutoFit(AutoFitBehaviorType.AutoFitToContents);

            // Save the document to file
            document.SaveToFile("AddTable.docx", FileFormat.Docx);

            // Dispose resources
            document.Dispose();
        }
    }
}

// Create a Document object
Document document = new Document();

// Add a section
Section section = document.AddSection();

// Set page margins
section.PageSetup.Margins.All = 60f;

// Create a bulleted list style
ListStyle listStyle = document.Styles.Add(ListType.Bulleted, "bulletedList");
ListLevelCollection Levels = listStyle.ListRef.Levels;
Levels[0].BulletCharacter = "\x00B7";
Levels[0].CharacterFormat.FontName = "Symbol";
Levels[0].TextPosition = 20;

// Add a paragraph
Paragraph paragraph = section.AddParagraph();
TextRange textRange = paragraph.AppendText("Fruits:");
paragraph.Format.AfterSpacing = 5f;
textRange.CharacterFormat.FontName = "Times New Roman";
textRange.CharacterFormat.FontSize = 14;

// Add another five paragraphs as bulleted list items
foreach (var fruit in new[] { "Apple", "Banana", "Watermelon", "Mango" })
{
    paragraph = section.AddParagraph();
    textRange = paragraph.AppendText(fruit);
    paragraph.ListFormat.ApplyStyle(listStyle);
    paragraph.ListFormat.ListLevelNumber = 0;
    textRange.CharacterFormat.FontName = "Times New Roman";
    textRange.CharacterFormat.FontSize = 14;
}

// Save the document to file
document.SaveToFile("AddList.docx", FileFormat.Docx);

// Dispose resources
document.Dispose();