Renaming excel worksheet can makes readers clearly understand what we want to present at their first sight, at the same time, we can also set tab color for a specific worksheet, in order to distinguish it from others and find it in a very short time.

This section will demonstrate how to rename and set tab color for excel worksheet in WPF using Spire.XLS for WPF.

Please follow the detail steps and code snippets below:

Use namespace:

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

Step 1: Initialize a new instance of Workbook class and load the sample excel document from file.

Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");

Step 2: Get the worksheets that need to be renamed and set tab color for. Here we choose the first and the second worksheets.

Worksheet sheet = workbook.Worksheets[0];
Worksheet sheet1 = workbook.Worksheets[1];

Step 3: Rename and set tab color.

Rename the first and the second worksheets.

sheet.Name = "Sales Report";
sheet1.Name = "Vendors Info";

Set tab color of the second worksheet as Lawn Green.

sheet1.TabColor = Color.LawnGreen;

Step 4: Save the changes and launch the file.

workbook.SaveToFile("Rename.xlsx");
System.Diagnostics.Process.Start("Rename.xlsx");

Result:

Full codes:

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

namespace WpfApplication1
{
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
        }
        private void button1_Click(object sender, RoutedEventArgs e)
        {
            //Load the excel file
            Workbook workbook = new Workbook();
            workbook.LoadFromFile("Sample.xlsx");

            Worksheet sheet = workbook.Worksheets[0];
            Worksheet sheet1 = workbook.Worksheets[1];

            //rename worksheets
            sheet.Name = "Sales Report";
            sheet1.Name = "Vendors Info";

            //set tab color
            sheet1.TabColor = Color.LawnGreen;

            //save and launch the file
            workbook.SaveToFile("Rename.xlsx");
            System.Diagnostics.Process.Start("Rename.xlsx");
        }
    }
}

The ability to add or delete rows and columns in a Word table is crucial for maintaining the accuracy, clarity, and relevance of the information presented. By adding additional rows and columns, you can modify the original structure of a table to accommodate changes in the underlying data. Conversely, removing unnecessary rows and columns helps to streamline your document and make it easier to read. In this article, you will learn how to add or delete table rows and columns in Word in C# using Spire.Doc for .NET.

• Add or Insert Rows in a Word Table in C#
• Add or Insert Columns in a Word Table in C#
• Delete Rows and Columns from a Word Table in C#

Install Spire.Doc for .NET

To begin with, you need to add the DLL files included in the Spire.Doc for.NET package as references in your .NET project. The DLL files can be either downloaded from this link or installed via NuGet.

PM> Install-Package Spire.Doc

Add or Insert Rows in a Word Table in C#

Spire.Doc for .NET allows to add a row to the end of a Word table or insert a row at a specific location in a Word table using the Table.AddRow() or Table.Rows.Insert() method. The following are the detailed steps.

• Create a Document object.
• Load a Word document using Document.LoadFromFile() method.
• Get the first section using Document.Sections[] property.
• Get a specified table in the section using Section.Tables[] property.
• Insert a row at a specific location in the table using Table.Rows.Insert(intindex, TableRow row) method.
• Add a row to the end of the table using Table.AddRow() method.
• Save the result document using Document.SaveToFile() method.

using Spire.Doc;

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

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

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

            //Get the first table in the section
            Table table = section.Tables[0] as Table;

            //Insert a row into the table as the third row
            table.Rows.Insert(2, table.AddRow());

            //Add a row at the end of the table
            table.AddRow();

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

Add or Insert Columns in a Word Table in C#

Spire.Doc for .NET does not have a direct method for adding or inserting columns in a Word table. However, you can achieve this task by adding or inserting cells at a specific location in each table row using the TableRow.AddCell() or TableRow.Cells.Insert() method. The following are the detailed steps.

• Create a Document object.
• Load a Word document using Document.LoadFromFile() method.
• Get the first section using Document.Sections[] property.
• Get a specified table in the section using Section.Tables[] property.
• Loop through to get each row in the table.
• Create a TableCell object, and then insert it at a specific location in each row using TableRow.Cells.Insert() method.
• Set the cell width using TableRow.Cells[].SetCellWidth() method.
• Add a cell to the end of each row using TableRow.AddCell() method.
• Save the result document using Document.SaveToFile() method.

using Spire.Doc;

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

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

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

            //Get the first table in the section
            Table table = section.Tables[0] as Table;

            //Loop through the rows in the table
            for (int i = 0; i < table.Rows.Count; i++)
            {
                //Get a specified row
                TableRow row = table.Rows[i];
                
                //Create a TableCell object
                TableCell cell = new TableCell(table.Document);

                //Insert the cell as the third cell of the row
                row.Cells.Insert(2, cell);

                //Set the cell width
                row.Cells[2].SetCellWidth(40, CellWidthType.Point);

                //Add a cell to the end of the row
                row.AddCell();
            }
            
            //Save the result document
            doc.SaveToFile("AddColumns.docx", FileFormat.Docx2016);
            
        }
    }
}

Delete Rows and Columns from a Word Table in C#

To remove a specific row from a Word table, you can use the Table.Rows.RemoveAt() method directly. While to remove a specific column, you need to remove the corresponding cell from each table row using the TableRow.Cells.RemoveAt() method. The following are the detailed steps.

• Create a Document object.
• Load a Word document using Document.LoadFromFile() method.
• Get the first section using Document.Sections[] property.
• Get a specified table in the section using Section.Tables[] property.
• Remove a specific row from the table using Table.Rows.RemoveAt(int index) method.
• Loop through to get each row in the table.
• Remove a specific cell from each row using TableRow.Cells.RemoveAt(int index) method.
• Save the result document using Document.SaveToFile() method.

using Spire.Doc;

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

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

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

            //Get the first table in the section
            Table table = section.Tables[0] as Table;

            //Remove the 4th row
            table.Rows.RemoveAt(3);

            //Loop through the rows in the table
            for (int i = 0; i < table.Rows.Count; i++)
            {
                //Get a specified row
                TableRow row = table.Rows[i];

                //Remove the 2nd cell from the row
                row.Cells.RemoveAt(1);
            }

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

Apply for a Temporary License

If you'd like to remove the evaluation message from the generated documents, or to get rid of the function limitations, please request a 30-day trial license for yourself.

Spire.Spreadsheet is a .NET Excel viewer control that allows programmers to load Excel spreadsheet in Windows form, manipulate the data in it and save to file. This guide will introduce how to add Spire.Spreadsheet controls to Toolbox and how to create a Windows Form Application to display Excel spreadsheet.

Add Spire.Spreadsheet Controls to Toolbox

Right-click on the white space of the Toolbox – "Add Tab" - name the new Tab "Spire.Spreadsheet Controls":

Right-click on the blank part below "Spire.Spreadsheet Controls" - "Choose Items" - ".NET Framework Components" - "Browse" to the "Bin" folder - find the file "Spire.Spreadsheet.dll" - "Open".

Click "OK". Then you have added controls to Toolbox successfully.

Create a Windows Form Application to Display Spreadsheet

Create a Windows Form Application, drag Spreadsheet control to form1 and add an openToolStrip in menuStrip to open an Excel file.

Double click openToolStrip to write code. The spreadsheet1 that represents Spreadsheet control can easily load an Excel file by LoadFromFile() method.

private void openToolStripMenuItem_Click(object sender, EventArgs e)
{
    OpenFileDialog ofDialog = new OpenFileDialog();
    ofDialog.Filter = "All files|*.*|Microsoft Excel Files(*.xls;*.xlsx;*.ods;*.xlsb)|*.xls;*.xlsx;*.xlsb;*.ods";
    if (ofDialog.ShowDialog() == DialogResult.OK)
        spreadsheet1.LoadFromFile(ofDialog.FileName);
}

Run the program and open an existing Excel file, you’ll get following output:

It seems very easy to rotate the PDF page. However, we often find that the rotation is applied to the whole PDF document when we try to rotate a particular page. Is there an easy and fast way to rotate a certain PDF page within the DPF document?

In the following sections, I will demonstrate how to rotate a certain PDF page within PDF document in WPF with several lines of codes.

The code snippets are as followed:

Step 1: Initialize a new instance of PdfDocument class and load the PDF document from the file.

PdfDocument doc = new PdfDocument();
doc.LoadFromFile("LeavesOfGrass.pdf");

Step 2: For rotation, Spire.PDF enables you to define 0, 90, 180 and 270 degrees. In this example, my PDF file has five pages. I want to rotate the fifth page by 270 degrees and make other pages remain the same.

PdfPageBase page = doc.Pages[4];
page.Rotation = PdfPageRotateAngle.RotateAngle270;

Step 3: Save the PDF document and launch the file.

doc.SaveToFile("RotatedLeavesOfGrass.pdf");
System.Diagnostics.Process.Start("RotatedLeavesOfGrass.pdf");

Effective screenshot:

Full Codes:

using System.Windows;
using Spire.Pdf;

namespace Rotate_PDF_page
{
    /// 
    /// Interaction logic for MainWindow.xaml
    /// 
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, RoutedEventArgs e)
        {
            PdfDocument doc = new PdfDocument();
            doc.LoadFromFile("LeavesOfGrass.pdf");
            PdfPageBase page = doc.Pages[4];
            page.Rotation = PdfPageRotateAngle.RotateAngle270;
            doc.SaveToFile("RotatedLeavesOfGrass.pdf");
            System.Diagnostics.Process.Start("RotatedLeavesOfGrass.pdf");
        }
    }
}

Imports System.Windows
Imports Spire.Pdf

Namespace Rotate_PDF_page
	''' 
	''' Interaction logic for MainWindow.xaml
	''' 
	Public Partial Class MainWindow
		Inherits Window
		Public Sub New()
			InitializeComponent()
		End Sub

		Private Sub button1_Click(sender As Object, e As RoutedEventArgs)
			Dim doc As New PdfDocument()
			doc.LoadFromFile("LeavesOfGrass.pdf")
			Dim page As PdfPageBase = doc.Pages(4)
			page.Rotation = PdfPageRotateAngle.RotateAngle270
			doc.SaveToFile("RotatedLeavesOfGrass.pdf")
			System.Diagnostics.Process.Start("RotatedLeavesOfGrass.pdf")
		End Sub
	End Class
End Namespace