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.XLS

using Spire.Xls;
using System.Data;
using System.Drawing;

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

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

            // Create and populate a DataTable with sample data
            DataTable dataTable = new DataTable("Data");
            dataTable.Columns.Add("ID", typeof(int));
            dataTable.Columns.Add("Name", typeof(string));
            dataTable.Columns.Add("Age", typeof(int));
            dataTable.Columns.Add("Country", typeof(string));
            dataTable.Columns.Add("Salary ($)", typeof(decimal));
            dataTable.Rows.Add(101, "John Smith", 28, "USA", 54000m);
            dataTable.Rows.Add(102, "Maria Garcia", 34, "Spain", 65500m);
            dataTable.Rows.Add(103, "Liam Johnson", 22, "Canada", 48000m);
            dataTable.Rows.Add(104, "Emma Brown", 30, "Australia", 72300m);
            dataTable.Rows.Add(105, "Wei Zhang", 40, "China", 58700m);
            dataTable.Rows.Add(106, "Sofia Lopez", 26, "Mexico", 45200m);

            // Insert data from the DataTable into the worksheet
            sheet.InsertDataTable(dataTable, true, 1, 1);

            // Format the worksheet
            // Style the header row
            sheet.Rows[0].Style.Color = Color.LightGreen;
            sheet.Rows[0].Style.Font.FontName = "Arial";
            sheet.Rows[0].Style.Font.Size = 12f;
            sheet.Rows[0].BorderAround(); // Apply borders around the header row
            sheet.Rows[0].Borders.Color = Color.Blue;

            // Style the data rows
            for (int i = 1; i < sheet.AllocatedRange.Rows.Count(); i++)
            {
                sheet.Rows[i].Style.Color = Color.LightGray;
                sheet.Rows[i].Style.Font.FontName = "Arial";
                sheet.Rows[i].Style.Font.Size = 11f;
            }

            // Adjust the column widths to fit the content
            for (int j = 1; j <= sheet.AllocatedRange.Columns.Count(); j++)
            {
                sheet.AutoFitColumn(j);
            }

            // Save the workbook to a memory stream
            MemoryStream stream = new MemoryStream();
            workbook.SaveToStream(stream, FileFormat.Version2016);

            // Write the stream content to a file
            File.WriteAllBytes("output/CreateExcelByStream.xlsx", stream.ToArray());

            // Release resources
            workbook.Dispose();
        }
    }
}

using Spire.Xls;

namespace LoadExcelStream
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create an instance of the Workbook class
            Workbook workbook = new Workbook();

            // Create a memory stream
            MemoryStream stream = new MemoryStream();
            File.OpenRead("Sample.xlsx").CopyTo(stream);

            // Load the Excel file from the stream
            workbook.LoadFromStream(stream);

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

            // Initialize a list to store the data retrieved from the worksheet
            List<List<string>> data = new List<List<string>>();
            for (int i = 0; i < sheet.AllocatedRange.Rows.Count(); i++)
            {
                // Create a list to hold each row of data
                List<string> lines = new List<string>();
                for (int j = 0; j < sheet.AllocatedRange.Columns.Count(); j++)
                {
                    // Retrieve the cell text and add it to the row
                    lines.Add(sheet.AllocatedRange[i + 1, j + 1].Text);
                }
                // Add the row to the data list
                data.Add(lines);
            }

            // Print the retrieved data or use it for further operations
            foreach (List<string> lines in data)
            {
                Console.WriteLine(string.Join(" | ", lines));
            }
        }
    }
}

using Spire.Xls;
using System.Drawing;

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

            // Create a memory stream
            MemoryStream stream = new MemoryStream();
            File.OpenRead("Sample.xlsx").CopyTo(stream);

            // Load the Excel file from the stream
            workbook.LoadFromStream(stream);

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

            // Modify the style of the header row
            CellRange headerRow = sheet.AllocatedRange.Rows[0];
            headerRow.Style.Font.FontName = "Times New Roman";
            headerRow.Style.Font.Size = 12f;
            headerRow.Style.Color = Color.LightBlue;

            // Modify the style of the data rows
            for (int i = 1; i < sheet.AllocatedRange.Rows.Count(); i++)
            {
                CellRange dataRow = sheet.AllocatedRange.Rows[i];
                dataRow.Style.Font.FontName = "Arial";
                dataRow.Style.Font.Size = 10f;
                dataRow.Style.Color = Color.LightGray;
                // Alternate row coloring (even rows)
                if (i % 2 == 0)
                {
                    dataRow.Style.Color = Color.LightSlateGray;
                }
            }

            // Autofit columns to adjust their width based on content
            for (int k = 1; k <= sheet.AllocatedRange.Columns.Count(); k++)
            {
                sheet.AutoFitColumn(k);
            }

            // Change the border color
            sheet.AllocatedRange.Style.Borders.Color = Color.White;

            // Save the modified workbook back to the stream
            workbook.SaveToStream(stream);

            // Write the stream content to a new file
            File.WriteAllBytes("output/ModifyExcelByStream.xlsx", stream.ToArray());

            // Release resources
            workbook.Dispose();
        }
    }
}

PM> Install-Package Spire.XLS

using Spire.Xls;

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

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

            //Set built-in document properties for the Excel workbook
            workbook.DocumentProperties.Author = "E-iceblue Team";
            workbook.DocumentProperties.Title = "Add Built-in Document Properties in Excel ";
            workbook.DocumentProperties.Keywords = "Excel, Document Properties, C#, VB.NET";
            workbook.DocumentProperties.Category = "Spire.XLS Demo";
            workbook.DocumentProperties.Company = "E-iceblue";
            workbook.DocumentProperties.Comments = "Document properties are details about a file that describe or identify it.";

            //Save the result document
            workbook.SaveToFile("ExcelProperties.xlsx", FileFormat.Version2013);
        }
    }
}

Imports Spire.Xls

Namespace ExcelProperties
    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")

            'Set built-in document properties for the Excel workbook
            workbook.DocumentProperties.Author = "E-iceblue Team"
            workbook.DocumentProperties.Title = "Add Built-in Document Properties in Excel "
            workbook.DocumentProperties.Keywords = "Excel, Document Properties, C#, VB.NET"
            workbook.DocumentProperties.Category = "Spire.XLS Demo"
            workbook.DocumentProperties.Company = "E-iceblue"
            workbook.DocumentProperties.Comments = "Document properties are details about a file that describe or identify it."

            'Save the result document
            workbook.SaveToFile("ExcelProperties.xlsx", FileFormat.Version2013)
        End Sub
    End Class
End Namespace

using Spire.Xls;
using System;

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

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

            //Add custom document properties to the document
            workbook.CustomDocumentProperties.Add("_MarkAsFinal", true);
            workbook.CustomDocumentProperties.Add("The Editor", "E-iceblue");
            workbook.CustomDocumentProperties.Add("Phone Number", 12345678);
            workbook.CustomDocumentProperties.Add("Document ID", 1);
            workbook.CustomDocumentProperties.Add("Revision Date", DateTime.Now);

            //Save the result document
            workbook.SaveToFile("ExcelCustomProperties.xlsx", FileFormat.Version2013);
        }
    }
}

Imports Spire.Xls

Namespace CustomExcelProperties
    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")

            'Add custom document properties to the document
            workbook.CustomDocumentProperties.Add("_MarkAsFinal", True)
            workbook.CustomDocumentProperties.Add("The Editor", "E-iceblue")
            workbook.CustomDocumentProperties.Add("Phone Number", 12345678)
            workbook.CustomDocumentProperties.Add("Document ID", 1)
            workbook.CustomDocumentProperties.Add("Revision Date", DateTime.Now)

            'Save the result document
            workbook.SaveToFile("ExcelCustomProperties.xlsx", FileFormat.Version2013)
        End Sub
    End Class
End Namespace

PM> Install-Package Spire.XLS

using Spire.Xls;

namespace MergeExcelFiles
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create a string array from Excel file paths
            string[] inputFiles = new string[] { "April.xlsx", "May.xlsx", "June.xlsx" };

            //Initialize a new Workbook object
            Workbook newWorkbook = new Workbook();
            //Clear the default worksheets
            newWorkbook.Worksheets.Clear();

            //Initialize another temporary Workbook object
            Workbook tempWorkbook = new Workbook();

            //Loop through the string array
            foreach (string file in inputFiles)
            {
                //Load the current workbook
                tempWorkbook.LoadFromFile(file);
                //Loop through the worksheets in the current workbook
                foreach (Worksheet sheet in tempWorkbook.Worksheets)
                {
                    //Copy each worksheet from the current workbook to the new workbook
                    newWorkbook.Worksheets.AddCopy(sheet, WorksheetCopyType.CopyAll);
                }
            }

            //Save the new workbook to file
            newWorkbook.SaveToFile("MergeWorkbooks.xlsx", ExcelVersion.Version2013);
        }
    }
}

Imports Spire.Xls

Namespace MergeExcelFiles
    Friend Class Program
        Private Shared Sub Main(ByVal args As String())
            'Create a string array from Excel file paths
            Dim inputFiles = New String() {"April.xlsx", "May.xlsx", "June.xlsx"}

            'Initialize a new Workbook object
            Dim newWorkbook As Workbook = New Workbook()
            'Clear the default worksheets
            newWorkbook.Worksheets.Clear()

            'Initialize another temporary Workbook object
            Dim tempWorkbook As Workbook = New Workbook()

            'Loop through the string array
            For Each file In inputFiles
                'Load the current workbook
                tempWorkbook.LoadFromFile(file)
                'Loop through the worksheets in the current workbook
                For Each sheet As Worksheet In tempWorkbook.Worksheets
                    'Copy each worksheet from the current workbook to the new workbook
                    newWorkbook.Worksheets.AddCopy(sheet, WorksheetCopyType.CopyAll)
                Next
            Next

            'Save the new workbook to file
            newWorkbook.SaveToFile("MergeWorkbooks.xlsx", ExcelVersion.Version2013)
        End Sub
    End Class
End Namespace

using Spire.Xls;

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

            //Get the first worksheet
            Worksheet sheet1 = workbook.Worksheets[0];
            //Get the second worksheet
            Worksheet sheet2 = workbook.Worksheets[1];

            //Get the used range in the second worksheet
            CellRange sourceRange = sheet2.AllocatedRange;
            //Specify the destination range in the first worksheet
            CellRange destRange = sheet1.Range[sheet1.LastRow + 1, 1];

            //Copy the used range of the second worksheet to the destination range in the first worksheet
            sourceRange.Copy(destRange);

            //Remove the second worksheet
            sheet2.Remove();

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

Imports Spire.Xls

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

            'Get the first worksheet
            Dim sheet1 As Worksheet = workbook.Worksheets(0)
            'Get the second worksheet
            Dim sheet2 As Worksheet = workbook.Worksheets(1)

            'Get the used range in the second worksheet
            Dim sourceRange As CellRange = sheet2.AllocatedRange
            'Specify the destination range in the first worksheet
            Dim destRange As CellRange = sheet1.Range(sheet1.LastRow + 1, 1)

            'Copy the used range of the second worksheet to the destination range in the first worksheet
            sourceRange.Copy(destRange)

            'Remove the second worksheet
            sheet2.Remove()

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

PM> Install-Package Spire.XLS

using Spire.Xls;
using System.Data;

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

            //Remove default worksheets
            wb.Worksheets.Clear();

            //Add a worksheet and name it "Employee"
            Worksheet sheet = wb.Worksheets.Add("Employee");

            //Merge the cells between A1 and G1
            sheet.Range["A1:G1"].Merge();

            //Write data to A1 and apply formatting to it
            sheet.Range["A1"].Value = "Basic Information of Employees of Huanyu Automobile Company";
            sheet.Range["A1"].HorizontalAlignment = HorizontalAlignType.Center;
            sheet.Range["A1"].VerticalAlignment = VerticalAlignType.Center;
            sheet.Range["A1"].Style.Font.IsBold = true;
            sheet.Range["A1"].Style.Font.Size = 13F;

            //Set row height of the first row
            sheet.Rows[0].RowHeight = 30F;

            //Create a DataTable
            DataTable dt = new DataTable();
            dt.Columns.Add("Name");
            dt.Columns.Add("Gender");
            dt.Columns.Add("Birth Date");
            dt.Columns.Add("Educational Background");
            dt.Columns.Add("Contact Number");
            dt.Columns.Add("Position");
            dt.Columns.Add("ID");
            dt.Rows.Add("Allen", "Male", "1990-02-10", "Bachelor", "24756854", "Mechanic", "0021");
            dt.Rows.Add("Patrick", "Male", "1985-06-08", "Master", "59863247", "Mechanic", "0022");
            dt.Rows.Add("Jenna", "Female", "1989-11-25", "Bachelor", "79540352", "Sales", "0023");
            dt.Rows.Add("Tommy", "Male", "1988-04-16", "Master", "52014060", "Mechanic", "0024");
            dt.Rows.Add("Christina", "Female", "1998-01-21", "Bachelor", "35401489", "HR", "0025");

            //Import data from DataTable to worksheet
            sheet.InsertDataTable(dt, true, 2, 1, true);

            //Set row height of a range
            sheet.Range["A2:G7"].RowHeight = 15F;

            //Set column width 
            sheet.Range["A2:G7"].Columns[2].ColumnWidth = 15F;
            sheet.Range["A2:G7"].Columns[3].ColumnWidth = 21F;
            sheet.Range["A2:G7"].Columns[4].ColumnWidth = 15F;

            //Set border style of a range
            sheet.Range["A2:G7"].BorderAround(LineStyleType.Medium);
            sheet.Range["A2:G7"].BorderInside(LineStyleType.Thin);
            sheet.Range["A2:G2"].BorderAround(LineStyleType.Medium);
            sheet.Range["A2:G7"].Borders.KnownColor = ExcelColors.Black;

            //Save to a .xlsx file
            wb.SaveToFile("NewSpreadsheet.xlsx", FileFormat.Version2016);
        }
    }
}

Imports Spire.Xls
Imports System.Data
 
Namespace CreateExcelSpreadsheet
    Class Program
        Shared  Sub Main(ByVal args() As String)
            'Create a Workbook object
            Dim wb As Workbook =  New Workbook() 
 
            'Remove default worksheets
            wb.Worksheets.Clear()
 
            'Add a worksheet and name it "Employee"
            Dim sheet As Worksheet =  wb.Worksheets.Add("Employee") 
 
            'Merge the cells between A1 and G1
            sheet.Range("A1:G1").Merge()
 
            'Write data to A1 and apply formatting to it
            sheet.Range("A1").Value = "Basic Information of Employees of Huanyu Automobile Company"
            sheet.Range("A1").HorizontalAlignment = HorizontalAlignType.Center
            sheet.Range("A1").VerticalAlignment = VerticalAlignType.Center
            sheet.Range("A1").Style.Font.IsBold = True
            sheet.Range("A1").Style.Font.Size = 13F
 
            'Set row height of the first row
            sheet.Rows(0).RowHeight = 30F
 
            'Create a DataTable
            Dim dt As DataTable =  New DataTable() 
            dt.Columns.Add("Name")
            dt.Columns.Add("Gender")
            dt.Columns.Add("Birth Date")
            dt.Columns.Add("Educational Background")
            dt.Columns.Add("Contact Number")
            dt.Columns.Add("Position")
            dt.Columns.Add("ID")
            dt.Rows.Add("Allen", "Male", "1990-02-10", "Bachelor", "24756854", "Mechanic", "0021")
            dt.Rows.Add("Patrick", "Male", "1985-06-08", "Master", "59863247", "Mechanic", "0022")
            dt.Rows.Add("Jenna", "Female", "1989-11-25", "Bachelor", "79540352", "Sales", "0023")
            dt.Rows.Add("Tommy", "Male", "1988-04-16", "Master", "52014060", "Mechanic", "0024")
            dt.Rows.Add("Christina", "Female", "1998-01-21", "Bachelor", "35401489", "HR", "0025")
 
            'Import data from DataTable to worksheet
            sheet.InsertDataTable(dt, True, 2, 1, True)
 
            'Set row height of a range
            sheet.Range("A2:G7").RowHeight = 15F
 
            'Set column width 
            sheet.Range("A2:G7").Columns(2).ColumnWidth = 15F
            sheet.Range("A2:G7").Columns(3).ColumnWidth = 21F
            sheet.Range("A2:G7").Columns(4).ColumnWidth = 15F
 
            'Set border style of a range
            sheet.Range("A2:G7").BorderAround(LineStyleType.Medium)
            sheet.Range("A2:G7").BorderInside(LineStyleType.Thin)
            sheet.Range("A2:G2").BorderAround(LineStyleType.Medium)
            sheet.Range("A2:G7").Borders.KnownColor = ExcelColors.Black
 
            'Save to a .xlsx file
            wb.SaveToFile("NewSpreadsheet.xlsx", FileFormat.Version2016)
        End Sub
    End Class
End Namespace

using Spire.Xls;

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

            //Load an existing Excel file
            wb.LoadFromFile(@"C:\Users\Administrator\Desktop\NewSpreadsheet.xlsx");

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

            //Get the cell range containing data
            CellRange locatedRange = sheet.AllocatedRange;

            //Iterate through the rows
            for (int i = 0;i < locatedRange.Rows.Length;i++)
            {
                //Iterate through the columns
                for (int j = 0; j < locatedRange.Rows[i].ColumnCount; j++)
                {
                    //Get data of a specific cell
                    Console.Write(locatedRange[i + 1, j + 1].Value + "  ");

                }
                Console.WriteLine();            
            }
        }
    }
}

Imports Spire.Xls
 
Namespace ReadExcelData
    Class Program
        Shared  Sub Main(ByVal args() As String)
            'Create a Workbook object
            Dim wb As Workbook =  New Workbook() 
 
            'Load an existing Excel file
            wb.LoadFromFile("C:\Users\Administrator\Desktop\NewSpreadsheet.xlsx")
 
            'Get the first worksheet
            Dim sheet As Worksheet =  wb.Worksheets(0) 
 
            'Get the cell range containing data
            Dim locatedRange As CellRange =  sheet.AllocatedRange 
 
            'Iterate through the rows
            Dim i As Integer
            For  i = 0 To  locatedRange.Rows.Length- 1  Step i + 1
                'Iterate through the columns
                Dim j As Integer
                For  j = 0 To  locatedRange.Rows(i).ColumnCount- 1  Step  j + 1
                    'Get data of a specific cell
                    Console.Write(locatedRange(i + 1, j + 1).Value + "  ")
 
                Next
                Console.WriteLine()
            Next
        End Sub
    End Class
End Namespace

using Spire.Xls;

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

            //Load an existing Excel file
            wb.LoadFromFile(@"C:\Users\Administrator\Desktop\NewSpreadsheet.xlsx");

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

            //Change the value of a specific cell
            sheet.Range["A1"].Value = "Updated Value";

            //Save to file
            wb.SaveToFile("Updated.xlsx", ExcelVersion.Version2016);
        }
    }
}

Imports Spire.Xls
 
Namespace UpdateCellValue
    Class Program
        Shared  Sub Main(ByVal args() As String)
            'Create a Workbook object
            Dim wb As Workbook =  New Workbook() 
 
            'Load an existing Excel file
            wb.LoadFromFile("C:\Users\Administrator\Desktop\NewSpreadsheet.xlsx")
 
            'Get the first worksheet
            Dim sheet As Worksheet =  wb.Worksheets(0) 
 
            'Change the value of a specific cell
            sheet.Range("A1").Value = "Updated Value"
 
            'Save to file
            wb.SaveToFile("Updated.xlsx", ExcelVersion.Version2016)
        End Sub
    End Class
End Namespace