PM> Install-Package Spire.XLS

using Spire.Xls;
using Spire.Xls.Core;
using System.Drawing;

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

            //Set left, right, top, bottom and diagonal up borders for cell B2
            CellRange range = sheet.Range["B2"];
            IBorder leftBorder = range.Borders[BordersLineType.EdgeLeft];
            leftBorder.LineStyle = LineStyleType.MediumDashDotDot;
            leftBorder.Color = Color.Red;
            IBorder rightBorder = range.Borders[BordersLineType.EdgeRight];
            rightBorder.LineStyle = LineStyleType.MediumDashed;
            rightBorder.Color = Color.Red;
            IBorder topBorder = range.Borders[BordersLineType.EdgeTop];
            topBorder.LineStyle = LineStyleType.Medium;
            topBorder.Color = Color.Red;
            IBorder bottomBorder = range.Borders[BordersLineType.EdgeBottom];
            bottomBorder.LineStyle = LineStyleType.Medium;
            bottomBorder.Color = Color.Red;
            IBorder diagonalUpBorder = range.Borders[BordersLineType.DiagonalUp];
            diagonalUpBorder.LineStyle = LineStyleType.Thin;
            diagonalUpBorder.Color = Color.Red;

            //Set diagonal borders for cell C4
            range = sheet.Range["C4"];
            diagonalUpBorder = range.Borders[BordersLineType.DiagonalUp];
            diagonalUpBorder.LineStyle = LineStyleType.Double;
            diagonalUpBorder.Color = Color.Blue;
            IBorder diagonalDownBorder = range.Borders[BordersLineType.DiagonalDown];
            diagonalDownBorder.LineStyle = LineStyleType.Double;
            diagonalDownBorder.Color = Color.Blue;

            //Set outside borders for cell D6
            range = sheet.Range["D6"];
            range.BorderAround(LineStyleType.Double, Color.Green);

            //Set inside borders for cell range E8:F10
            range = sheet.Range["E8:F10"];
            range.BorderInside(LineStyleType.MediumDashed, Color.DarkGray);

            //Set inside and outside borders for cell range F12:G14
            range = sheet.Range["F12:G14"];
            range.BorderInside(LineStyleType.MediumDashed, Color.Pink);
            range.BorderAround(LineStyleType.Medium, Color.Magenta);

            //Set borders for cell range G16:H18
            range = sheet.Range["G16:H18"];
            range.Borders.LineStyle = LineStyleType.Thick;
            range.Borders.Color = Color.Cyan;
            //Set line style and line color of diagonal borders for cell range G16:H18
            diagonalUpBorder = range.Borders[BordersLineType.DiagonalUp];
            diagonalUpBorder.LineStyle = LineStyleType.Dotted;
            diagonalUpBorder.Color = Color.DarkGray;
            diagonalDownBorder = range.Borders[BordersLineType.DiagonalDown];
            diagonalDownBorder.LineStyle = LineStyleType.Dotted;
            diagonalDownBorder.Color = Color.DarkGray;

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

Imports Spire.Xls
Imports Spire.Xls.Core
Imports System.Drawing

Namespace AddCellBorders
    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)

            'Set left, right, top, bottom and diagonal up borders for cell B2
            Dim range As CellRange = sheet.Range("B2")
            Dim leftBorder As IBorder = range.Borders(BordersLineType.EdgeLeft)
            leftBorder.LineStyle = LineStyleType.MediumDashDotDot
            leftBorder.Color = Color.Red
            Dim rightBorder As IBorder = range.Borders(BordersLineType.EdgeRight)
            rightBorder.LineStyle = LineStyleType.MediumDashed
            rightBorder.Color = Color.Red
            Dim topBorder As IBorder = range.Borders(BordersLineType.EdgeTop)
            topBorder.LineStyle = LineStyleType.Medium
            topBorder.Color = Color.Red
            Dim bottomBorder As IBorder = range.Borders(BordersLineType.EdgeBottom)
            bottomBorder.LineStyle = LineStyleType.Medium
            bottomBorder.Color = Color.Red
            Dim diagonalUpBorder As IBorder = range.Borders(BordersLineType.DiagonalUp)
            diagonalUpBorder.LineStyle = LineStyleType.Thin
            diagonalUpBorder.Color = Color.Red

            'Set diagonal borders for cell C4
            range = sheet.Range("C4")
            diagonalUpBorder = range.Borders(BordersLineType.DiagonalUp)
            diagonalUpBorder.LineStyle = LineStyleType.[Double]
            diagonalUpBorder.Color = Color.Blue
            Dim diagonalDownBorder As IBorder = range.Borders(BordersLineType.DiagonalDown)
            diagonalDownBorder.LineStyle = LineStyleType.[Double]
            diagonalDownBorder.Color = Color.Blue

            'Set outside borders for cell D6
            range = sheet.Range("D6")
            range.BorderAround(LineStyleType.[Double], Color.Green)

            'Set inside borders for cell range E8:F10
            range = sheet.Range("E8:F10")
            range.BorderInside(LineStyleType.MediumDashed, Color.DarkGray)

            'Set inside and outside borders for cell range F12:G14
            range = sheet.Range("F12:G14")
            range.BorderInside(LineStyleType.MediumDashed, Color.Pink)
            range.BorderAround(LineStyleType.Medium, Color.Magenta)

            'Set borders for cell range G16:H18
            range = sheet.Range("G16:H18")
            range.Borders.LineStyle = LineStyleType.Thick
            range.Borders.Color = Color.Cyan
            'Set line style and line color of diagonal borders for cell range G16:H18
            diagonalUpBorder = range.Borders(BordersLineType.DiagonalUp)
            diagonalUpBorder.LineStyle = LineStyleType.Dotted
            diagonalUpBorder.Color = Color.DarkGray
            diagonalDownBorder = range.Borders(BordersLineType.DiagonalDown)
            diagonalDownBorder.LineStyle = LineStyleType.Dotted
            diagonalDownBorder.Color = Color.DarkGray

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

using Spire.Xls;

namespace RemoveCellBorders
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create a Workbook instance
            Workbook workbook = new Workbook();
            //Load an Excel file
            workbook.LoadFromFile("AddBorders.xlsx");

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

            //Remove borders of cell range G16:H18
            CellRange range = sheet.Range["G16:H18"];
            range.Borders.LineStyle = LineStyleType.None;

            workbook.SaveToFile("RemoveBorders.xlsx", ExcelVersion.Version2013);
        }
    }
}

Imports Spire.Xls

Namespace RemoveCellBorders
    Friend Class Program
        Private Shared Sub Main(ByVal args As String())
            'Create a Workbook instance
            Dim workbook As Workbook = New Workbook()
            'Load an Excel file
            workbook.LoadFromFile("AddBorders.xlsx")

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

            'Remove borders of cell range G16:H18
            Dim range As CellRange = sheet.Range("G16:H18")
            range.Borders.LineStyle = LineStyleType.None

            workbook.SaveToFile("RemoveBorders.xlsx", ExcelVersion.Version2013)
        End Sub
    End Class
End Namespace

PM> Install-Package Spire.XLS

using Spire.Xls;
using System.Drawing;

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

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

            //Set font name
            int row = 1;
            sheet.Range[row, 1].Value = "Font Name";
            sheet.Range[row, 2].Value = "Arial Black";
            sheet.Range[row, 2].Style.Font.FontName = "Arial Black";

            //Set font size
            sheet.Range[row += 2, 1].Value = "Font Size";
            sheet.Range[row, 2].Value = "15";
            sheet.Range[row, 2].Style.Font.Size = 15;

            //Set font color 
            sheet.Range[row += 2, 1].Value = "Font Color";
            sheet.Range[row, 2].Value = "Red";
            sheet.Range[row, 2].Style.Font.Color = Color.Red;

            //Make text bold
            sheet.Range[row += 2, 1].Value = "Bold";
            sheet.Range[row, 2].Value = "Bold";
            sheet.Range[row, 2].Style.Font.IsBold = true;

            //Make text italic 
            sheet.Range[row += 2, 1].Value = "Italic";
            sheet.Range[row, 2].Value = "Italic";
            sheet.Range[row, 2].Style.Font.IsItalic = true;

            //Underline text
            sheet.Range[row += 2, 1].Value = "Underline";
            sheet.Range[row, 2].Value = "Underline";
            sheet.Range[row, 2].Style.Font.Underline = FontUnderlineType.Single;

            //Strikethrough text 
            sheet.Range[row += 2, 1].Value = "Strikethrough ";
            sheet.Range[row, 2].Value = "Strikethrough ";
            sheet.Range[row, 2].Style.Font.IsStrikethrough = true;

            //Auto fit column width
            sheet.AllocatedRange.AutoFitColumns();
       
            //Save the workbook to an Excel file
            workbook.SaveToFile("ApplySingleFontInCell.xlsx", ExcelVersion.Version2016);
        }
    }
}

Imports Spire.Xls
Imports System.Drawing
 
Namespace ApplySingleFontInCellRange
    Class Program
        Shared  Sub Main(ByVal args() As String)
            'Create a Workbook object 
            Dim workbook As Workbook =  New Workbook() 
 
            'Get the first worksheet
            Dim sheet As Worksheet =  workbook.Worksheets(0) 
 
            'Set font name
            Dim row As Integer =  1 
            sheet.Range(row, 1).Value = "Font Name"
            sheet.Range(row, 2).Value = "Arial Black"
            sheet.Range(row, 2).Style.Font.FontName = "Arial Black"
 
            'Set font size
            sheet.Range(row += 2, 1).Value = "Font Size"
            sheet.Range(row, 2).Value = "15"
            sheet.Range(row, 2).Style.Font.Size = 15
 
            'Set font color 
            sheet.Range(row += 2, 1).Value = "Font Color"
            sheet.Range(row, 2).Value = "Red"
            sheet.Range(row, 2).Style.Font.Color = Color.Red
 
            'Make text bold
            sheet.Range(row += 2, 1).Value = "Bold"
            sheet.Range(row, 2).Value = "Bold"
            sheet.Range(row, 2).Style.Font.IsBold = True
 
            'Make text italic 
            sheet.Range(row += 2, 1).Value = "Italic"
            sheet.Range(row, 2).Value = "Italic"
            sheet.Range(row, 2).Style.Font.IsItalic = True
 
            'Underline text
            sheet.Range(row += 2, 1).Value = "Underline"
            sheet.Range(row, 2).Value = "Underline"
            sheet.Range(row, 2).Style.Font.Underline = FontUnderlineType.Single
 
            'Strikethrough text 
            sheet.Range(row += 2, 1).Value = "Strikethrough "
            sheet.Range(row, 2).Value = "Strikethrough "
            sheet.Range(row, 2).Style.Font.IsStrikethrough = True
 
            'Auto fit column width
            sheet.AllocatedRange.AutoFitColumns()
 
            'Save the workbook to an Excel file
            workbook.SaveToFile("ApplySingleFontInCell.xlsx", ExcelVersion.Version2016)
        End Sub
    End Class
End Namespace

using Spire.Xls;

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

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

            //Create a font
            ExcelFont font1 = workbook.CreateFont();
            font1.FontName = "Arial Black";
            font1.KnownColor = ExcelColors.LightBlue;
            font1.IsBold = true;
            font1.Size = 13;

            //Create another font
            ExcelFont font2 = workbook.CreateFont();
            font2.KnownColor = ExcelColors.Red;
            font2.IsBold = true;
            font2.IsItalic = true;
            font2.FontName = "Algerian";
            font2.Size = 15;

            //Returns a RichText object from a specified cell
            RichText richText = sheet.Range["A1"].RichText;

            //Set the text of RichText object
            richText.Text = "Buy One, Get One Free";

            //Apply the first font to specified range of characters
            richText.SetFont(0, 16, font1);

            //Apply the second font to specified range of characters
            richText.SetFont(17, 21, font2);

            //Set column width
            sheet.Columns[0].ColumnWidth = 33;

            //Save the workbook to an Excel file
            workbook.SaveToFile("ApplyMultipleFonts.xlsx", ExcelVersion.Version2016);
        }
    }
}

Imports Spire.Xls
 
Namespace ApplyMultipleFontsInACell
    Class Program
        Shared  Sub Main(ByVal args() As String)
            'Create a Workbook object
            Dim workbook As Workbook =  New Workbook() 
 
            'Get the first worksheet
            Dim sheet As Worksheet =  workbook.Worksheets(0) 
 
            'Create a font
            Dim font1 As ExcelFont =  workbook.CreateFont() 
            font1.FontName = "Arial Black"
            font1.KnownColor = ExcelColors.LightBlue
            font1.IsBold = True
            font1.Size = 13
 
            'Create another font
            Dim font2 As ExcelFont =  workbook.CreateFont() 
            font2.KnownColor = ExcelColors.Red
            font2.IsBold = True
            font2.IsItalic = True
            font2.FontName = "Algerian"
            font2.Size = 15
 
            'Returns a RichText object from a specified cell
            Dim richText As RichText =  sheet.Range("A1").RichText 
 
            'Set the text of RichText object
            richText.Text = "Buy One, Get One Free"
 
            'Apply the first font to specified range of characters
            richText.SetFont(0, 16, font1)
 
            'Apply the second font to specified range of characters
            richText.SetFont(17, 21, font2)
 
            'Set column width
            sheet.Columns(0).ColumnWidth = 33
 
            'Save the workbook to an Excel file
            workbook.SaveToFile("ApplyMultipleFonts.xlsx", ExcelVersion.Version2016)
        End Sub
    End Class
End Namespace

using Spire.Xls;
using System.Drawing;

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

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

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

            //Create a CellStyle object
            CellStyle fontStyle = workbook.Styles.Add("headerFontStyle");

            //Set the font color, size and style
            fontStyle.Font.Color = Color.White;
            fontStyle.Font.IsBold = true;
            fontStyle.Font.Size = 12;
            fontStyle.HorizontalAlignment = HorizontalAlignType.Center;

            //Create a CellStyleFlag object, setting the FontColor, FontBold, FontSize and HorizontalAlignment properties to true
            CellStyleFlag flag = new CellStyleFlag();
            flag.FontColor = true;
            flag.FontBold = true;
            flag.FontSize = true;
            flag.HorizontalAlignment = true;

            //Apply the cell style to header row 
            sheet.Range[1, 1, 1, 8].ApplyStyle(fontStyle, flag);

            //Apply the cell style to the whole worksheet
            //sheet.ApplyStyle(fontStyle);

            //Save the workbook to another Excel file
            workbook.SaveToFile("ApplyFontToCellRange.xlsx", ExcelVersion.Version2016);
        }
    }
}

Imports Spire.Xls
Imports System.Drawing
 
Namespace ApplyFontToCellRange
    Class Program
        Shared  Sub Main(ByVal args() As String)
            'Create a Workbook object
            Dim workbook As Workbook =  New Workbook() 
 
            'Load a sample Excel file
            workbook.LoadFromFile("C:\Users\Administrator\Desktop\sample.xlsx")
 
            'Get the first worksheet
            Dim sheet As Worksheet =  workbook.Worksheets(0) 
 
            'Create a CellStyle object
            Dim fontStyle As CellStyle =  workbook.Styles.Add("headerFontStyle") 
 
            'Set the font color, size and style
            fontStyle.Font.Color = Color.White
            fontStyle.Font.IsBold = True
            fontStyle.Font.Size = 12
            fontStyle.HorizontalAlignment = HorizontalAlignType.Center
 
            'Create a CellStyleFlag object, setting the FontColor, FontBold, FontSize and HorizontalAlignment properties to true
            Dim flag As CellStyleFlag =  New CellStyleFlag() 
            flag.FontColor = True
            flag.FontBold = True
            flag.FontSize = True
            flag.HorizontalAlignment = True
 
            'Apply the cell style to header row 
            sheet.Range(1, 1, 1, 8).ApplyStyle(fontStyle, flag)
 
            'Apply the cell style to the whole worksheet
            'sheet.ApplyStyle(fontStyle);
 
            'Save the workbook to another Excel file
            workbook.SaveToFile("ApplyFontToCellRange.xlsx", ExcelVersion.Version2016)
        End Sub
    End Class
End Namespace

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

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 System.Drawing;
using Spire.Doc;
using Spire.Doc.Documents;
using Spire.Doc.Fields;

namespace WordImage
{
    class ImageinWord
    {
        static void Main(string[] args)
        {
            //Create a Document instance
            Document document = new Document();

            //Load a sample Word document
            document.LoadFromFile("input.docx");

            //Get the first section 
            Section section = document.Sections[0];

            //Get two specified paragraphs
            Paragraph para1 = section.Paragraphs[5];
            Paragraph para2 = section.Paragraphs[9];

            //Insert images in the specified paragraphs
            DocPicture Pic1 = para1.AppendPicture(Image.FromFile(@"C:\Users\Administrator\Desktop\pic1.jpg"));
            DocPicture Pic2 = para2.AppendPicture(Image.FromFile(@"C:\Users\Administrator\Desktop\pic2.png"));

            //Set wrapping styles to Square and Inline respectively
            Pic1.TextWrappingStyle = TextWrappingStyle.Square;
            Pic2.TextWrappingStyle = TextWrappingStyle.Inline;
 
            //Save the document to file
            document.SaveToFile("InsertImage.docx", FileFormat.Docx);
        }
    }
}

Imports System.Drawing
Imports Spire.Doc
Imports Spire.Doc.Documents
Imports Spire.Doc.Fields

Namespace WordImage
    Class ImageinWord
        Private Shared Sub Main(ByVal args As String())

            'Create a Document instance
            Dim document As Document = New Document()

            'Load a sample Word document
            document.LoadFromFile("sample.docx")

            'Get the first section 
            Dim section As Section = document.Sections(0)

            'Get two specified paragraphs
            Dim para1 As Paragraph = section.Paragraphs(5)
            Dim para2 As Paragraph = section.Paragraphs(9)

            'Insert images in the specified paragraphs 
            Dim Pic1 As DocPicture = para1.AppendPicture(Image.FromFile("C:\Users\Administrator\Desktop\pic1.jpg"))
            Dim Pic2 As DocPicture = para2.AppendPicture(Image.FromFile("C:\Users\Administrator\Desktop\pic2.png"))

            ‘Set wrapping styles to Square and Inline respectively
            Pic1.TextWrappingStyle = TextWrappingStyle.Square
            Pic2.TextWrappingStyle = TextWrappingStyle.Inline

            'Save the document to file
            document.SaveToFile("InsertImage.docx", FileFormat.Docx)
        End Sub
    End Class
End Namespace

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

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

            //Load a sample Word document
            document.LoadFromFile("input.docx");

            //Get the first section 
            Section section = document.Sections[0];

            //Load an image and insert it to the document
            DocPicture picture = section.Paragraphs[0].AppendPicture(Image.FromFile(@"C:\Users\Administrator\Desktop\pic.jpg"));

            //Set the position of the image 
            picture.HorizontalPosition = 90.0F;
            picture.VerticalPosition = 50.0F;

            //Set the size of the image
            picture.Width = 150;
            picture.Height = 150;

            //Set the wrapping style to Behind
            picture.TextWrappingStyle = TextWrappingStyle.Behind;

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

Imports Spire.Doc
Imports Spire.Doc.Documents
Imports Spire.Doc.Fields

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

            'Create a Document instance
            Dim document As Document = New Document()

            'Load a sample Word document
            document.LoadFromFile("input.docx")

            'Get the first section 
            Dim section As Section = document.Sections(0)

            'Load an image and insert it to the document
            Dim picture As DocPicture = section.Paragraphs(0).AppendPicture(Image.FromFile("C:\Users\Administrator\Desktop\pic.jpg"))

            'Set the position of the image 
            picture.HorizontalPosition = 90.0F
            picture.VerticalPosition = 50.0F

            'Set the size of the image
            picture.Width = 150
            picture.Height = 150

            ' Set the wrapping style to Behind
            picture.TextWrappingStyle = TextWrappingStyle.Behind

            ' Save the document to file
            document.SaveToFile("Insert.docx", FileFormat.Docx)
        End Sub
    End Class
End Namespace