wpf 导出Datatable 到excel

最新推荐文章于 2024-08-09 23:25:09 发布

Louith

最新推荐文章于 2024-08-09 23:25:09 发布

阅读量3k

点赞数

文章标签： wpf stylesheet excel spreadsheet

本文链接：https://blog.csdn.net/Louith/article/details/20045843

版权

本文介绍如何在WPF应用中将DataTable数据导出到Excel文件，使用相关代码展示转换和导出过程。

摘要由CSDN通过智能技术生成

相关代码

using ConsoleApplication1.Export;
using DocumentFormat.OpenXml;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;
using System;
using System.Collections.Generic;
using System.Data;
using System.Diagnostics;

namespace ConsoleApplication1
{
    public class Student
    {
        public string Name { get; set; }
        public int StudentId { get; set; }
        public int Age { get; set; }
    }

    class ExportTest
    {
        private List<Student> Students = null;
        public ExportTest()
        {
            Students = new List<Student>(){
            new Student() { Name = "Jack", Age = 15, StudentId = 100 },
            new Student() { Name = "Smith", Age = 15, StudentId = 101 },
            new Student() { Name = "Smit", Age = 15, StudentId = 102 }
        };
            ListtoDataTableConverter converter = new ListtoDataTableConverter();
            DataTable dt = converter.ToDataTable(Students);
            this.ExporttoExcel(dt);
        }

        private void ExporttoExcel(DataTable table)
        {
            Console.WriteLine(CreateExcelDocument(table, @"D:\a.xlsx"));
        }

        /// <summary>
        /// Create an Excel file, and write it to a file.
        /// </summary>
        /// <param name="ds">DataSet containing the data to be written to the Excel.</param>
        /// <param name="excelFilename">Name of file to be written.</param>
        /// <returns>True if successful, false if something went wrong.</returns>
        public static bool CreateExcelDocument(DataTable ds, string excelFilename)
        {
            try
            {
                using (SpreadsheetDocument document = SpreadsheetDocument.Create(excelFilename, SpreadsheetDocumentType.Workbook))
                {
                    WriteExcelFile(ds, document);
                }
                Trace.WriteLine("Successfully created: " + excelFilename);
                return true;
            }
            catch (Exception ex)
            {
                Trace.WriteLine("Failed, exception thrown: " &