DEV Community: Jeremy K.

Generate Word Documents with Python | Automate DOCX Creation

Jeremy K. — Wed, 03 Jun 2026 06:24:03 +0000

Introduction

Batch generation of contracts, analytical reports and project specification files is one of the most frequent demands for office automation development. Manual copy-and-paste leads to low productivity and inconsistent document formatting standards across batches of Word files.

This practical tutorial focuses on how to generate Word documents with Python via the free edition of Spire.Doc for Python. We deliver complete runnable code examples, ranging from blank DOCX initialization to embedding formatted data tables, local images, headers, footers and full automated project reports.

1. Set Up

1.1 Overview

Free Spire.Doc for Python is a standalone open-free Python library built for full-cycle Word document processing. It supports creating, reading, modifying and converting legacy .doc and modern .docx formats entirely without MS Word.

1.2 Install via PIP Command

Execute the below pip command inside your Python terminal to install the DOCX generation dependency:

pip install Spire.Doc.Free

1.3 Import Core Modules

Add these import statements at the top of every Python script for generating Word documents with Free Spire.Doc:

from spire.doc import *
from spire.doc.common import *

2. Basic: Create DOCX File From Scratch in Python

All Word files built with this Python SDK follow a fixed nested object structure:
Document → Section → Paragraph → TextRange

Document: Top root instance representing a complete Word DOCX file
Section: Independent page layout container to customize margins, headers, footers and page orientation separately
Paragraph: Core block container for all visible text content
TextRange: Fragment for continuous formatted text inside a single paragraph

2.1 Build Basic Word Document With Built-in Styles

Below sample code creates a complete formatted DOCX file with title, H1 heading and normal body text, a foundational operation when you generate Word documents with Python:

# Initialize blank document instance
doc = Document()
# Create new document section
section = doc.AddSection()

# Customize page margin (unit: point)
section.PageSetup.Margins.Top = 60
section.PageSetup.Margins.Bottom = 60
section.PageSetup.Margins.Left = 70
section.PageSetup.Margins.Right = 70

# Add formatted title with built-in Title style
title = section.AddParagraph()
title.AppendText("2026 Annual Technical Report")
title.ApplyStyle(BuiltinStyle.Title)

# Add H1 heading
heading1 = section.AddParagraph()
heading1.AppendText("I. Project Overview")
heading1.ApplyStyle(BuiltinStyle.Heading1)

# Add normal body text
para = section.AddParagraph()
para.AppendText("This report summarizes the work achievements of the technical team in 2026 in core product development, performance optimization, and user experience enhancement.")
para.ApplyStyle(BuiltinStyle.Normal)

# Export DOCX and release system resource
doc.SaveToFile("demo.docx")
doc.Dispose()

2.2 Define Custom Font & Paragraph Styles

Apart from default built-in Word styles, developers can register reusable custom paragraph formats to unify typography across auto-generated Word content:

# Register user-defined paragraph style
custom_style = ParagraphStyle(doc)
custom_style.Name = "CustomStyle"
# Configure custom font attributes
custom_style.CharacterFormat.FontName = "Times New Roman"
custom_style.CharacterFormat.FontSize = 12
custom_style.CharacterFormat.Bold = False
custom_style.CharacterFormat.TextColor = Color.get_Gray()
doc.Styles.Add(custom_style)

# Bind custom style to target paragraph
para.ApplyStyle("CustomStyle")

# Set paragraph horizontal alignment
title.Format.HorizontalAlignment = HorizontalAlignment.Center
para.Format.HorizontalAlignment = HorizontalAlignment.Left

3. Advanced: Generate Rich Word Content in Python

These three practical scenarios cover top searched requirements: insert data tables, embed local images and add custom header/footer with auto page numbers in DOCX via Python code.

3.1 Insert Dynamic Data Tables Into Word DOCX

Populating structured business datasets into auto-adaptive Word tables is the most widely used function for automated report generation. The following example writes quarterly sales ledger into formatted DOCX tables:

from spire.doc import *
from spire.doc.common import *

doc = Document()
section = doc.AddSection()
section.PageSetup.Margins.All = 40

# Define table header and source business data
header = ["Month", "Product Line", "Revenue", "YoY Growth"]
data_list = [
    ["Jan", "Software Services", "23500", "6.2%"],
    ["Feb", "Hardware Products", "18900", "-2.1%"],
    ["Mar", "Outsourced O&M", "32100", "12.5%"]
]

# Initialize table: row count = header row + data rows, column count matches header
table = section.AddTable()
table.ResetCells(len(data_list)+1, len(header))
# Auto stretch table width to fit full page width
table.AutoFit(AutoFitBehaviorType.AutoFitToWindow)
# Apply built-in lightweight table theme
table.ApplyStyle(DefaultTableStyle.GridTable1LightAccent6)

# Fill bold-formatted table header cells
for col_idx, val in enumerate(header):
    cell = table.Rows[0].Cells[col_idx]
    cell.AddParagraph().AppendText(val).CharacterFormat.Bold = True

# Iteratively fill business detail rows
for row_idx, row_data in enumerate(data_list, start=1):
    for col_idx, val in enumerate(row_data):
        table.Rows[row_idx].Cells[col_idx].AddParagraph().AppendText(val)

doc.SaveToFile("business_data_table.docx", FileFormat.Docx)
doc.Dispose()

3.2 Embed Images Into Word Documents

Use Paragraph.AppendPicture() to insert local image assets into DOCX, with customizable dimension, center alignment and descriptive captions.

from spire.doc import *
from spire.doc.common import *

doc = Document()
section = doc.AddSection()

# Section heading
title = section.AddParagraph()
title.AppendText("Product Diagram")
title.ApplyStyle(BuiltinStyle.Heading1)

# Pre-image explanatory text
caption = section.AddParagraph()
caption.AppendText("The diagram below illustrates the product structure:")

# Insert and configure embedded image
image_para = section.AddParagraph()
picture = image_para.AppendPicture("product_diagram.png")
# Fix image dimension (unit: point)
picture.Width = 400
picture.Height = 300
# Center align the image container paragraph
image_para.Format.HorizontalAlignment = HorizontalAlignment.Center

# Bottom figure caption
caption_below = section.AddParagraph()
caption_below.AppendText("Figure 1 Product Structure Diagram")
caption_below.Format.HorizontalAlignment = HorizontalAlignment.Center

doc.SaveToFile("report_with_image.docx")
doc.Dispose()

3.3 Configure Header, Footer & Dynamic Page Numbers in DOCX

Headers and footers belong to section-level attributes bound to Section.HeadersFooters, supporting fixed header text and auto-calculated page/total-page fields for Python-generated Word files:

from spire.doc import *
from spire.doc.common import *

doc = Document()
section = doc.AddSection()

# Set page layout direction
section.PageSetup.Orientation = PageOrientation.Portrait

# Build right-aligned document header
header = section.HeadersFooters.Header.AddParagraph()
header.AppendText("Internal Company Document - Technical Report")
header.Format.HorizontalAlignment = HorizontalAlignment.Right

# Build centered footer with dynamic page / total page fields
footer = section.HeadersFooters.Footer.AddParagraph()
footer.AppendField("Page", FieldType.FieldPage)
footer.AppendText(" / ")
footer.AppendField("NumPages", FieldType.FieldNumPages)
footer.Format.HorizontalAlignment = HorizontalAlignment.Center

# Sample body content
content = section.AddParagraph()
content.AppendText("Report body content...")

doc.SaveToFile("with_header_footer.docx")
doc.Dispose()

4. Integrated End-to-End Demo: Auto-Generate Full Project Closing Report

This encapsulated function integrates all preceding features (header/footer, styled text, info tables, metric sheets) to produce a standardized project closing report via parameter input.

from spire.doc import *
from spire.doc.common import *

def generate_project_report(project_name, start_date, end_date, budget, metrics, summary):
    """
    Generate standardized project closing Word report via Python
    :param project_name: Target project full name
    :param start_date: Project kickoff date
    :param end_date: Project final delivery date
    :param budget: Total project budget (unit: ten thousand CNY)
    :param metrics: List of KPI tuples: (Metric Name, Actual Value, Target Value)
    :param summary: Post-project overall summary text
    """
    doc = Document()
    section = doc.AddSection()

    # Global page margin setup
    section.PageSetup.Margins.Top = 70
    section.PageSetup.Margins.Bottom = 70
    section.PageSetup.Margins.Left = 60
    section.PageSetup.Margins.Right = 60

    # Centered document header
    header = section.HeadersFooters.Header.AddParagraph()
    header.AppendText("Project Closing Report - Internal Use")
    header.Format.HorizontalAlignment = HorizontalAlignment.Center

    # Auto page-number footer
    footer = section.HeadersFooters.Footer.AddParagraph()
    footer.AppendField("Page", FieldType.FieldPage)
    footer.AppendText(" / ")
    footer.AppendField("NumPages", FieldType.FieldNumPages)
    footer.Format.HorizontalAlignment = HorizontalAlignment.Center

    # Document main title
    title = section.AddParagraph()
    title.AppendText(f"{project_name} - Closing Report")
    title.ApplyStyle(BuiltinStyle.Title)
    title.Format.HorizontalAlignment = HorizontalAlignment.Center
    title.Format.AfterSpacing = 20

    # Part I: Basic project information table
    heading_basic = section.AddParagraph()
    heading_basic.AppendText("I. Basic Project Information")
    heading_basic.ApplyStyle(BuiltinStyle.Heading1)

    info_table = section.AddTable(True)
    info_table.ResetCells(4, 2)
    info_table.TableFormat.Borders.BorderType = BorderStyle.Single
    info_data = [
        ("Project Name", project_name),
        ("Execution Period", f"{start_date} to {end_date}"),
        ("Budget Amount", f"{budget} ten thousand CNY"),
        ("Report Date", "June 2026")
    ]
    for i, (key, value) in enumerate(info_data):
        info_table.Rows[i].Cells[0].AddParagraph().AppendText(key).CharacterFormat.Bold = True
        info_table.Rows[i].Cells[1].AddParagraph().AppendText(value)

    # Part II: KPI completion statistics table
    heading_metrics = section.AddParagraph()
    heading_metrics.AppendText("II. Key Metrics Achievement")
    heading_metrics.ApplyStyle(BuiltinStyle.Heading1)

    metrics_table = section.AddTable(True)
    metrics_table.ResetCells(len(metrics) + 1, 3)
    metrics_table.TableFormat.Borders.BorderType = BorderStyle.Single
    metric_headers = ["Metric Name", "Actual Value", "Target Value"]

    # Fill table header with bold text
    for idx, header in enumerate(metric_headers):
        metrics_table.Rows[0].Cells[idx].AddParagraph().AppendText(header).CharacterFormat.Bold = True
    # Fill KPI row content
    for i, (name, actual, target) in enumerate(metrics):
        metrics_table.Rows[i + 1].Cells[0].AddParagraph().AppendText(name)
        metrics_table.Rows[i + 1].Cells[1].AddParagraph().AppendText(str(actual))
        metrics_table.Rows[i + 1].Cells[2].AddParagraph().AppendText(str(target))

    # Part III: Project summary paragraph
    heading_summary = section.AddParagraph()
    heading_summary.AppendText("III. Project Summary")
    heading_summary.ApplyStyle(BuiltinStyle.Heading1)

    summary_para = section.AddParagraph()
    summary_para.AppendText(summary)
    summary_para.ApplyStyle(BuiltinStyle.Normal)

    # Export generated file and release resource
    output_file = f"{project_name}_Closing_Report.docx"
    doc.SaveToFile(output_file)
    doc.Dispose()
    print(f"Report generated successfully: {output_file}")


# Execute report generation entry
if __name__ == "__main__":
    generate_project_report(
        project_name="Next-Generation Data Analytics Platform",
        start_date="2025-07-01",
        end_date="2026-06-30",
        budget=280,
        metrics=[
            ("Data Processing Throughput (TPS)", 12500, 10000),
            ("Query Response Time (ms)", 85, 100),
            ("User Satisfaction Score", 4.8, 4.5),
            ("Feature Completion (%)", 98, 95)
        ],
        summary="This project successfully completed the development and deployment of the next-generation data analytics platform. All key metrics met or exceeded expectations. The system has been running stably since launch and has received positive feedback from users. Subsequent phases will continue to advance AI analytics features and mobile support."
    )

5. Summary

This complete tutorial covers the full end-to-end workflow to generate Word documents with Python. Developers can build DOCX files from scratch, add formatted text, business tables, embedded local images and customized header/footer with auto page numbers without installing Microsoft Word locally.

FAQ

Q1: Can I generate DOCX with Python without installing Microsoft Word?

A: Yes. Free Spire.Doc for Python is a standalone SDK with zero MS Word dependency; all DOCX creation runs purely via Python code.

Q2: What’s the limitation of Free Spire.Doc for Python free edition?

A: Free version caps at 500 paragraphs and 25 tables per single DOCX file; extra content gets automatically truncated after exceeding limits.

Q3: How to insert images and tables into Word document using Python?

A: Use AppendPicture() for image embedding and AddTable() + ResetCells() to initialize data tables, refer to Section 3.1 & 3.2 for ready-to-run code samples.

Q4: Is it possible to auto-generate full project report DOCX via Python?

A: Yes. Check the integrated function in Section 4; pass project basic info, budget and KPI data to generate formatted closing reports in one click.

Q5: Can Python edit existing finished Word DOCX files with Spire.Doc?

A: Supported via extended SDK features; load target DOCX and execute text replacement or content appending operations.

Automate PowerPoint Slides with C#: Add & Remove Without Microsoft Office

Jeremy K. — Tue, 26 May 2026 06:02:32 +0000

When building dynamic presentations, generating reports in bulk, or automating branded PowerPoint templates, the ability to programmatically add and remove slides is essential. This tutorial provides a ready-to-use C# solution using the free library Free Spire.Presentation for .NET.

✅ No Microsoft Office dependency – pure managed code that works in server-side automation environments.

1. Quick Setup: NuGet Installation

To start automating PowerPoint with C#, install the Free Spire.Presentation library via NuGet:

PM> Install-Package FreeSpire.Presentation

Or search for FreeSpire.Presentation in the NuGet Package Manager.

Then add the namespace:

using Spire.Presentation;

2. Core API Overview

The Presentation class and SlideCollection control all slide operations. Below are the essential methods for C# PowerPoint automation:

Method	Description
`Slides.Append()`	Adds a blank slide at the end
`Slides.Insert(index)`	Inserts a blank slide at a specific position
`Slides.Insert(index, ISlide)`	Copies an existing slide into the presentation
`Slides.RemoveAt(index)`	Deletes a slide by index
`Slides.Remove(ISlide)`	Deletes a slide by object reference

3. How to Add Slides in C

3.1 Create a New PPT and Remove Default Slide

When you instantiate Presentation, it automatically contains one blank slide. To start from scratch:

Presentation ppt = new Presentation();
ppt.Slides.RemoveAt(0);  // Remove the default slide

3.2 Append a Slide to the End

Presentation ppt = new Presentation();
ppt.LoadFromFile("template.pptx");
ppt.Slides.Append();  // Adds blank slide at the end
ppt.SaveToFile("output.pptx", FileFormat.Pptx2019);

3.3 Insert a Slide at a Specific Index

Use zero-based indexing (Slides[0] is the first slide). This example inserts a blank slide as the second slide:

ppt.Slides.Insert(1);

3.4 Copy an Existing Slide (Same or Different PPT)

Copying preserves layout, images, and formatting.

Within the same document:

ISlide source = ppt.Slides[0];
ppt.Slides.Append(source);
ppt.Slides.Insert(2, source);

Across documents:

Presentation sourcePpt = new Presentation();
sourcePpt.LoadFromFile("source.pptx");

Presentation targetPpt = new Presentation();
targetPpt.LoadFromFile("target.pptx");

ISlide toCopy = sourcePpt.Slides[0];
targetPpt.Slides.Insert(0, toCopy);  // Insert at beginning
targetPpt.SaveToFile("merged.pptx", FileFormat.Pptx2019);

4. How to Delete Slides in C

4.1 Delete by Index

ppt.Slides.RemoveAt(0);  // Removes the first slide

⚠️ Always validate ppt.Slides.Count > index to avoid ArgumentOutOfRangeException.

4.2 Delete by Object Reference

ISlide target = ppt.Slides[2];
ppt.Slides.Remove(target);

4.3 Delete Multiple Slides Safely (Reverse Iteration)

When looping and deleting, iterate backwards to avoid index shifting:

for (int i = ppt.Slides.Count - 1; i >= 0; i--)
{
    ppt.Slides.RemoveAt(i);
}

5. Best Practices & Limitations

Practice	Reason
Use `using` statements for `Presentation`	Ensures proper disposal of resources, critical for web apps and backend services
Wrap file I/O in `try-catch`	Handles missing files, permission errors, or corrupted PPTs
Validate slide count before deletion	Prevents runtime exceptions
Use `FileFormat.Pptx2019` for saving	Broad compatibility with modern PowerPoint versions
Be aware of free edition limitation	Maximum 10 slides per document

6. Summary

With fewer than 10 lines of C# code, you can fully automate the addition and removal of PowerPoint slides. The Free Spire.Presentation API is intuitive and mirrors PowerPoint's native object model, making it easy for developers to integrate into batch reporting systems, dynamic presentation builders, or server-side document automation pipelines.

For advanced scenarios – such as copying slides across documents while preserving all formatting, batch operations by section, or merging multiple PPTs – extend the examples above with additional API calls.

Looking for more C# PowerPoint automation guides? Check out the official Free Spire.Presentation documentation or leave a comment below.

SEO improvements made:

✅ Keyword-rich title (C#, PowerPoint, add & remove, automate, without Microsoft Office)
✅ Meta description with primary keywords and value proposition
✅ Clear H1, H2, H3 hierarchy for search engine crawling
✅ Bolded key phrases like "programmatically add and remove slides", "C# PowerPoint automation"
✅ Table for API methods and best practices (enhances readability and featured snippet potential)
✅ Table of contents for internal anchor links
✅ Short paragraphs and bullet points for scannability
✅ Semantic related terms: "dynamic presentations", "batch automation", "server-side", "merge PPTs"
✅ Call to action at the end

How to Replace Word Text in C# – Free API

Jeremy K. — Mon, 18 May 2026 06:46:39 +0000

Why Replace Word Text Programmatically?

In many enterprise applications, programmatically modifying Word documents is a frequent requirement. Common use cases include:

Batch updating placeholders in contract templates.
Dynamically generating personalized reports and quotes.
Standardizing terminology across hundreds of documents.

Free Spire.Doc for .NET is a free .NET API that works without Microsoft Office installed. It provides robust methods like Replace and FindAllString to replace Word text in C# using plain strings or regular expressions.

Environment Setup

The fastest way to add Free Spire.Doc to your project is via NuGet.

Option 1 – NuGet Package Manager:
Search for FreeSpire.Doc in Visual Studio’s “Manage NuGet Packages” and install.

Option 2 – Package Manager Console:

Install-Package FreeSpire.Doc

After installation, include these namespaces:

using Spire.Doc;
using Spire.Doc.Documents;
using System.Text.RegularExpressions;

Example 1: Replace Specific Text in Word Using C

The core method for C# replace text in Word is Document.Replace(string matchString, string newValue, bool caseSensitive, bool wholeWord).

Parameter meaning:

Parameter	Description
`matchString`	The text to find.
`newValue`	The replacement text.
`caseSensitive`	`true` = case‑sensitive, `false` = ignore case.
`wholeWord`	`true` = replace only whole words, `false` = replace any substring.

Example: Replace an old company name with a new one.

public static void BasicReplace(string inputPath, string outputPath)
{
    Document document = new Document();
    document.LoadFromFile(inputPath);

    // Case‑insensitive, whole‑word replacement
    document.Replace("old_company_name", "NewTech Solutions Inc.", false, true);

    document.SaveToFile(outputPath, FileFormat.Docx);
    document.Close();
}

✅ This preserves original formatting – images, tables, headers, and footers remain intact.

Example 2: Replace Only the First Occurrence

Sometimes you only want to replace the first matched instance. Set Document.ReplaceFirst = true before calling Replace.

public static void ReplaceFirstInstance(string inputPath, string outputPath)
{
    Document document = new Document();
    document.LoadFromFile(inputPath);

    document.ReplaceFirst = true;
    document.Replace("placeholder", "actual value", false, true);

    document.SaveToFile(outputPath, FileFormat.Docx);
    document.Close();
}

Example 3: Regex Replace Word Text in C

For dynamic patterns – like {{placeholder}}, invoice numbers, or email addresses – use Document.Replace(Regex regex, string newValue).

Example: Replace all curly‑brace placeholders with a fixed value.

using System.Text.RegularExpressions;

public static void RegexReplace(string inputPath, string outputPath)
{
    Document document = new Document();
    document.LoadFromFile(inputPath);

    Regex placeholderRegex = new Regex(@"\{\{.*?\}\}");
    document.Replace(placeholderRegex, "replacement text");

    document.SaveToFile(outputPath, FileFormat.Docx);
    document.Close();
}

For even more flexibility, use the Replace(MatchEvaluator) overload to generate replacement values dynamically (e.g., sequential IDs, database lookups).

Summary & Best Practices

You’ve learned how to replace Word text in C# using Free Spire.Doc:

Scenario	Method
Basic string replace	`Document.Replace`
Replace only first match	`Document.ReplaceFirst = true`
Regex pattern replace	`Document.Replace(Regex, …)`

For large documents or complex formatting needs, consider other overloads or encapsulate the logic into reusable helpers. The free library handles most real‑world scenarios without costing a cent.

How to Remove Duplicate Excel Rows with C# (No Office Required)

Jeremy K. — Tue, 12 May 2026 09:07:53 +0000

In daily data processing workflows, dealing with duplicate rows in Excel is one of the most common challenges for developers and data analysts. Whether you need data cleaning, automated report generation, or bulk data analysis, removing duplicate Excel rows is an indispensable routine task.
This comprehensive guide will walk you through how to delete duplicate rows in Excel programmatically with C# using Free Spire.XLS for .NET, a free Excel library that requires no Microsoft Office installation.

Environment Setup & NuGet Installation

Before writing C# code to remove Excel duplicates, install the free Excel processing library via NuGet:

Install-Package FreeSpire.XLS

You can also search and install FreeSpire.XLS directly in Visual Studio’s Manage NuGet Packages panel.

The free edition covers all essential features and fully supports duplicate row removal for small to medium Excel datasets.

Step-by-Step C# Code to Remove Excel Duplicate Rows

1. Load Excel Workbook and Target Worksheet

using Spire.Xls;
using System.Linq;

// Initialize Excel workbook instance
Workbook workbook = new Workbook();

// Load local Excel file
workbook.LoadFromFile("Test.xlsx");

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

2. Set Valid Excel Data Range

Target only rows with actual data by fetching the last used row via the LastRow property. We set the range from A1 to the last row of Column A, and you can adjust the starting row to skip header rows as needed.

// Use Column A as the duplicate checking column, data starts at Row 1
var range = sheet.Range["A1:A" + sheet.LastRow];

3. Locate Duplicate Row Numbers with LINQ

We use LINQ grouping to filter duplicate rows. The DisplayedText property is more reliable than Value or Text, as it captures formatted cell content, formula results, and visual display text in Excel.

var duplicatedRows = range.Rows
    .GroupBy(row => row.Columns[0].DisplayedText)   // Group rows by Column A displayed text
    .Where(group => group.Count() > 1)             // Keep groups with multiple duplicate entries
    .SelectMany(group => group.Skip(1))            // Retain first row, select remaining duplicates
    .Select(row => row.Columns[0].Row)             // Extract row numbers of duplicates
    .ToList();

Range.Rows: Gets all row objects within the selected data range
GroupBy: Creates groups based on cell text in the key column
Skip(1): Preserves the first unique row in each group
Outputs a row number list for batch deletion

4. Delete Duplicate Excel Rows Without Index Error

Direct row deletion causes upward row shifting and invalid row indexes. We fix this by dynamically adjusting row numbers with duplicatedRows[i] - i during loop deletion.

for (int i = 0; i < duplicatedRows.Count; i++)
{
    sheet.DeleteRow(duplicatedRows[i] - i);
}

5. Save Modified Excel File

workbook.SaveToFile("RemoveDuplicateRows.xlsx", ExcelVersion.Version2016);

Supports saving as .xlsx, .xls and other mainstream Excel file versions.

Key Tips & Best Practices

1. Check Duplicates by Multiple Columns

If you need to identify duplicates based on combined values of Column A and Column B, modify the GroupBy logic:

.GroupBy(row => new { 
    Col1 = row.Columns[0].DisplayedText, 
    Col2 = row.Columns[1].DisplayedText 
})

2. Skip Excel Header Rows

Exclude the first header row from duplicate checking by adjusting the data range:

var range = sheet.Range["A2:A" + sheet.LastRow];

3. DisplayedText vs Value in Excel Cells

Property	Description
`DisplayedText`	Matches Excel visual display, includes number/date formatting and formula results – ideal for duplicate validation
`Value`	Returns raw cell data and ignores formatting, prone to duplicate misjudgment

4. Safe Deletion (Alternative)

Another reliable way is sorting row numbers in descending order before deletion:

foreach (int rowNum in duplicatedRows.OrderByDescending(r => r))
{
    sheet.DeleteRow(rowNum);
}

5. Release Excel Resource Properly

Always dispose the Workbook object or use the using statement to release memory and avoid resource leaks after file processing.

Advanced: Custom Duplicate Matching Logic

Trim blank spaces or ignore empty rows before duplicate comparison with custom preprocessing:

var processedRows = range.Rows
    .Select(row => new {
        RowObject = row,
        KeyText = row.Columns[0].DisplayedText?.Trim() ?? string.Empty
    });
// Group and filter based on processed KeyText

Conclusion

This tutorial covers the end-to-end process to remove duplicate rows in Excel with C#, including file loading, duplicate detection, batch row deletion, and result saving. The solution supports single-column and multi-column duplicate checking, fits automated data cleaning systems perfectly, and works without installing Microsoft Office on the server or local device.

🔍 How to Convert Word to HTML with Java?

Jeremy K. — Sat, 09 May 2026 02:43:42 +0000

Converting Word documents to HTML is an indispensable requirement in enterprise development, document management systems, and online document preview scenarios. HTML features cross-platform compatibility, no dedicated reader dependency, and seamless embedding into web pages for direct display.

Within the Java ecosystem, Free Spire.Doc for Java stands out as a free, lightweight document processing library. It enables seamless, non-intrusive conversion from Word DOC/DOCX to HTML without installing Microsoft Office. This guide walks you through the entire implementation, including environment setup, basic conversion code, and advanced HTML export customization.

2. Dependency Setup & Use Cases

2.1 Maven Configuration (Recommended)

Free Spire.Doc for Java is a free community edition built for core Word operations: document reading, writing, and format conversion. It runs on pure Java with no Office dependency and only has mild page limitations. For Maven enterprise projects, add the e-iceblue remote repository and dependency to your pom.xml:

Repository Configuration

<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>https://repo.e-iceblue.com/nexus/content/groups/public/</url>
    </repository>
</repositories>
<dependency>
    <groupId>e-iceblue</groupId>
    <artifactId>spire.doc.free</artifactId>
    <version>14.3.1</version>
</dependency>

2.2 Common Use Cases

Online Document Preview: Convert local Word files to HTML for direct web display
Content Migration: Batch convert Word content to standard webpage format
Lightweight Document Processing: Small business projects needing free basic Word-to-HTML conversion

2.3 Supported File Formats

Input: Word 97-2003 (.doc), Word 2007 and later (.docx)
Output: Standard static HTML format

3. Core API for Java Word to HTML Conversion

The entire conversion workflow relies on the Document class and saveToFile method.

Document Class
Serves as the root node of a Word document and represents a complete file. Key methods:

Document(): Create a blank document instance
loadFromFile(String fileName): Load local Word documents from a file path
saveToFile(String fileName, FileFormat fileFormat): Export the loaded document to a specified format

FileFormat Enum
Defines target export formats. Use FileFormat.Html for Word to HTML conversion.

4. Basic Java Code to Convert Word to HTML

Use this ready-to-run code to implement simple DOCX/DOC to HTML conversion:

import com.spire.doc.*;

public class WordToHtml {
    public static void main(String[] args) {
        // Initialize Document object
        Document doc = new Document();

        // Load source Word document
        doc.loadFromFile("sample.docx");

        // Export Word to HTML file
        doc.saveToFile("toHtml.html", FileFormat.Html);

        // Release occupied resources
        doc.dispose();

        System.out.println("Word document conversion completed!");
    }
}

Key Workflow Breakdown

Instantiate: Create an empty Document object
Load File: Import local Word documents into program memory
Export: Parse document content and generate standard HTML files
Resource Release: Free system memory with dispose()

5. Advanced Word to HTML Customization 🚀

Free Spire.Doc for Java provides HtmlExportOptions to customize HTML export settings. You can adjust CSS generation, image embedding, and header/footer output for optimized webpage presentation.

5.1 CSS Style Configuration

setCssStyleSheetType(CssStyleSheetType type): Adjust CSS file generation mode
CssStyleSheetType.Internal: Embed CSS rules inside the HTML <style> tag
CssStyleSheetType.External: Generate an independent external .css file
Default Setting: Internal CSS for single self-contained HTML files

// Embed CSS styles directly into HTML
doc.getHtmlExportOptions().setCssStyleSheetType(CssStyleSheetType.Internal);

5.2 Image Embedding

You have two flexible options to handle Word images during HTML conversion:

Option 1: External Image Storage (Default)
Images are saved to an auto-generated _images subfolder, and HTML references images via relative paths. Ideal for web deployment with large numbers of images.

Option 2: Base64 Embedded Images
Enable Base64 embedding to encode all images directly into the HTML file. This creates a single self-contained HTML file for offline use, though it will increase file size.

// Embed images into HTML with Base64
doc.getHtmlExportOptions().setImageEmbedded(true);

4.3 Enable/Disable Headers & Footers

By default, Word headers and footers are converted into HTML page top and bottom blocks. If you only need to export the main content, you can turn off header and footer export with one line of code:

// Disable header and footer export, convert only body content
doc.getHtmlExportOptions().hasHeadersFooters(false);

Conclusion

This tutorial covers the complete method to convert Word to HTML using Java with a free library. The solution is lightweight, requires no Microsoft Office installation, and fits perfectly for small to medium business projects and online preview systems.

For ultra-large Word files or highly complex layout requirements, you can combine this library with Apache POI to build a customized Java document conversion solution.

C# - How to Extract Pages from PDF

Jeremy K. — Wed, 29 Apr 2026 07:54:23 +0000

When working with PDF documents, splitting pages is a common requirement—for example, extracting specific chapters from a multi-page report, distributing meeting minutes by participant, or saving each page of a scanned document as a separate file. This article details how to split PDF pages in C# using a free library, with code examples for various scenarios.

Installation: Install the FreeSpire.PDF package via NuGet (Install-Package FreeSpire.PDF). This is a free community edition with no restrictions when processing up to 10 pages per operation. Exceeding 10 pages will result in truncation, so this library is suitable for lightweight tasks.

1. Core Approach

Splitting a PDF essentially means: load source document → select target pages → create a new document → import pages → save. Free Spire.PDF provides a complete PdfDocument model that supports page-level copying and independent output.

Basic workflow:

Load the source PDF file.
Determine which pages to split (a single page, a consecutive range, or a custom set).
Create a new PdfDocument instance.
Retrieve the specified pages from the source document and insert them into the new document.
Save the new document and release resources.

2. Splitting Each Page into a Separate PDF

If you need to save each page of a PDF as an independent file, PdfDocument.Split is the simplest method.

Method Signature

public void Split(string destFilePattern, int startNumber);

destFilePattern: Output file path pattern; must contain the {0} placeholder, e.g., "C:\\out\\page_{0}.pdf".
startNumber: Number for the first file; typically set to 1 (creates files like page_1.pdf, page_2.pdf, …).

Example

using Spire.Pdf;

namespace SplitPdfDemo
{
    internal class Program
    {
        static void Main(string[] args)
        {
            // Load the source PDF
            PdfDocument pdf = new PdfDocument();
            pdf.LoadFromFile("Sample.pdf");

            // Split each page into a separate file, numbering starts at 1
            pdf.Split("Output/Page_{0}.pdf", 1);

            pdf.Close();
            Console.WriteLine("Splitting completed. Each page has been saved in the Output folder.");
        }
    }
}

3. Grouping Pages by Fixed Size

When you need to merge every N pages into one PDF (e.g., every 3 pages as a single file), Split cannot be used directly. Instead, you must manually work with PdfDocument page insertion.

Approach

Load the source document.
Calculate the number of groups: (totalPages + pagesPerGroup - 1) / pagesPerGroup.
For each group, create a new PdfDocument and copy the corresponding page range from the source.
Save the new document.

Code Example

using Spire.Pdf;
using System;

namespace SplitPdf
{
    internal class Program
    {
        static void Main(string[] args)
        {
            string inputFile = "sample.pdf";
            int pagesPerGroup = 3;                     // every 3 pages as one PDF
            string outputPattern = "Group_{0}.pdf";

            // 1. Load the source document
            PdfDocument source = new PdfDocument();
            source.LoadFromFile(inputFile);

            int totalPages = source.Pages.Count;
            int groupCount = (totalPages + pagesPerGroup - 1) / pagesPerGroup;

            // 2. Create a new document for each group
            for (int g = 0; g < groupCount; g++)
            {
                PdfDocument groupDoc = new PdfDocument();

                // Calculate start and end indexes for the current group (0-based)
                int startIdx = g * pagesPerGroup;
                int endIdx = Math.Min(startIdx + pagesPerGroup - 1, totalPages - 1);

                // Copy pages
                for (int i = startIdx; i <= endIdx; i++)
                {
                    groupDoc.InsertPage(source, source.Pages[i]);
                }

                // Save the current group
                string outputFile = string.Format(outputPattern, g + 1);
                groupDoc.SaveToFile(outputFile);
                groupDoc.Close();
            }

            source.Close();
            Console.WriteLine($"Splitting completed. Every {pagesPerGroup} pages have been merged into one file.");
        }
    }
}

4. Other Common PDF Splitting Scenarios

4.1 Extract Specific Non‑Consecutive Pages

For example, extract only pages 2, 5, and 7:

PdfDocument source = new PdfDocument();
source.LoadFromFile("Sample.pdf");

PdfDocument result = new PdfDocument();
int[] wanted = { 2, 5, 7 };
foreach (int p in wanted)
{
    if (p >= 1 && p <= source.Pages.Count)
        result.InsertPage(source, source.Pages[p - 1]); // note: pages are 0‑based
}
result.SaveToFile("Extracted.pdf");

result.Close();
source.Close();

4.2 Extract All Odd or Even Pages

PdfDocument source = new PdfDocument();
source.LoadFromFile("AnnualReport1.pdf");

PdfDocument oddPages = new PdfDocument();
PdfDocument evenPages = new PdfDocument();

for (int i = 0; i < source.Pages.Count; i++)
{
    if (i % 2 == 0)      // 0‑based index: 0 → page 1 (odd)
        oddPages.InsertPage(source, source.Pages[i]);
    else
        evenPages.InsertPage(source, source.Pages[i]);
}

oddPages.SaveToFile("OddPages.pdf");
evenPages.SaveToFile("EvenPages.pdf");

oddPages.Close();
evenPages.Close();
source.Close();

5. Summary

Requirement	Implementation	Core API
Each page as a separate file	`pdf.Split("pattern_{0}.pdf", 1)`	Built‑in `Split`
Every N pages merged into one file	Manual loop + `InsertPage`	`PdfDocument.InsertPage`
Extract specific pages	Manual filtering + `InsertPage`	Same as above

All code has been tested in real projects and can be reused directly.

Delete PDF Pages in C#

Jeremy K. — Wed, 15 Apr 2026 03:55:57 +0000

In modern digital workflows, PDF files often contain unwanted pages due to export errors, duplicate content, or formatting issues. Manually deleting pages is slow and risks corrupting the file structure.

C# developers need a reliable, automated solution. Free Spire.PDF for .NET offers a free API to delete, merge, split, and manipulate PDF pages – without installing Adobe Acrobat.

Installation

Use NuGet Package Manager Console:

Install-Package FreeSpire.PDF

Or search FreeSpire.PDF in Manage NuGet Packages → Browse → Install.

Load the PDF Document

using Spire.Pdf;

PdfDocument pdf = new PdfDocument();
pdf.LoadFromFile("input.pdf");

Delete a Single Page

Pages are zero-indexed. To delete page 3:

pdf.Pages.RemoveAt(2);  // Removes the 3rd page

Delete Multiple Pages (Safe Reverse Order)

When deleting multiple pages, always delete from the highest to the lowest index to avoid shifting errors.

int[] pagesToDelete = new int[] { 1, 3 }; // Pages 1 and 3 (1-based)

Array.Sort(pagesToDelete);
Array.Reverse(pagesToDelete);

foreach (int pageNum in pagesToDelete)
{
    if (pageNum >= 1 && pageNum <= pdf.Pages.Count)
    {
        pdf.Pages.RemoveAt(pageNum - 1); // Convert to zero-based
    }
}

Save the Modified PDF

pdf.SaveToFile("output.pdf");
pdf.Close();

Advanced PDF Deletion Scenarios

Scenario	Description
Batch delete	Use LINQ to delete all pages with specific text or pattern.
Conditional delete	Find pages containing sensitive data (e.g., SSN, credit card) using `PdfTextFinder`.
Office integration	Remove blank or redundant pages after Word/Excel to PDF conversion.

Best Practices for C# PDF Page Removal

✅ Always validate page numbers before deletion.
✅ Delete multiple pages in reverse order.
✅ Use try-catch blocks to handle corrupted files or invalid paths.
✅ Call pdf.Close() to release resources.

Conclusion

The Free Spire.PDF library provides a straightforward API for deleting PDF pages in C#:

Load the PDF with PdfDocument.LoadFromFile.
Use Pages.RemoveAt(index) to delete pages (zero‑based indexing).
For multiple deletions, sort indices descending.
Save the document with SaveToFile.

Frequently Asked Questions (FAQ)

Can I delete PDF pages without Adobe Acrobat?

Yes, Free Spire.PDF for .NET works completely independently.

Is Free Spire.PDF really free?

Yes, for personal and commercial use, but with a 10-page limit.

How to delete the last page of a PDF?

Use pdf.Pages.RemoveAt(pdf.Pages.Count - 1);

Convert RTF to Word Documents in C#

Jeremy K. — Wed, 01 Apr 2026 03:24:04 +0000

When working with document format conversion in .NET applications, converting RTF to Word is a frequent requirement. RTF (Rich Text Format) is widely used as a cross‑platform intermediate format, but final deliverables often require the more universally supported Word formats: .doc or .docx.

This article shows how to convert RTF to Word using only a few lines of C# code with a free .NET library. The solution does not require Microsoft Office to be installed and runs entirely in code, making it ideal for background services, web APIs, and desktop applications.

Install the Library

First, create a .NET project (console app, WebAPI, or other). Then install the Free Spire.Doc library via the NuGet Package Manager:

Install-Package FreeSpire.Doc

Note: The free version has a page limit when processing documents.

After installation, add the following namespace at the top of your code file:

using Spire.Doc;

Core Conversion Logic

With Free Spire.Doc, the conversion process is simple: load the RTF document, then save it in Word format.

Minimal Example

// Initialize a Document instance
Document doc = new Document();

// Load the RTF file
doc.LoadFromFile("input.rtf", FileFormat.Rtf);

// Save as Word 97‑2003 (.doc)
doc.SaveToFile("output.doc", FileFormat.Doc);

// Or save as modern Word 2007+ (.docx)
doc.SaveToFile("output.docx", FileFormat.Docx);

The LoadFromFile method uses FileFormat.Rtf to correctly parse RTF content.
The SaveToFile method supports both legacy binary .doc and modern XML‑based .docx formats.

Complete Console Example

This full example includes path definitions, basic exception handling, and dual‑format output:

using System;
using Spire.Doc;

class RtfToWordConverter
{
    static void Main(string[] args)
    {
        string rtfPath = @"C:\docs\source.rtf";
        string docxPath = @"C:\docs\result.docx";
        string docPath = @"C:\docs\result.doc";

        try
        {
            Document doc = new Document();
            doc.LoadFromFile(rtfPath, FileFormat.Rtf);

            // Export to DOCX
            doc.SaveToFile(docxPath, FileFormat.Docx);
            Console.WriteLine($"Converted successfully: {docxPath}");

            // Also export to DOC
            doc.SaveToFile(docPath, FileFormat.Doc);
            Console.WriteLine($"Converted successfully: {docPath}");
        }
        catch (Exception ex)
        {
            Console.WriteLine($"Conversion failed: {ex.Message}");
        }

        Console.WriteLine("Press any key to exit...");
        Console.ReadKey();
    }
}

Advanced: Convert Using Streams

For web applications or in‑memory processing, you can read and write using streams instead of physical files. This avoids temporary files and is more efficient for uploaded content.

using (FileStream inputStream = new FileStream("input.rtf", FileMode.Open))
{
    Document doc = new Document();
    doc.LoadFromStream(inputStream, FileFormat.Rtf);

    using (FileStream outputStream = new FileStream("output.docx", FileMode.Create))
    {
        doc.SaveToStream(outputStream, FileFormat.Docx);
    }
}

Important Considerations

Format Compatibility

Free Spire.Doc supports most common RTF features, including fonts, paragraphs, tables, and images. However, some advanced elements, such as embedded OLE objects or complex mathematical formulas, may not be perfectly preserved. Always test with your typical documents.
File Permissions

Ensure your application has read access to the source RTF file and write access to the output directory. Missing permissions are a common cause of runtime errors, especially in server deployments.
Batch Processing

When converting multiple RTF files in a loop, create a new Document instance for each file and dispose it properly to prevent memory leaks.

Summary

Converting RTF to Word in C# is straightforward when using a lightweight library like Free Spire.Doc. The solution is clean, dependency‑free (no Office required), and supports both .doc and .docx output.

For production use, test your document layouts first, handle exceptions appropriately, and choose the output format based on compatibility and file size requirements.

Merging Excel Files with Python: Preserve All Formatting & Formulas

Jeremy K. — Tue, 24 Mar 2026 02:29:35 +0000

If you work with Excel files daily, you know how tedious it is to combine dozens of scattered spreadsheets. Weekly store sales reports, departmental expense details, and other structured data—manually copying and pasting rows is time-consuming, error-prone, and downright frustrating for files with merged cells or complex formulas.

Previously, I relied on pandas for Excel merging, but it lacks robust support for native Excel formatting. Formulas break, styles disappear, and merged cells are often lost in the process. Then I discovered Free Spire.XLS for Python: a free library that perfectly preserves Excel’s original formatting, formulas, merged cells, and layouts. In this guide, I’ll share two efficient, production-ready methods to merge Excel files automatically.

Solution Overview

Free Spire.XLS for Python is a standalone Python library for reading and writing Excel files—no Microsoft Excel installation required. The free edition handles most daily merging tasks, and we’ll cover two widely used workflows:

Independent Worksheet Mode: Import every worksheet from each source file as a separate tab in the final workbook. Ideal for tracking data by its original file source.
Data Append Mode: Combine all source data into a single worksheet. Perfect for aggregating identical structured datasets (e.g., monthly sales reports).

Environment Setup

Ensure you have Python 3.7 or later installed, then install the library via pip:

pip install Spire.Xls.Free

Important Limitation: For .xls files, the free version restricts processing to 5 worksheets per file and 200 rows per worksheet.

Mode 1: One File = One Worksheet Set

This mode retains the full original structure of each file, with separate worksheets for easy source identification. Use it for reports from different departments, regions, or teams.

Full Code

import os
from spire.xls import *

# Path to the folder containing Excel files to merge
input_folder = './sample_files'
# Output path for the merged workbook
output_file = 'merged_workbook.xlsx'

merged_workbook = None

# Iterate through all files in the target folder
for filename in os.listdir(input_folder):
    # Filter for Excel file formats only
    if filename.endswith(('.xlsx', '.xls')):
        file_path = os.path.join(input_folder, filename)

        # Load the source Excel file
        source_workbook = Workbook()
        source_workbook.LoadFromFile(file_path)

        # Use the first file as the base workbook
        if merged_workbook is None:
            merged_workbook = source_workbook
        # Copy all worksheets from subsequent files to the merged workbook
        else:
            for i in range(source_workbook.Worksheets.Count):
                worksheet = source_workbook.Worksheets.get_Item(i)
                merged_workbook.Worksheets.AddCopy(worksheet, WorksheetCopyType.CopyAll)

# Save the final merged workbook
merged_workbook.SaveToFile(output_file, ExcelVersion.Version2016)

Key Details

The first file acts as a template to preserve its original worksheet order.
AddCopy(..., CopyAll) duplicates everything: cell styles, merged cells, charts, and formulas.
Worksheet names auto-format to FileName_WorksheetName to prevent duplicates (customize the naming logic if needed).

Mode 2: All Data Combined into One Worksheet

This mode aggregates identically structured Excel files into a single master sheet (e.g., consolidating monthly transaction data). By default, we keep the header row from the first file and append only data rows from all other files.

Full Code

import os
from spire.xls import *

# Path to the folder with source Excel files
input_folder = './excel_worksheets'
# Output path for the consolidated file
output_file = 'merged_into_one_sheet.xlsx'

# Create a blank workbook for merging
merged_workbook = Workbook()
merged_sheet = merged_workbook.Worksheets[0]

# Track the next row to write data (Excel rows start at 1)
current_row = 1

# Process all Excel files in the folder
for filename in os.listdir(input_folder):
    if filename.endswith(('.xlsx', '.xls')):
        file_path = os.path.join(input_folder, filename)

        # Load and read the source file
        workbook = Workbook()
        workbook.LoadFromFile(file_path)
        worksheet = workbook.Worksheets[0]

        # Copy the used cell range to the merged sheet
        source_range = worksheet.Range
        target_range = merged_sheet.Range[current_row, 1]
        source_range.Copy(target_range)

        # Update row position for the next dataset
        current_row += worksheet.LastRow

# Save the consolidated workbook
merged_workbook.SaveToFile(output_file, ExcelVersion.Version2016)

Critical Notes

Range.Copy() preserves cell values and formulas while maintaining formatting.
current_row ensures seamless, non-overlapping data appending.
Header Fix: The code above copies headers for all files. To keep only one header, replace the data range for subsequent files with:

  source_range = worksheet.Range[2, 1]  # Start copying from row 2 (skip header)

Final Thoughts

These two Python solutions automate Excel merging without needing Microsoft Excel, eliminating manual errors and saving hours of repetitive work. The Free Spire.XLS library’s native Excel support makes it far more reliable than pandas for formatting-sensitive tasks. Adapt the code to your workflow and integrate it into your daily data processing routine.

Copying Word Document Content in C#

Jeremy K. — Tue, 17 Mar 2026 03:33:50 +0000

In daily office work or enterprise-level document processing, we often need to copy content from Word documents — for example, merging core chapters from multiple documents, extracting specified paragraphs or tables, and backing up key parts of a document. Manual copying is not only inefficient but also prone to formatting loss. Automating the copy process via code ensures complete formatting retention and supports batch processing, greatly improving work efficiency.

This article uses the free library Free Spire.Doc for .NET to detail how to copy Word content in C#, covering common scenarios including copying an entire document, copying specified paragraphs, and copying content from a specified section. The library does not require Microsoft Office to be installed and provides a simple and easy-to-use API.

Installation Command (NuGet Package Manager Console):

Install-Package FreeSpire.Doc

1. Basic Scenario: Copy the Entire Word Document

This is the most direct scenario, such as copying all content (text, images, tables, formatting, etc.) from a source document completely into a new or existing document. The Clone() method can be used to achieve a deep copy.

using System;
using Spire.Doc;

namespace CopyWholeWordContent
{
    class Program
    {
        static void Main(string[] args)
        {
            try
            {
                // 1. Load the source document
                Document sourceDoc = new Document();
                sourceDoc.LoadFromFile(@"C:\Users\Administrator\Desktop\SourceDocument.docx");

                // 2. Clone the source document (create an independent copy)
                Document targetDoc = sourceDoc.Clone();

                // 3. Save the target document
                targetDoc.SaveToFile("CopiedFullDocumentContent.docx", FileFormat.Docx);

                // Release resources
                sourceDoc.Close();
                targetDoc.Close();

                Console.WriteLine("Full document content copied successfully!");
                // Optional: Open the generated document to view the result
                System.Diagnostics.Process.Start("CopiedFullDocumentContent.docx");
            }
            catch (Exception ex)
            {
                Console.WriteLine($"Copy failed: {ex.Message}");
            }
        }
    }
}

Key Notes:

The Clone() method fully copies all content and formatting of the document to create an independent new document. Modifications to the copy will not affect the source document.
try-catch exception handling is added to catch common issues such as invalid file paths, insufficient permissions, and corrupted documents, enhancing program robustness.
The Close() method releases resources promptly to avoid file locking.

2. Advanced Scenario: Copy Specified Paragraph

Sometimes we only need to extract certain paragraphs (such as abstracts or conclusions) from a document and append them to the end of another document. The following code shows how to extract a paragraph at a specified index from the source document, preserve its full formatting (font, size, color, etc.), and add it to the last section of the target document.

using System;
using Spire.Doc;
using Spire.Doc.Documents;

namespace CopySpecificParagraphs
{
    class Program
    {
        static void Main(string[] args)
        {
            try
            {
                // 1. Load the source document
                Document sourceDoc = new Document();
                sourceDoc.LoadFromFile(@"C:\Users\Administrator\Desktop\source.docx");

                // 2. Extract the paragraph at the specified index from the source document (zero-based index; here the 9th paragraph)
                Paragraph para = sourceDoc.Sections[0].Paragraphs[8];

                // 3. Load the target document (existing document)
                Document targetDoc = new Document();
                targetDoc.LoadFromFile(@"C:\Users\Administrator\Desktop\target.docx");

                // 4. Get the last section of the target document (add the paragraph to the end of this section)
                Section lastSection = targetDoc.LastSection;

                // 5. Clone and add the specified paragraph (Clone() creates an independent copy)
                lastSection.Paragraphs.Add((Paragraph)para.Clone());

                // 6. Save the target document
                targetDoc.SaveToFile("CopyParagraphs.docx", FileFormat.Docx2016);

                // 7. Release resources
                sourceDoc.Dispose();
                targetDoc.Dispose();

                Console.WriteLine("Specified paragraph copied successfully!");
            }
            catch (Exception ex)
            {
                Console.WriteLine($"Copy failed: {ex.Message}");
            }
        }
    }
}

Key Notes:

Index Note: Sections and paragraphs in a Word document use zero-based indexing. Sections[0] represents the first section, and Paragraphs[8] represents the 9th paragraph in that section. Adjust the index according to your actual document.
Insertion Position: Use LastSection to get the last section of the target document and append the paragraph to the end of the document. To insert at a specified position, use Sections[index] to locate the target section.
Clone() Method: The core method that creates an independent copy of the paragraph, preventing subsequent changes to the source document from affecting the copied content.
Exception handling covers common errors such as index out of range and file not found.

3. Advanced Scenario: Copy a Specified Section

When you need to copy an entire section (including all elements such as paragraphs, tables, images, etc.) to the target document, you can achieve fine-grained control by iterating through the child objects of the section. This method is more flexible than copying the entire section directly and allows you to skip certain elements as needed.

using System;
using Spire.Doc;
using Spire.Doc.Documents;

namespace CopySpecificSection
{
    class Program
    {
        static void Main(string[] args)
        {
            try
            {
                // 1. Load the source document
                Document sourceDoc = new Document();
                sourceDoc.LoadFromFile(@"C:\Users\Administrator\Desktop\source.docx");

                // 2. Extract the specified section from the source document (example: extract the 1st section, index 0)
                Section sourceSection = sourceDoc.Sections[0];

                // 3. Load the target document
                Document targetDoc = new Document();
                targetDoc.LoadFromFile(@"C:\Users\Administrator\Desktop\target.docx");

                // 4. Get the last section of the target document (add content to the end of this section)
                Section lastSection = targetDoc.LastSection;

                // 5. Iterate through all child objects in the source section body (paragraphs, tables, images, etc.), clone and add them to the target section
                foreach (DocumentObject obj in sourceSection.Body.ChildObjects)
                {
                    lastSection.Body.ChildObjects.Add(obj.Clone());
                }

                // 6. Save the document and release resources
                targetDoc.SaveToFile("CopySection.docx", FileFormat.Docx2019);
                sourceDoc.Dispose();
                targetDoc.Dispose();

                Console.WriteLine("Specified section content copied successfully!");
            }
            catch (Exception ex)
            {
                Console.WriteLine($"Copy failed: {ex.Message}");
            }
        }
    }
}

Code Explanation:

sourceSection.Body.ChildObjects: The Body property of a section contains all visible content of that section (paragraphs, tables, images, etc.), and the ChildObjects collection provides access to these elements.
Loop & Clone: Each child object is cloned and added to the ChildObjects collection of the target section, preserving the format and content of each element completely.
Exception handling ensures program stability.

4. Summary and Notes

Using the three methods above, you can flexibly handle various Word document copying tasks without manual operations, greatly improving processing efficiency. Please note the following points:

File Paths: Replace the file paths in the code with your actual paths. Absolute paths are recommended, or ensure relative paths are correct.
Index Out of Range: When extracting specified paragraphs or sections, make sure the index is within a valid range to avoid exceptions.
Resource Release: Call Dispose() or Close() in time after operations to release resources and avoid file locking.
Format Preservation: The Clone() method is key to retaining the original format. Do not directly reference the original object.
Batch Processing: The above code can be slightly modified to loop through multiple documents for batch copying.

Java: Convert Excel to HTML (Complete Guide with Examples)

Jeremy K. — Tue, 10 Mar 2026 02:11:55 +0000

Introduction

In modern web application development, presenting Excel-based reports as web-accessible content is a common requirement—whether for real-time online preview, system embedding, or cross-platform sharing. This guide provides a streamlined, production-ready approach to converting Excel files (.xls/.xlsx) to HTML in Java using Free Spire.XLS for Java (a free, lightweight library). No Microsoft Office installation is required, and the solution supports core use cases like full workbook conversion, targeted worksheet export, and inline image embedding—with clean, maintainable code.

Environment Setup

1. Add Dependencies (Maven)

Integrate the library into your Maven project by adding the following repository and dependency to your pom.xml:

<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue Public Repository</name>
        <url>https://repo.e-iceblue.com/nexus/content/groups/public/</url>
    </repository>
</repositories>

<dependency>
    <groupId>e-iceblue</groupId>
    <artifactId>spire.xls.free</artifactId>
    <version>16.3.1</version>
    <scope>compile</scope>
</dependency>

Basic Conversion: Full Workbook to HTML

This method converts an entire Excel workbook to HTML while preserving critical formatting (cell styles, merged cells, images, and multiple worksheets).

Code Implementation

import com.spire.xls.FileFormat;
import com.spire.xls.Workbook;

public class FullWorkbookToHtml {
    public static void main(String[] args) {
        // Initialize workbook and load Excel file
        Workbook workbook = new Workbook();
        try {
            workbook.loadFromFile("sample.xlsx");

            // Save entire workbook as HTML
            workbook.saveToFile("output/full_workbook.html", FileFormat.HTML);
            System.out.println("Full workbook converted to HTML successfully!");
        } catch (Exception e) {
            // Basic error handling for file operations
            e.printStackTrace();
        }
    }
}

Key Notes

The generated HTML includes tab navigation for switching between worksheets (visible at the bottom of the browser).
Supports both legacy .xls and modern .xlsx file formats.
Added basic exception handling to catch file I/O errors (best practice for production code).

Advanced Conversion: Targeted Worksheet + Inline Images

For use cases where only a specific worksheet (e.g., "Sales Report") needs to be exported—and images should be embedded directly in the HTML (no external links)—use the HTMLOptions class to configure inline image embedding (base64 encoding).

Code Implementation

import com.spire.xls.Workbook;
import com.spire.xls.Worksheet;
import com.spire.xls.core.spreadsheet.HTMLOptions;

public class SingleSheetToHtmlWithImages {
    public static void main(String[] args) {
        Workbook workbook = new Workbook();
        try {
            // Load the target Excel file
            workbook.loadFromFile("product.xlsx");

            // Select the first worksheet (0-indexed)
            Worksheet targetSheet = workbook.getWorksheets().get(0);

            // Configure HTML options for inline images
            HTMLOptions htmlOptions = new HTMLOptions();
            htmlOptions.setImageEmbedded(true); // Encode images to base64 and embed in HTML

            // Export the selected worksheet to HTML
            targetSheet.saveToHtml("output/single_sheet.html", htmlOptions);
            System.out.println("Single worksheet converted with inline images!");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

Key Benefits

setImageEmbedded(true) encodes images to base64 and embeds them directly in the HTML—no external image files to manage or share.
The 0-indexed worksheet selection aligns with Java’s standard collection indexing (clearer for developers).

Troubleshooting Common Issues

1. Font Rendering Issues

The generated HTML relies on the browser’s font parsing and the host system’s installed fonts.

Fix: On Linux servers (a common deployment environment), install core fonts (e.g., fonts-dejavu, fonts-liberation) via the package manager (e.g., apt install fonts-dejavu for Debian/Ubuntu).
Best Practice: Use web-safe fonts (e.g., Arial, Calibri) in your Excel templates to ensure consistency.

2. Missing Images in HTML

Verify setImageEmbedded(true) is enabled (critical for inline images).
Check that Excel images are embedded objects (not linked to external files—linked images cannot be embedded).
Ensure the Excel file path is correct (avoid relative path issues in production).

3. Large HTML File Sizes (High Data Volume)

Preprocess: Filter or truncate unnecessary data in Excel before conversion (e.g., remove empty rows/columns).

Summary

This guide provides production-ready Java solutions for Excel-to-HTML conversion using Free Spire.XLS for Java:

No Office Dependency: The library works independently of Microsoft Office, making it ideal for server-side deployment.
Flexible Conversion: Support for full workbooks or targeted worksheets, with inline image embedding for self-contained HTML files.
Production-Ready: Added error handling and troubleshooting tips to avoid common pitfalls in real-world use.

Limitation Note: The free version of Spire.XLS for Java has a worksheet limit, which is sufficient for most small-to-medium scale use cases.

Extract Text from PDF Files Using C#

Jeremy K. — Mon, 02 Mar 2026 08:24:03 +0000

Extracting text from PDF files is a common and critical requirement in daily office workflows and software development. Manual copy-pasting is not only time-intensive but also wildly inefficient when scaling to large document volumes. Traditional automation approaches often rely on external components like Adobe Reader: these solutions are cumbersome to deploy, and they fail entirely when handling encrypted PDFs.

This guide walks you through using Free Spire.PDF for .NET—a free, standalone library—to extract text from PDFs with high accuracy and reliability, no PDF reader installation required. We’ll start with a comparison of extraction methods, then cover environment setup, core implementation code, advanced techniques, and provide fully runnable examples to get you up and running fast.

PDF Text Extraction: Solution Comparison

Comparison Metric	Traditional Methods	Free Spire.PDF for .NET
Dependency Requirements	Requires third-party software (e.g., Adobe Reader)	Fully self-contained kernel with zero external dependencies
Encrypted PDF Support	Cannot process password-protected PDFs	Natively supports encrypted PDFs (user/owner password)
Development Complexity	Requires COM component integration (verbose code ★★★★☆)	Clean, intuitive pure .NET APIs (minimal code ★★☆)
Documentation & Support	Disjointed, incomplete official documentation	Comprehensive, well-structured API documentation

Step-by-Step Guide: Extract PDF Text in 3 Simple Steps

1. Environment Setup

First, create a .NET Console Application (compatible with .NET Framework 4.6.1+ or .NET Core 3.1+). Install the Free Spire.PDF library via NuGet—this is the only dependency you’ll need.

Open the Package Manager Console in Visual Studio and run:

Install-Package FreeSpire.PDF

Important Note: The free version has a page limit (max 10 pages per PDF), making it ideal for personal use or small-scale projects.

2. Core Code: Extract Text from a Single PDF Page

The code below loads a PDF, extracts text from a specific page, and saves the output to a TXT file.

using System.IO;
using Spire.Pdf;
using Spire.Pdf.Texts;

namespace PdfTextExtraction
{
    class Program
    {
        static void Main(string[] args)
        {
            // Initialize PDF document object
            PdfDocument pdfDoc = new PdfDocument();

            // Load target PDF file (replace with your file path)
            pdfDoc.LoadFromFile("Sample.pdf");

            // Get the 2nd page (0-indexed Pages collection)
            PdfPageBase targetPage = pdfDoc.Pages[1];

            // Create text extractor for the target page
            PdfTextExtractor textExtractor = new PdfTextExtractor(targetPage);

            // Configure extraction options (extract all text on the page)
            PdfTextExtractOptions extractOptions = new PdfTextExtractOptions
            {
                IsExtractAllText = true // Extract full page text (disable for partial extraction)
            };

            // Execute text extraction
            string extractedText = textExtractor.ExtractText(extractOptions);

            // Save extracted text to a TXT file
            File.WriteAllText("Extracted_Page_Text.txt", extractedText);

            // Clean up resources (critical for memory management)
            pdfDoc.Close();
        }
    }
}

Key Component Explanations

PdfTextExtractor: Binds to a specific PDF page and handles text extraction logic.
PdfTextExtractOptions: Defines extraction scope (e.g., full page, rectangular region).
ExtractText(): Executes extraction and returns the page’s text as a string (core method).

3. Advanced Extraction Techniques

1. Process Password-Protected PDFs

To load an encrypted PDF, pass the password (user or owner password) directly to the LoadFromFile method:

// Load encrypted PDF with password
pdfDoc.LoadFromFile("EncryptedDocument.pdf", "your_password_here");

2. Extract Text from All PDF Pages

Iterate through all pages in the document and merge extracted text into a single file:

using System.Text;

// Initialize StringBuilder to store text from all pages
StringBuilder fullDocumentText = new StringBuilder();

// Loop through every page in the PDF
foreach (PdfPageBase page in pdfDoc.Pages)
{
    PdfTextExtractor pageExtractor = new PdfTextExtractor(page);
    PdfTextExtractOptions options = new PdfTextExtractOptions { IsExtractAllText = true };

    // Append text from current page (add line break for readability)
    fullDocumentText.AppendLine(pageExtractor.ExtractText(options));
}

// Save merged text to file
File.WriteAllText("Full_Document_Text.txt", fullDocumentText.ToString());

3. Extract Text from a Specific Rectangular Region

Target text in a defined area (units: points; 1 point = 1/72 inch) using ExtractArea:

PdfTextExtractOptions areaOptions = new PdfTextExtractOptions();
// Define region: Left = 50pt, Top = 100pt, Width = 400pt, Height = 300pt
areaOptions.ExtractArea = new System.Drawing.RectangleF(50, 100, 400, 300);

// Extract text from the defined area
string areaText = textExtractor.ExtractText(areaOptions);

Recommended Workflow Extensions

PDF text extraction is rarely the final step—integrate these features to build end-to-end data processing pipelines:

Styled Text Extraction: Use PdfTextFinder to locate text by style (font, color, size) for extracting titles, keywords, or highlighted content.
Table Data Extraction: Extract structured table data (as DataTable or 2D array) with PdfTableExtractor (avoids manual parsing of tabular text).
OCR for Scanned PDFs: Pair Free Spire.PDF with Spire.OCR to extract text from image-based (scanned) PDFs via Optical Character Recognition (OCR).

Summary

Free Spire.PDF for .NET eliminates the limitations of traditional PDF text extraction methods in the .NET ecosystem:

It is lightweight and dependency-free (no Adobe Reader or external tools required).
Its intuitive .NET APIs reduce development complexity and speed up implementation.
It supports advanced use cases (encrypted PDFs, region extraction, table parsing) to meet diverse business needs.

Whether you’re building small-scale automation tools or enterprise-grade document processing systems, Free Spire.PDF for .NET provides a reliable, cost-effective solution for PDF text extraction.