Install-Package Spire.Doc

using System;
using System.Data;
using Spire.Doc;
using Spire.Doc.Documents;
using Spire.Doc.Fields;
using System.Drawing;

public class DataTableToWordExporter
{
    public static void ExportDataTableToWord(DataTable dataTable, string filePath)
    {
        // 1. 創(chuàng)建Word文檔對(duì)象
        Document document = new Document();
        Section section = document.AddSection();

        // 添加一個(gè)段落作為標(biāo)題
        Paragraph titleParagraph = section.AddParagraph();
        titleParagraph.Format.HorizontalAlignment = HorizontalAlignment.Center;
        TextRange titleText = titleParagraph.AppendText("產(chǎn)品銷售報(bào)表");
        titleText.CharacterFormat.FontSize = 20;
        titleText.CharacterFormat.Bold = true;
        section.AddParagraph().AppendText(Environment.NewLine); // 空行

        // 2. 準(zhǔn)備DataTable數(shù)據(jù) (此處為模擬數(shù)據(jù)，實(shí)際應(yīng)用中數(shù)據(jù)可能來自數(shù)據(jù)庫等)
        // 假設(shè)dataTable已由調(diào)用者提供

        // 檢查DataTable是否有數(shù)據(jù)
        if (dataTable == null || dataTable.Rows.Count == 0)
        {
            Paragraph noDataParagraph = section.AddParagraph();
            noDataParagraph.AppendText("沒有可用的數(shù)據(jù)進(jìn)行導(dǎo)出。");
            document.SaveToFile(filePath, FileFormat.Docx);
            Console.WriteLine("沒有數(shù)據(jù)，文檔已保存。");
            return;
        }

        // 3. 創(chuàng)建Word表格
        Table table = section.AddTable(true);
        table.ResetCells(dataTable.Rows.Count + 1, dataTable.Columns.Count); // +1 用于表頭

        // 4. 設(shè)置表格樣式
        // 設(shè)置表格邊框
        table.TableFormat.Borders.LineWidth = 1;
        table.TableFormat.Borders.BorderType = BorderStyle.Single;
        table.TableFormat.Borders.Color = Color.Black;

        // 設(shè)置表格整體寬度適應(yīng)頁面
        table.PreferredWidth = new PreferredWidth(WidthType.Percentage, 100);
        table.TableFormat.HorizontalAlignment = RowAlignment.Center;

        // 5. 填充表頭
        TableRow headerRow = table.Rows[0];
        headerRow.IsHeader = true; // 設(shè)置為表頭行
        headerRow.RowFormat.BackColor = Color.LightGray; // 表頭背景色
        headerRow.RowFormat.Height = 25; // 表頭行高
        headerRow.RowFormat.HeightType = TableRowHeightType.Exactly;

        for (int i = 0; i < dataTable.Columns.Count; i++)
        {
            headerRow.Cells[i].CellFormat.VerticalAlignment = VerticalAlignment.Middle;
            Paragraph p = headerRow.Cells[i].AddParagraph();
            p.Format.HorizontalAlignment = HorizontalAlignment.Center;
            TextRange tr = p.AppendText(dataTable.Columns[i].ColumnName);
            tr.CharacterFormat.Bold = true;
            tr.CharacterFormat.FontSize = 11;
        }

        // 6. 填充數(shù)據(jù)行
        for (int r = 0; r < dataTable.Rows.Count; r++)
        {
            TableRow dataRow = table.Rows[r + 1]; // +1 跳過表頭
            dataRow.RowFormat.Height = 20;
            dataRow.RowFormat.HeightType = TableRowHeightType.Exactly;

            for (int c = 0; c < dataTable.Columns.Count; c++)
            {
                dataRow.Cells[c].CellFormat.VerticalAlignment = VerticalAlignment.Middle;
                Paragraph p = dataRow.Cells[c].AddParagraph();
                p.Format.HorizontalAlignment = HorizontalAlignment.Center;
                TextRange tr = p.AppendText(dataTable.Rows[r][c].ToString());
                tr.CharacterFormat.FontSize = 10;
            }
        }

        // 7. 保存文檔
        try
        {
            document.SaveToFile(filePath, FileFormat.Docx);
            Console.WriteLine($"DataTable已成功導(dǎo)出到Word文檔: {filePath}");
        }
        catch (Exception ex)
        {
            Console.WriteLine($"導(dǎo)出Word文檔時(shí)發(fā)生錯(cuò)誤: {ex.Message}");
        }
    }

    public static void Main(string[] args)
    {
        // 模擬一個(gè)DataTable
        DataTable dt = new DataTable("Products");
        dt.Columns.Add("產(chǎn)品ID", typeof(int));
        dt.Columns.Add("產(chǎn)品名稱", typeof(string));
        dt.Columns.Add("單價(jià)", typeof(decimal));
        dt.Columns.Add("庫存量", typeof(int));
        dt.Columns.Add("上市日期", typeof(DateTime));

        dt.Rows.Add(101, "筆記本電腦", 8999.00m, 50, new DateTime(2023, 1, 15));
        dt.Rows.Add(102, "智能手機(jī)", 4599.00m, 120, new DateTime(2023, 3, 10));
        dt.Rows.Add(103, "無線耳機(jī)", 799.00m, 200, new DateTime(2023, 2, 20));
        dt.Rows.Add(104, "智能手表", 1299.00m, 80, new DateTime(2023, 4, 5));
        dt.Rows.Add(105, "便攜音箱", 399.00m, 150, new DateTime(2023, 5, 1));

        string outputPath = "ProductReport.docx";
        ExportDataTableToWord(dt, outputPath);

        // 演示無數(shù)據(jù)情況
        DataTable emptyDt = new DataTable("Empty");
        emptyDt.Columns.Add("ID");
        string emptyOutputPath = "EmptyReport.docx";
        ExportDataTableToWord(emptyDt, emptyOutputPath);
    }
}

// 示例：日期格式化
if (dataTable.Columns[c].DataType == typeof(DateTime))
{
    DateTime dateValue = (DateTime)dataTable.Rows[r][c];
    p.AppendText(dateValue.ToString("yyyy年MM月dd日"));
}
else
{
    p.AppendText(dataTable.Rows[r][c].ToString());
}

try
{
    // ... Word文檔生成邏輯 ...
    document.SaveToFile(filePath, FileFormat.Docx);
}
catch (Exception ex)
{
    // 記錄錯(cuò)誤日志，或向用戶顯示友好的錯(cuò)誤消息
    Console.Error.WriteLine($"導(dǎo)出Word文檔時(shí)發(fā)生錯(cuò)誤: {ex.Message}");
    // 可以在這里進(jìn)行進(jìn)一步的錯(cuò)誤處理，例如刪除部分生成的文檔
}