PM> Install-Package Spire.PDF

using System;
using System.Drawing;
using System.Drawing.Imaging;
using Spire.Pdf;

namespace SavePdfAsTiff
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create a PdfDocument object
            PdfDocument pdf = new PdfDocument();

            //Load a PDF document
            pdf.LoadFromFile("Report.pdf");

            //Convert PDF pages to images
            Image[] images = SaveAsImage(pdf);

            //Combine the images and save them as a multi-page TIFF file
            JoinTiffImages(images, "result.tiff", EncoderValue.CompressionLZW);
        }

        private static Image[] SaveAsImage(PdfDocument document)
        {
            //Create a new image array
            Image[] images = new Image[document.Pages.Count];

            //Iterate through all pages in the document
            for (int i = 0; i < document.Pages.Count; i++)
            {
                //Convert a specific page to an image
                images[i] = document.SaveAsImage(i);
            }
            return images;
        }

        private static ImageCodecInfo GetEncoderInfo(string mimeType)
        {
            //Get the image encoders
            ImageCodecInfo[] encoders = ImageCodecInfo.GetImageEncoders();
            for (int j = 0; j < encoders.Length; j++)
            {
                //Find the encoder that matches the specified MIME type
                if (encoders[j].MimeType == mimeType)
                    return encoders[j];
            }
            throw new Exception(mimeType + " mime type not found in ImageCodecInfo");
        }

        public static void JoinTiffImages(Image[] images, string outFile, EncoderValue compressEncoder)
        {
            //Set the encoder parameters 
            Encoder enc = Encoder.SaveFlag;
            EncoderParameters ep = new EncoderParameters(2);
            ep.Param[0] = new EncoderParameter(enc, (long)EncoderValue.MultiFrame);
            ep.Param[1] = new EncoderParameter(Encoder.Compression, (long)compressEncoder);

            //Get the first image
            Image pages = images[0];
            //Initialize a frame
            int frame = 0;
            //Get an ImageCodecInfo object for processing TIFF image codec information
            ImageCodecInfo info = GetEncoderInfo("image/tiff");

            //Iterate through each Image
            foreach (Image img in images)
            {
                //If it's the first frame, save it to the output file with specified encoder parameters
                if (frame == 0)
                {
                    pages = img;
                    pages.Save(outFile, info, ep);
                }

                else
                {
                    //Save the intermediate frames
                    ep.Param[0] = new EncoderParameter(enc, (long)EncoderValue.FrameDimensionPage);

                    pages.SaveAdd(img, ep);
                }
                //If it's the last frame, flush the encoder parameters and close the file
                if (frame == images.Length - 1)
                {
                    ep.Param[0] = new EncoderParameter(enc, (long)EncoderValue.Flush);
                    pages.SaveAdd(ep);
                }
                frame++;
            }
        }
    }
}

using System;
using System.Drawing;
using System.Drawing.Imaging;
using System.IO;
using Spire.Pdf;
using Spire.Pdf.Graphics;

namespace TiffToPdf
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create a PdfDocument object
            PdfDocument pdf = new PdfDocument();

            //Load a TIFF image
            Image tiffImage = Image.FromFile("result.tiff");

            //Split the Tiff image into separate images
            Image[] images = SplitTiffImage(tiffImage);

            //Iterate through the images
            for (int i = 0; i < images.Length; i++)
            {
                //Convert a specified image into a PDF image
                PdfImage pdfImg = PdfImage.FromImage(images[i]);

                //Get image width and height
                float width = pdfImg.Width;
                float height = pdfImg.Height;

                //Add a page with the same size as the image
                SizeF size = new SizeF(width, height);
                PdfPageBase page = pdf.Pages.Add(size);

                //Draw the image at a specified location on the page
                page.Canvas.DrawImage(pdfImg, 0, 0, width, height);
            }

            //Save the result file
            pdf.SaveToFile("TiffToPdf.pdf");
        }

        public static Image[] SplitTiffImage(Image tiffImage)
        {
            //Get the number of frames in the Tiff image
            int frameCount = tiffImage.GetFrameCount(FrameDimension.Page);
            //Create an image array to store the split tiff images
            Image[] images = new Image[frameCount];
            //Gets the GUID of the first frame dimension
            Guid objGuid = tiffImage.FrameDimensionsList[0];
            //Create a FrameDimension object
            FrameDimension objDimension = new FrameDimension(objGuid);

            //Iterate through each frame
            for (int i = 0; i < frameCount; i++)
            {
                //Select a specified frame
                tiffImage.SelectActiveFrame(objDimension, i);
                //Save the frame in TIFF format to a memory stream
                MemoryStream ms = new MemoryStream();
                tiffImage.Save(ms, ImageFormat.Tiff);
                //Load an image from memory stream
                images[i] = Image.FromStream(ms);
            }
            return images;
        }
    }
}

PM> Install-Package Spire.XLS

using Spire.Xls;

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

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

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

            //Get the PageSetup object of the first worksheet
            PageSetup pageSetup = worksheet.PageSetup;

            //Set page margins
            pageSetup.TopMargin = 0.3;
            pageSetup.BottomMargin = 0.3;
            pageSetup.LeftMargin = 0.3;
            pageSetup.RightMargin = 0.3;

            //Specify print area
            pageSetup.PrintArea = "A1:D10";

            //Specify title row
            pageSetup.PrintTitleRows = "$1:$2";

            //Allow to print with row/column headings
            pageSetup.IsPrintHeadings = true;

            //Allow to print with gridlines
            pageSetup.IsPrintGridlines = true;

            //Allow to print comments as displayed on worksheet
            pageSetup.PrintComments = PrintCommentType.InPlace;

            //Set printing quality (dpi)
            pageSetup.PrintQuality = 300;

            //Allow to print worksheet in black & white mode
            pageSetup.BlackAndWhite = true;

            //Set the printing order
            pageSetup.Order = OrderType.OverThenDown;

            //Fit worksheet on one page
            pageSetup.IsFitToPage = true;

            //Save the workbook
            workbook.SaveToFile("PagePrintOptions.xlsx", ExcelVersion.Version2016);
        }
    }
}

Imports Spire.Xls
 
Namespace PrintOptions
    Class Program
        Shared  Sub Main(ByVal args() As String)
            'Create a workbook
            Dim workbook As Workbook =  New Workbook() 
 
            'Load an Excel document 
            workbook.LoadFromFile("C:\Users\Administrator\Desktop\sample.xlsx")
 
            'Get the first worksheet
            Dim worksheet As Worksheet =  workbook.Worksheets(0) 
 
            'Get the PageSetup object of the first worksheet
            Dim pageSetup As PageSetup =  worksheet.PageSetup 
 
            'Set page margins
            pageSetup.TopMargin = 0.3
            pageSetup.BottomMargin = 0.3
            pageSetup.LeftMargin = 0.3
            pageSetup.RightMargin = 0.3
 
            'Specify print area
            pageSetup.PrintArea = "A1:D10"
 
            'Specify title row
            pageSetup.PrintTitleRows = "$1:$2"
 
            'Allow to print with row/column headings
            pageSetup.IsPrintHeadings = True
 
            'Allow to print with gridlines
            pageSetup.IsPrintGridlines = True
 
            'Allow to print comments as displayed on worksheet
            pageSetup.PrintComments = PrintCommentType.InPlace
 
            'Set printing quality (dpi)
            pageSetup.PrintQuality = 300
 
            'Allow to print worksheet in black & white mode
            pageSetup.BlackAndWhite = True
 
            'Set the printing order
            pageSetup.Order = OrderType.OverThenDown
 
            'Fit worksheet on one page
            pageSetup.IsFitToPage = True
 
            'Save the workbook
            workbook.SaveToFile("PagePrintOptions.xlsx", ExcelVersion.Version2016)
        End Sub
    End Class
End Namespace

using System;
using Spire.Xls;
using System.Drawing.Printing;
using System.Windows.Forms;

namespace PrintExcelUsingPrintDialog
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            //Create a Workbook object
            Workbook workbook = new Workbook();

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

            //Fit worksheet on one page    
            PageSetup pageSetup = workbook.Worksheets[0].PageSetup;
            pageSetup.IsFitToPage = true;

            //Create a PrintDialog object
            PrintDialog dialog = new PrintDialog();

            //Specify printer settings 
            dialog.AllowCurrentPage = true;
            dialog.AllowSomePages = true;
            dialog.AllowSelection = true;
            dialog.UseEXDialog = true;
            dialog.PrinterSettings.Duplex = Duplex.Simplex;

            //Apply the dialog to workbook 
            workbook.PrintDialog = dialog;

            //Create a PrintDocument object based on the workbook
            PrintDocument printDocument = workbook.PrintDocument;

            //Invoke the print dialog
            if (dialog.ShowDialog() == DialogResult.OK)
            {
                printDocument.Print();
            }
        }
    }
}

Imports System
Imports Spire.Xls
Imports System.Drawing.Printing
Imports System.Windows.Forms
 
Namespace PrintExcelUsingPrintDialog
    Public partial Class Form1
	 Inherits Form
        Public  Sub New()
            InitializeComponent()
        End Sub
 
        Private  Sub button1_Click(ByVal sender As Object, ByVal e As EventArgs)
            'Create a Workbook object
            Dim workbook As Workbook =  New Workbook() 
 
            'Load an Excel file 
            workbook.LoadFromFile("C:\Users\Administrator\Desktop\sample.xlsx")
 
            'Fit worksheet on one page    
            Dim pageSetup As PageSetup =  workbook.Worksheets(0).PageSetup 
            pageSetup.IsFitToPage = True
 
            'Create a PrintDialog object
            Dim dialog As PrintDialog =  New PrintDialog() 
 
            'Specify printer settings 
            dialog.AllowCurrentPage = True
            dialog.AllowSomePages = True
            dialog.AllowSelection = True
            dialog.UseEXDialog = True
            dialog.PrinterSettings.Duplex = Duplex.Simplex
 
            'Apply the dialog to workbook 
            workbook.PrintDialog = dialog
 
            'Create a PrintDocument object based on the workbook
            Dim printDocument As PrintDocument =  workbook.PrintDocument 
 
            'Invoke the print dialog
            If dialog.ShowDialog() = DialogResult.OK Then
                printDocument.Print()
            End If
        End Sub
    End Class
End Namespace

using Spire.Xls;
using System.Drawing.Printing;

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

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

            //Fit worksheet on one page    
            PageSetup pageSetup = workbook.Worksheets[0].PageSetup;
            pageSetup.IsFitToPage = true;

            //Set the print controller to StandardPrintController, which will prevent print process from showing
            workbook.PrintDocument.PrintController = new StandardPrintController();

            //Get PrinterSettings from the workbook
            PrinterSettings settings = workbook.PrintDocument.PrinterSettings;

            //Specify printer name, duplex mode and print pages
            settings.PrinterName = "HP LaserJet P1007"; 
            settings.Duplex = Duplex.Simplex;
            settings.FromPage = 1;
            settings.ToPage = 3;         

            //Print the workbook
            workbook.PrintDocument.Print();
        }
    }
}

Imports Spire.Xls
Imports System.Drawing.Printing
 
Namespace SilentlyPrint
    Class Program
        Shared  Sub Main(ByVal args() As String)
            'Create a Workbook object
            Dim workbook As Workbook =  New Workbook() 
 
            'Load an Excel file
            workbook.LoadFromFile("C:\Users\Administrator\Desktop\sample.xlsx")
 
            'Fit worksheet on one page    
            Dim pageSetup As PageSetup =  workbook.Worksheets(0).PageSetup 
            pageSetup.IsFitToPage = True
 
            'Set the print controller to StandardPrintController, which will prevent print process from showing
            workbook.PrintDocument.PrintController = New StandardPrintController()
 
            'Get PrinterSettings from the workbook
            Dim settings As PrinterSettings =  workbook.PrintDocument.PrinterSettings 
 
            'Specify printer name, duplex mode and print pages
            settings.PrinterName = "HP LaserJet P1007" 
            settings.Duplex = Duplex.Simplex
            settings.FromPage = 1
            settings.ToPage = 3         
 
            'Print the workbook
            workbook.PrintDocument.Print()
        End Sub
    End Class
End Namespace

PM> Install-Package Spire.PDF

using Spire.Pdf;

namespace GetNumberOfPages
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create a PdfDocument object
            PdfDocument pdf = new PdfDocument();

            //Load a sample PDF file 
            pdf.LoadFromFile("Contract.pdf");

            //Count the number of pages in the PDF
            int PageNumber = pdf.Pages.Count;
            Console.WriteLine("The PDF file has {0} pages", PageNumber);

            //Close the PDF
            pdf.Close();
        }
    }
}

PM> Install-Package Spire.Doc

using Spire.Doc;
using Spire.Doc.Documents;
using Spire.Doc.Fields;
using System.Collections.Generic;

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

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

            //Create an object of List 
            List<Field> hyperlinks = new List<Field>();

            //Loop through the items in the sections to find all hyperlinks
            foreach (Section section in doc.Sections)
            {
                foreach (DocumentObject sec in section.Body.ChildObjects)
                {
                    if (sec.DocumentObjectType == DocumentObjectType.Paragraph)
                    {
                        //Loop through all paragraphs in the sections
                        foreach (DocumentObject para in (sec as Paragraph).ChildObjects)
                        {
                            if (para.DocumentObjectType == DocumentObjectType.Field)
                            {
                                Field field = para as Field;

                                if (field.Type == FieldType.FieldHyperlink)
                                {
                                    hyperlinks.Add(field);
                                }
                            }
                        }
                    }
                }
            }
            //Modify the address (URL) of the first hyperlink 
            hyperlinks[0].Code = "HYPERLINK \"" + "https://www.e-iceblue.com/Introduce/word-for-net-introduce.html" + "\"";

            //Modify the display text of the first hyperlink 
            hyperlinks[0].FieldText = "Spire.Doc for .NET";

            //Save the result document
            doc.SaveToFile("EditHyperlinks.docx", FileFormat.Docx);
        }
    }
}

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

Namespace ModifyHyperlink
    Class Program
        Private Shared Sub Main(ByVal args As String())
            'Create a Document object
            Dim doc As Document = New Document()

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

            'Create an object of List 
            Dim hyperlinks As List(Of Field) = New List(Of Field)()

            'Loop through the items in the sections to find all hyperlinks
            For Each section As Section In doc.Sections

                For Each sec As DocumentObject In section.Body.ChildObjects

                    If sec.DocumentObjectType = DocumentObjectType.Paragraph Then
                        'Loop through all paragraphs in the sections
                        For Each para As DocumentObject In (TryCast(sec, Paragraph)).ChildObjects

                            If para.DocumentObjectType = DocumentObjectType.Field Then
                                Dim field As Field = TryCast(para, Field)

                                If field.Type = FieldType.FieldHyperlink Then
                                    hyperlinks.Add(field)
                                End If
                            End If
                        Next
                    End If
                Next
            Next

            'Modify the address (URL) of the first hyperlink 
            hyperlinks(0).Code = "HYPERLINK """ & "https://www.e-iceblue.com/Introduce/word-for-net-introduce.html" & """"

            'Modify the display text of the first hyperlink 
            hyperlinks(0).FieldText = "Spire.Doc for .NET"

            'Save the result document
            doc.SaveToFile("EditHyperlinks.docx", FileFormat.Docx)
        End Sub
    End Class
End Namespace