The sample demonstrates how to Copy Excel Worksheet in Silverlight via Spire.XLS.

<Application xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
             xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" 
             x:Class="copySheet.App">
             
    <Application.Resources>
        
    </Application.Resources>
</Application>

using System;
using System.Windows;

namespace copySheet
{
    public partial class App : Application
    {

        public App()
        {
            this.Startup += this.Application_Startup;
            this.Exit += this.Application_Exit;
            this.UnhandledException += this.Application_UnhandledException;

            InitializeComponent();
        }

        private void Application_Startup(object sender, StartupEventArgs e)
        {
            this.RootVisual = new MainPage();
        }

        private void Application_Exit(object sender, EventArgs e)
        {

        }

        private void Application_UnhandledException(object sender, ApplicationUnhandledExceptionEventArgs e)
        {
            // If the app is running outside of the debugger then report the exception using
            // the browser's exception mechanism. On IE this will display it a yellow alert 
            // icon in the status bar and Firefox will display a script error.
            if (!System.Diagnostics.Debugger.IsAttached)
            {

                // NOTE: This will allow the application to continue running after an exception has been thrown
                // but not handled. 
                // For production applications this error handling should be replaced with something that will 
                // report the error to the website and stop the application.
                e.Handled = true;
                Deployment.Current.Dispatcher.BeginInvoke(delegate { ReportErrorToDOM(e); });
            }
        }

        private void ReportErrorToDOM(ApplicationUnhandledExceptionEventArgs e)
        {
            try
            {
                string errorMsg = e.ExceptionObject.Message + e.ExceptionObject.StackTrace;
                errorMsg = errorMsg.Replace('"', '\'').Replace("\r\n", @"\n");

                System.Windows.Browser.HtmlPage.Window.Eval("throw new Error(\"Unhandled Error in Silverlight Application " + errorMsg + "\");");
            }
            catch (Exception)
            {
            }
        }
    }
}

Imports System.Windows

Namespace copySheet
	Partial Public Class App
		Inherits Application

		Public Sub New()
			AddHandler Me.Startup, AddressOf Application_Startup
			AddHandler Me.Exit, AddressOf Application_Exit
			AddHandler Me.UnhandledException, AddressOf Application_UnhandledException

			InitializeComponent()
		End Sub

		Private Sub Application_Startup(ByVal sender As Object, ByVal e As StartupEventArgs)
			Me.RootVisual = New MainPage()
		End Sub

		Private Sub Application_Exit(ByVal sender As Object, ByVal e As EventArgs)

		End Sub

		Private Sub Application_UnhandledException(ByVal sender As Object, ByVal e As ApplicationUnhandledExceptionEventArgs)
			' If the app is running outside of the debugger then report the exception using
			' the browser's exception mechanism. On IE this will display it a yellow alert 
			' icon in the status bar and Firefox will display a script error.
			If Not Debugger.IsAttached Then

				' NOTE: This will allow the application to continue running after an exception has been thrown
				' but not handled. 
				' For production applications this error handling should be replaced with something that will 
				' report the error to the website and stop the application.
				e.Handled = True
				Deployment.Current.Dispatcher.BeginInvoke(Sub() ReportErrorToDOM(e))
			End If
		End Sub

		Private Sub ReportErrorToDOM(ByVal e As ApplicationUnhandledExceptionEventArgs)
			Try
				Dim errorMsg As String = e.ExceptionObject.Message + e.ExceptionObject.StackTrace
				errorMsg = errorMsg.Replace(""""c, "'"c).Replace(vbCrLf, vbLf)

				System.Windows.Browser.HtmlPage.Window.Eval("throw new Error(""Unhandled Error in Silverlight Application " & errorMsg & """);")
			Catch e1 As Exception
			End Try
		End Sub
	End Class
End Namespace

<UserControl x:Class="copySheet.MainPage"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
    xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
    mc:Ignorable="d"
    d:DesignHeight="300" d:DesignWidth="400">

    <Grid x:Name="LayoutRoot" Background="White" Loaded="LayoutRoot_Loaded">
        <Button Content="Run" Height="23" HorizontalAlignment="Left" Margin="296,262,0,0" Name="button1" VerticalAlignment="Top" Width="75" Click="button1_Click" />
    </Grid>
</UserControl>    

using System.Windows;
using System.Windows.Controls;
using System.Reflection;
using System.IO;

using Spire.Xls;

namespace copySheet
{
    public partial class MainPage : UserControl
    {
        //create a workbook
        private Workbook workbook = null;

        //create a SaveFileDialog to save the workbook
        private SaveFileDialog saveFileDialog = null;
        public MainPage()
        {
            InitializeComponent();
            this.workbook = new Workbook();
            this.saveFileDialog = new SaveFileDialog();
            this.saveFileDialog.Filter = "Excel Documents(*.xls)|*.xls";
        }

        private void button1_Click(object sender, RoutedEventArgs e)
        {
            //create a worksheet into the workbook
            Worksheet sheetDest = this.workbook.CreateEmptySheet("Sheet2");

            //copy the first worksheet to the new worksheet
            sheetDest.CopyFrom(this.workbook.Worksheets[0]);

            //save the workbook
            bool? result = this.saveFileDialog.ShowDialog();
            if (result.HasValue && result.Value)
            {
                using (Stream saveStr = this.saveFileDialog.OpenFile())
                {
                    this.workbook.SaveToStream(saveStr);
                }
            }
        }

        private void LayoutRoot_Loaded(object sender, RoutedEventArgs e)
        {
            //load the Excel template
            Assembly assembly = this.GetType().Assembly;
            foreach (string name in assembly.GetManifestResourceNames())
            {
                if (name.EndsWith("parts.xls"))
                {
                    using (Stream fileStr = assembly.GetManifestResourceStream(name))
                    {
                        this.workbook.LoadFromStream(fileStr);
                    }
                }
            }
        }
    }
}

Imports System.Windows
Imports System.Windows.Controls
Imports System.Reflection
Imports System.IO

Imports Spire.Xls

Namespace copySheet
	Partial Public Class MainPage
		Inherits UserControl
		'create a workbook
		Private workbook As Workbook = Nothing

		'create a SaveFileDialog to save the workbook
		Private saveFileDialog As SaveFileDialog = Nothing
		Public Sub New()
			InitializeComponent()
			Me.workbook = New Workbook()
			Me.saveFileDialog = New SaveFileDialog()
			Me.saveFileDialog.Filter = "Excel Documents(*.xls)|*.xls"
		End Sub

		Private Sub button1_Click(ByVal sender As Object, ByVal e As RoutedEventArgs)
			'create a worksheet into the workbook
			Dim sheetDest As Worksheet = Me.workbook.CreateEmptySheet("Sheet2")

			'copy the first worksheet to the new worksheet
			sheetDest.CopyFrom(Me.workbook.Worksheets(0))

			'save the workbook
			Dim result? As Boolean = Me.saveFileDialog.ShowDialog()
			If result.HasValue AndAlso result.Value Then
				Using saveStr As Stream = Me.saveFileDialog.OpenFile()
					Me.workbook.SaveToStream(saveStr)
				End Using
			End If
		End Sub

		Private Sub LayoutRoot_Loaded(ByVal sender As Object, ByVal e As RoutedEventArgs)
			'load the Excel template
			Dim [assembly] As System.Reflection.Assembly = Me.GetType().Assembly
			For Each name As String In [assembly].GetManifestResourceNames()
				If name.EndsWith("parts.xls") Then
					Using fileStr As Stream = [assembly].GetManifestResourceStream(name)
						Me.workbook.LoadFromStream(fileStr)
					End Using
				End If
			Next name
		End Sub
	End Class
End Namespace

The sample demonstrates how to replace data in Excel workbook via Spire.XLS.

using Spire.Xls;
using System;

namespace Replace
{
    class Program
    {
        static void Main(string[] args)
        {
            //create a workbook
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"..\..\..\..\Data\country.xls",ExcelVersion.Version97to2003);
            Worksheet worksheet = workbook.Worksheets[0];
           
            //replace the "South America" to "China";
            try
            {
                //find the word will be replaced
                CellRange range = worksheet.FindString("South America", false, false);
                
                //use the word "China" repalce the word just founded
                worksheet.Replace(range.Value, "China");
            }
            catch (System.Exception)
            {

                //if couldn't find the word,give a message
                Console.WriteLine("The text doesn't exist the word you want to replace");

            }

            //save the workbook
            workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003);
            System.Diagnostics.Process.Start(workbook.FileName);
        }
    }
}

Imports Spire.Xls
Imports System

Namespace Replace
	Friend Class Program
		Shared Sub Main(ByVal args() As String)
			'create a workbook
			Dim workbook As New Workbook()
			workbook.LoadFromFile("..\..\..\..\Data\country.xls",ExcelVersion.Version97to2003)
			Dim worksheet As Worksheet = workbook.Worksheets(0)

			'replace the "South America" to "China";
			Try
				'find the word will be replaced
				Dim range As CellRange = worksheet.FindString("South America", False, False)

				'use the word "China" repalce the word just founded
				worksheet.Replace(range.Value, "China")
			Catch e1 As System.Exception

				'if couldn't find the word,give a message
				Console.WriteLine("The text doesn't exist the word you want to replace")

			End Try

			'save the workbook
			workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003)
			System.Diagnostics.Process.Start(workbook.FileName)
		End Sub
	End Class
End Namespace

The sample demonstrates how to copy cell data in Excel workbook via Spire.XLS.

using Spire.Xls;

namespace CopyCellData
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"..\..\..\..\Data\parts.xls",ExcelVersion.Version97to2003);
            Worksheet worksheet = workbook.Worksheets[0];
           
            //copy the A3-E5 to A19-E21
            worksheet.Copy(worksheet.Range["A3:E5"],worksheet.Range["A19:E21"],true);

            workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003);
            System.Diagnostics.Process.Start(workbook.FileName);
        }
    }
}

Imports Spire.Xls

Namespace CopyCellData
	Friend Class Program
		Shared Sub Main(ByVal args() As String)
			Dim workbook As New Workbook()
			workbook.LoadFromFile("..\..\..\..\Data\parts.xls",ExcelVersion.Version97to2003)
			Dim worksheet As Worksheet = workbook.Worksheets(0)

			'copy the A3-E5 to A19-E21
			worksheet.Copy(worksheet.Range("A3:E5"),worksheet.Range("A19:E21"),True)

			workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003)
			System.Diagnostics.Process.Start(workbook.FileName)
		End Sub
	End Class
End Namespace

The sample demonstrates how to auto fit column in Excel workbook via Spire.XLS.

using Spire.Xls;

namespace AutofitColumn
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"..\..\..\..\Data\country.xls");
            Worksheet sheet = workbook.Worksheets[0];

            //autofit the third column
            sheet.AutoFitColumn(1);

            workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003);
            System.Diagnostics.Process.Start("sample.xls");
        }
    }
}

Imports Spire.Xls

Namespace AutofitColumn
	Friend Class Program
		Shared Sub Main(ByVal args() As String)
			Dim workbook As New Workbook()
			workbook.LoadFromFile("..\..\..\..\Data\country.xls")
			Dim sheet As Worksheet = workbook.Worksheets(0)

			'autofit the third column
			sheet.AutoFitColumn(1)

			workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003)
			System.Diagnostics.Process.Start("sample.xls")
		End Sub
	End Class
End Namespace

The sample demonstrates how to set cell fill in Excel workbook via Spire.XLS.

using Spire.Xls;
using System.Drawing;

namespace CellFill
{
    class Program
    {
        static void Main(string[] args)
        {
            //create a workbook
            Workbook workbook = new Workbook();
            Worksheet sheet = workbook.Worksheets[0];
            
            //set the color of Range["C3"] 
            sheet.Range["B3:B4"].Style.Color = Color.Yellow;
            sheet.Range["B3:B4"].Style.FillPattern = ExcelPatternType.Angle;

            //set the fillpattern of Range["D4"]
            sheet.Range["C6:C7"].Style.Color = Color.GreenYellow;
            sheet.Range["C6:C7"].Style.FillPattern = ExcelPatternType.ThickDiagonalCrosshatch;

            //set the fillpattern of Range["E5"]
            sheet.Range["D9:D10"].Style.Color = Color.BlueViolet;
            sheet.Range["D9:D10"].Style.FillPattern = ExcelPatternType.Vertical;

            //set the fillpattern of Range["A1:C2"] 
            sheet.Range["E12:F15"].Style.Color = Color.LightSkyBlue;
            sheet.Range["E12:F15"].Style.FillPattern = ExcelPatternType.ForwardDiagonal;

            //set the fillpattern of Range["G9:H9"]
            sheet.Range["G17:I21"].Style.Color = Color.Bisque;
            sheet.Range["G17:I21"].Style.FillPattern = ExcelPatternType.Percent25Gray;

            //save the workbook
            workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003);
            System.Diagnostics.Process.Start(workbook.FileName);
        }
    }
}

Imports Spire.Xls
Imports System.Drawing

Namespace CellFill
	Friend Class Program
		Shared Sub Main(ByVal args() As String)
			'create a workbook
			Dim workbook As New Workbook()
			Dim sheet As Worksheet = workbook.Worksheets(0)

			'set the color of Range["C3"] 
			sheet.Range("B3:B4").Style.Color = Color.Yellow
			sheet.Range("B3:B4").Style.FillPattern = ExcelPatternType.Angle

			'set the fillpattern of Range["D4"]
			sheet.Range("C6:C7").Style.Color = Color.GreenYellow
			sheet.Range("C6:C7").Style.FillPattern = ExcelPatternType.ThickDiagonalCrosshatch

			'set the fillpattern of Range["E5"]
			sheet.Range("D9:D10").Style.Color = Color.BlueViolet
			sheet.Range("D9:D10").Style.FillPattern = ExcelPatternType.Vertical

			'set the fillpattern of Range["A1:C2"] 
			sheet.Range("E12:F15").Style.Color = Color.LightSkyBlue
			sheet.Range("E12:F15").Style.FillPattern = ExcelPatternType.ForwardDiagonal

			'set the fillpattern of Range["G9:H9"]
			sheet.Range("G17:I21").Style.Color = Color.Bisque
			sheet.Range("G17:I21").Style.FillPattern = ExcelPatternType.Percent25Gray

			'save the workbook
			workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003)
			System.Diagnostics.Process.Start(workbook.FileName)
		End Sub
	End Class
End Namespace

The sample demonstrates how to design borders in Excel workbook via Spire.XLS.

using Spire.Xls;
using System.Drawing;

namespace Borders
{
    class Program
    {
        static void Main(string[] args)
        {
            //create a workbook
            Workbook workbook = new Workbook();
            Worksheet sheet = workbook.Worksheets[0];
            sheet.Range["B2"].Text = "Home Page";
            
            //set the border of Range["B2"]
            sheet.Range["B2"].Borders.LineStyle = LineStyleType.Thick;
            sheet.Range["B2"].Borders[BordersLineType.DiagonalDown].LineStyle = LineStyleType.None;
            sheet.Range["B2"].Borders[BordersLineType.DiagonalUp].LineStyle = LineStyleType.None;
            sheet.Range["B2"].Borders.Color = Color.Red;
            sheet.AutoFitColumn(2);

            //set the border of Range["C4"]
            sheet.Range["C4"].Borders.LineStyle = LineStyleType.Double;
            sheet.Range["C4"].Borders[BordersLineType.DiagonalUp].LineStyle = LineStyleType.None;
            sheet.Range["C4"].Borders[BordersLineType.DiagonalDown].LineStyle = LineStyleType.None;
            sheet.Range["C4"].Borders.Color = Color.Green;

            //set the border of Range["D6"]
            sheet.Range["D6"].Borders.LineStyle = LineStyleType.Medium;
            sheet.Range["D6"].Borders[BordersLineType.DiagonalDown].LineStyle = LineStyleType.None;
            sheet.Range["D6"].Borders[BordersLineType.DiagonalUp].LineStyle = LineStyleType.None;
            sheet.Range["D6"].Borders.Color = Color.HotPink;
           
            //set the border of Range["E8"]
            sheet.Range["E8"].Borders.LineStyle = LineStyleType.Dashed;
            sheet.Range["E8"].Borders[BordersLineType.DiagonalDown].LineStyle = LineStyleType.None;
            sheet.Range["E8"].Borders[BordersLineType.DiagonalUp].LineStyle = LineStyleType.None;
            sheet.Range["E8"].Borders.Color = Color.Yellow;
           
            //set the border of Range["F10"]
            sheet.Range["F10"].Borders.LineStyle = LineStyleType.Hair;
            sheet.Range["F10"].Borders[BordersLineType.DiagonalDown].LineStyle = LineStyleType.None;
            sheet.Range["F10"].Borders[BordersLineType.DiagonalUp].LineStyle = LineStyleType.None;
            sheet.Range["F10"].Borders.Color = Color.SeaGreen;
           
            //set the border of Range["D6"]
            sheet.Range["G12"].Borders.LineStyle = LineStyleType.SlantedDashDot;
            sheet.Range["G12"].Borders[BordersLineType.DiagonalDown].LineStyle = LineStyleType.None;
            sheet.Range["G12"].Borders[BordersLineType.DiagonalUp].LineStyle = LineStyleType.None;
            sheet.Range["G12"].Borders.Color = Color.Blue;
            workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003);
            System.Diagnostics.Process.Start(workbook.FileName);
        }
    }
}

Imports Spire.Xls
Imports System.Drawing

Namespace Borders
	Friend Class Program
		Shared Sub Main(ByVal args() As String)
			'create a workbook
			Dim workbook As New Workbook()
			Dim sheet As Worksheet = workbook.Worksheets(0)
			sheet.Range("B2").Text = "Home Page"

			'set the border of Range["B2"]
			sheet.Range("B2").Borders.LineStyle = LineStyleType.Thick
			sheet.Range("B2").Borders(BordersLineType.DiagonalDown).LineStyle = LineStyleType.None
			sheet.Range("B2").Borders(BordersLineType.DiagonalUp).LineStyle = LineStyleType.None
			sheet.Range("B2").Borders.Color = Color.Red
			sheet.AutoFitColumn(2)

			'set the border of Range["C4"]
			sheet.Range("C4").Borders.LineStyle = LineStyleType.Double
			sheet.Range("C4").Borders(BordersLineType.DiagonalUp).LineStyle = LineStyleType.None
			sheet.Range("C4").Borders(BordersLineType.DiagonalDown).LineStyle = LineStyleType.None
			sheet.Range("C4").Borders.Color = Color.Green

			'set the border of Range["D6"]
			sheet.Range("D6").Borders.LineStyle = LineStyleType.Medium
			sheet.Range("D6").Borders(BordersLineType.DiagonalDown).LineStyle = LineStyleType.None
			sheet.Range("D6").Borders(BordersLineType.DiagonalUp).LineStyle = LineStyleType.None
			sheet.Range("D6").Borders.Color = Color.HotPink

			'set the border of Range["E8"]
			sheet.Range("E8").Borders.LineStyle = LineStyleType.Dashed
			sheet.Range("E8").Borders(BordersLineType.DiagonalDown).LineStyle = LineStyleType.None
			sheet.Range("E8").Borders(BordersLineType.DiagonalUp).LineStyle = LineStyleType.None
			sheet.Range("E8").Borders.Color = Color.Yellow

			'set the border of Range["F10"]
			sheet.Range("F10").Borders.LineStyle = LineStyleType.Hair
			sheet.Range("F10").Borders(BordersLineType.DiagonalDown).LineStyle = LineStyleType.None
			sheet.Range("F10").Borders(BordersLineType.DiagonalUp).LineStyle = LineStyleType.None
			sheet.Range("F10").Borders.Color = Color.SeaGreen

			'set the border of Range["D6"]
			sheet.Range("G12").Borders.LineStyle = LineStyleType.SlantedDashDot
			sheet.Range("G12").Borders(BordersLineType.DiagonalDown).LineStyle = LineStyleType.None
			sheet.Range("G12").Borders(BordersLineType.DiagonalUp).LineStyle = LineStyleType.None
			sheet.Range("G12").Borders.Color = Color.Blue
			workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003)
			System.Diagnostics.Process.Start(workbook.FileName)
		End Sub
	End Class

The sample demonstrates how to set background color in Excel workbook via Spire.XLS.

using System.Drawing;

using Spire.Xls;

namespace BackgrandColor
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"..\..\..\..\Data\country.xls",ExcelVersion.Version97to2003);
            Worksheet worksheet = workbook.Worksheets[0];

            //set the backgroundcolor=LightBlue of Range["A2:E9"]
            worksheet.Range["A2:E9"].Style.Color = Color.LightBlue;

            //set the backgroundcolor=Silver of Range["A11:E18"]
            worksheet.Range["A11:E18"].Style.Color = Color.Silver;

            workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003);
            System.Diagnostics.Process.Start(workbook.FileName);
        }
    }
}

Imports System.Drawing

Imports Spire.Xls

Namespace BackgrandColor
	Class Program
		Private Shared Sub Main(args As String())
			Dim workbook As New Workbook()
			workbook.LoadFromFile("..\..\..\..\Data\country.xls", ExcelVersion.Version97to2003)
			Dim worksheet As Worksheet = workbook.Worksheets(0)

			'set the backgroundcolor=LightBlue of Range["A2:E9"]
			worksheet.Range("A2:E9").Style.Color = Color.LightBlue

			'set the backgroundcolor=Silver of Range["A11:E18"]
			worksheet.Range("A11:E18").Style.Color = Color.Silver

			workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003)
			System.Diagnostics.Process.Start(workbook.FileName)
		End Sub
	End Class
End Namespace

The sample demonstrates how to delete row in Excel workbook via Spire.XLS.

using Spire.Xls;

namespace RowDelete
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"..\..\..\..\Data\parts.xls");
            Worksheet sheet = workbook.Worksheets[0];
            
            //delete the second row from sheet
            sheet.DeleteRow(2);
           
            //delete the seventh and eighth rows from sheet
            sheet.DeleteRow(7,2);

            workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003);
            System.Diagnostics.Process.Start(workbook.FileName);
        }
    }
}

Imports Spire.Xls

Namespace RowDelete
	Friend Class Program
		Shared Sub Main(ByVal args() As String)
			Dim workbook As New Workbook()
			workbook.LoadFromFile("..\..\..\..\Data\parts.xls")
			Dim sheet As Worksheet = workbook.Worksheets(0)

			'delete the second row from sheet
			sheet.DeleteRow(2)

			'delete the seventh and eighth rows from sheet
			sheet.DeleteRow(7,2)

			workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003)
			System.Diagnostics.Process.Start(workbook.FileName)
		End Sub
	End Class
End Namespace

The sample demonstrates how to delete workbook column in Excel workbook via Spire.XLS.

using Spire.Xls;

namespace DeleteColumn
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"..\..\..\..\Data\vendors.xls",ExcelVersion.Version97to2003);
            Worksheet sheet = workbook.Worksheets[0];
 
            //delete the first column of sheet
            sheet.DeleteColumn(1); 

            workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003);
            System.Diagnostics.Process.Start(workbook.FileName);
        }
    }
}

Imports Spire.Xls

Namespace DeleteColumn
	Friend Class Program
		Shared Sub Main(ByVal args() As String)
			Dim workbook As New Workbook()
			workbook.LoadFromFile("..\..\..\..\Data\vendors.xls",ExcelVersion.Version97to2003)
			Dim sheet As Worksheet = workbook.Worksheets(0)

			'delete the first column of sheet
			sheet.DeleteColumn(1)

			workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003)
			System.Diagnostics.Process.Start(workbook.FileName)
		End Sub
	End Class
End Namespace

The sample demonstrates how to set row height in Excel workbook via Spire.XLS.

using Spire.Xls;

namespace SetRowHeight
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"..\..\..\..\Data\parts.xls");
            Worksheet sheet = workbook.Worksheets[0];
            
            //set the RowHeight=25 of the first row
            sheet.SetRowHeight(1, 25);

            workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003);
            System.Diagnostics.Process.Start(workbook.FileName);
        }
    }
}

Imports Spire.Xls

Namespace SetRowHeight
	Friend Class Program
		Shared Sub Main(ByVal args() As String)
			Dim workbook As New Workbook()
			workbook.LoadFromFile("..\..\..\..\Data\parts.xls")
			Dim sheet As Worksheet = workbook.Worksheets(0)

			'set the RowHeight=25 of the first row
			sheet.SetRowHeight(1, 25)

			workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003)
			System.Diagnostics.Process.Start(workbook.FileName)
		End Sub
	End Class
End Namespace