using IronXL; using System; using System.Linq; // Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV WorkBook workBook = WorkBook.Load("sample.xlsx"); // Select worksheet at index 0 WorkSheet workSheet = workBook.WorkSheets[0]; // Get any existing worksheet WorkSheet firstSheet = workBook.DefaultWorkSheet; // Select a cell and return the converted value int cellValue = workSheet["A2"].IntValue; // Read from ranges of cells elegantly. foreach (var cell in workSheet["A2:A10"]) { Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text); } // Calculate aggregate values such as Min, Max and Sum decimal sum = workSheet["A2:A10"].Sum(); // Linq compatible decimal max = workSheet["A2:A10"].Max(c => c.DecimalValue);

using IronSoftware.Drawing; using IronXL; using IronXL.Styles; using System.Linq; WorkBook workBook = WorkBook.Load("sample.xls"); WorkSheet workSheet = workBook.WorkSheets.First(); var range = workSheet["A1:H10"]; var cell = range.First(); // Set background color of the cell with an rgb string cell.Style.SetBackgroundColor("#428D65"); // Apply styling to the whole range. // Set underline property to the font // FontUnderlineType is enum that stands for different types of font underlying range.Style.Font.Underline = FontUnderlineType.SingleAccounting; // Define whether to use horizontal line through the text or not range.Style.Font.Strikeout = false; // Define whether the font is bold or not range.Style.Font.Bold = true; // Define whether the font is italic or not range.Style.Font.Italic = false; // Get or set script property of a font // Font script enum stands for available options range.Style.Font.FontScript = FontScript.Super; // Set the type of the border line // There are also TopBorder,LeftBorder,RightBorder,DiagonalBorder properties // BorderType enum indicates the line style of a border in a cell range.Style.BottomBorder.Type = BorderType.MediumDashed; // Indicate whether the cell should be auto-sized range.Style.ShrinkToFit = true; // Set alignment of the cell range.Style.VerticalAlignment = VerticalAlignment.Bottom; // Set border color range.Style.DiagonalBorder.SetColor("#20C96F"); // Define border type and border direction as well range.Style.DiagonalBorder.Type = BorderType.Thick; // DiagonalBorderDirection enum stands for direction of diagonal border inside cell range.Style.DiagonalBorderDirection = DiagonalBorderDirection.Forward; // Set background color of cells range.Style.SetBackgroundColor(Color.Aquamarine); // Set fill pattern of the cell // FillPattern enum indicates the style of fill pattern range.Style.FillPattern = FillPattern.Diamonds; // Set the number of spaces to intend the text range.Style.Indention = 5; // Indicate if the text is wrapped range.Style.WrapText = true; workBook.SaveAs("stylingOptions.xls");

Published November 15, 2023

C# Edit Word (Code Example Developer Tutorial)

Creating, editing, and managing Word documents is a frequent requirement for many applications. While there are several ways to create and edit a Word document in C#, one of the most powerful methods is using the Microsoft Interop services. With this tool, you can handle Word documents programmatically with much ease.

Prerequisites

Before setting up the environment and starting with the code, ensure you meet the following prerequisites:

Visual Studio: Ensure you have Visual Studio installed on your machine. If not, download and install it from the official Microsoft website.
Microsoft Word: Since we're using Microsoft Interop, you should have MS Word installed on your computer. The Interop service interfaces with the Microsoft Word application installed on your machine.
Basic C# Knowledge Understanding basic C#
.NET Framework: Ensure your Visual Studio supports the .NET Framework since our application will be based on it.

Setting up the Environment

Start by opening the Visual Studio application. Once open, you'll be greeted with a welcome screen.

1. Create a New .NET Framework Console Application

Click on "Create a new project".
Type "Console App (.NET Framework)" in the search box.
From the results, select "Console App (.NET Framework)" and click on the "Next" button.
Set a name for your project, then click the "Create" button.

After these steps, Visual Studio will generate a new .NET Framework console application for you. In the Program.cs file, you will find a basic template with a Main method, which is the entry point for console applications.

2. Install `Microsoft.Office.Interop.Word` using NuGet Package Manager

NuGet is a package manager for .NET, and it's integrated into Visual Studio. Here's how you can use it to install Microsoft.Office.Interop.Word package:

In Visual Studio, go to the "Tools" menu.
Select "NuGet Package Manager" and then "Manage NuGet Packages for Solution...".
In the NuGet window, click on the "Browse" tab.
In the search box, type Microsoft.Office.Interop.Word and hit enter.
From the search results, select Microsoft.Office.Interop.Word package.
On the right side, ensure your console application project is checked, then click on the "Install" button.

C# Edit Word (Code Example Developer Tutorial) Figure 1

Visual Studio will now install the package and add a reference to it in your project. This package contains the necessary assemblies and tools to interact with MS Word from your C# application.

Opening an Existing Word Document

Often, you may need to edit existing Word documents, the following example shows how to do this in C#:

var WordApp = new Microsoft.Office.Interop.Word.Application();
var WordDoc = WordApp.Documents.Open(@"path_to_your_document.docx");

var WordApp = new Microsoft.Office.Interop.Word.Application();
var WordDoc = WordApp.Documents.Open(@"path_to_your_document.docx");

Dim WordApp = New Microsoft.Office.Interop.Word.Application()
Dim WordDoc = WordApp.Documents.Open("path_to_your_document.docx")

VB C#

In the above code, replace path_to_your_document.docx with the path to your docx file.

Creating a New Word Document

To create Word documents from scratch:

var WordApp = new Microsoft.Office.Interop.Word.Application();
var WordDoc = WordApp.Documents.Add();

var WordApp = new Microsoft.Office.Interop.Word.Application();
var WordDoc = WordApp.Documents.Add();

Dim WordApp = New Microsoft.Office.Interop.Word.Application()
Dim WordDoc = WordApp.Documents.Add()

VB C#

This code snippet creates a new Word Document you can write and edit using C#.

Using C#

Adding Text to the Word Document

To add a new paragraph of text:

WordDoc.Paragraphs.Add();
WordDoc.Paragraphs[1].Range.Text = "This is the first paragraph.";

WordDoc.Paragraphs.Add();
WordDoc.Paragraphs[1].Range.Text = "This is the first paragraph.";

WordDoc.Paragraphs.Add()
WordDoc.Paragraphs(1).Range.Text = "This is the first paragraph."

VB C#

The Paragraphs.Add() method adds a new paragraph to the Word document and the Range.Text property assigns new text to it.

Editing Existing Text

For this tutorial, let's change the first paragraph:

WordDoc.Paragraphs[1].Range.Text = "This is the edited first paragraph.";

WordDoc.Paragraphs[1].Range.Text = "This is the edited first paragraph.";

WordDoc.Paragraphs(1).Range.Text = "This is the edited first paragraph."

VB C#

You can also add and edit other elements in the Word document using similar methods.

Saving and Closing the Document

Once you've made your desired edits:

WordDoc.SaveAs(@"path_where_you_want_to_save.docx");
WordDoc.Close();
WordApp.Quit();

WordDoc.SaveAs(@"path_where_you_want_to_save.docx");
WordDoc.Close();
WordApp.Quit();

WordDoc.SaveAs("path_where_you_want_to_save.docx")
WordDoc.Close()
WordApp.Quit()

VB C#

Replace path_where_you_want_to_save.docx with your desired path.

Complete Code and Example

Let's put it all together. Here's a complete code example demonstrating how to open an existing Word document, edit it, and then save the changes:

var WordApp = new Microsoft.Office.Interop.Word.Application();

// Open an existing document
var WordDoc = WordApp.Documents.Open(@"path_to_your_document.docx");

// Edit the first paragraph
WordDoc.Paragraphs[1].Range.Text = "This is the edited first paragraph.";

// Save and close
WordDoc.SaveAs(@"path_where_you_want_to_save.docx");
WordDoc.Close();
WordApp.Quit();

var WordApp = new Microsoft.Office.Interop.Word.Application();

// Open an existing document
var WordDoc = WordApp.Documents.Open(@"path_to_your_document.docx");

// Edit the first paragraph
WordDoc.Paragraphs[1].Range.Text = "This is the edited first paragraph.";

// Save and close
WordDoc.SaveAs(@"path_where_you_want_to_save.docx");
WordDoc.Close();
WordApp.Quit();

Dim WordApp = New Microsoft.Office.Interop.Word.Application()

' Open an existing document
Dim WordDoc = WordApp.Documents.Open("path_to_your_document.docx")

' Edit the first paragraph
WordDoc.Paragraphs(1).Range.Text = "This is the edited first paragraph."

' Save and close
WordDoc.SaveAs("path_where_you_want_to_save.docx")
WordDoc.Close()
WordApp.Quit()

VB C#

Introducing IronXL A Superior Alternative to Interop

While Interop provides powerful capabilities for working with Word and Excel, it has limitations. Enter IronXL, a versatile library optimized for .NET developers. IronXL offers a smoother experience than Interop, especially for editing Excel document tasks. Not only does it ensure compatibility and performance, but it also simplifies complex tasks with intuitive methods.

Insert New Rows & Columns

using IronXL;

// Load existing spreadsheet
WorkBook workBook = WorkBook.Load("sample.xlsx");
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Add a row before row 1
workSheet.InsertRow(0);

// Insert multiple rows before row 4
workSheet.InsertRows(3, 3);

// Add a column before column A
workSheet.InsertColumn(0);

// Insert multiple columns before column F
workSheet.InsertColumns(5, 2);

workBook.SaveAs("addRowAndColumn.xlsx");

using IronXL;

// Load existing spreadsheet
WorkBook workBook = WorkBook.Load("sample.xlsx");
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Add a row before row 1
workSheet.InsertRow(0);

// Insert multiple rows before row 4
workSheet.InsertRows(3, 3);

// Add a column before column A
workSheet.InsertColumn(0);

// Insert multiple columns before column F
workSheet.InsertColumns(5, 2);

workBook.SaveAs("addRowAndColumn.xlsx");

Imports IronXL

' Load existing spreadsheet
Private workBook As WorkBook = WorkBook.Load("sample.xlsx")
Private workSheet As WorkSheet = workBook.DefaultWorkSheet

' Add a row before row 1
workSheet.InsertRow(0)

' Insert multiple rows before row 4
workSheet.InsertRows(3, 3)

' Add a column before column A
workSheet.InsertColumn(0)

' Insert multiple columns before column F
workSheet.InsertColumns(5, 2)

workBook.SaveAs("addRowAndColumn.xlsx")

VB C#

Conclusion

In the realm of manipulating Word and Excel documents within .NET applications, choices abound. While Microsoft's Interop services have been a go-to for many, the emergence of solutions like IronXL signifies a shift towards more efficient and user-friendly tools.