1.Add Com Reference,Microsoft.Office.Interop.Excel
2.
using Microsoft.Office.Interop.Excel; using System; using System.IO; using System.Runtime.CompilerServices; using Excel = Microsoft.Office.Interop.Excel; using System.Reflection; namespace ConsoleApp56 { internal class Program { static Excel.Application excelApp; string path = System.IO.Directory.GetCurrentDirectory(); static List<Book> booksList { get; set; } static void Main(string[] args) { Console.WriteLine("Hello, World!"); InitBooksList(); ExcelDemo(); } private static void InitBooksList() { booksList = new List<Book>(); for(int i=0;i<1000;i++) { booksList.Add(new Book() { Id=i, Author=$"Author_{i}", ISBN=$"ISBN_{i}", Name=$"Name_{i}", Summary=$"Summary_{i}", Title=$"Title_{i}", Topic=$"Topic_{i}" }); } } private static void ExcelDemo() { excelApp=new Excel.Application(); Workbook book = excelApp.Workbooks.Add(XlSheetType.xlWorksheet); if(book!=null) { var sheet = book.ActiveSheet; if(sheet!=null) { if(booksList!=null && booksList.Count()>0) { var props = typeof(Book).GetProperties(); var propsCount = props.Count(); int rowCount = booksList.Count; for(int i=0;i<rowCount;i++) { for(int j=0;j<propsCount;j++) { var strValue = props[j].GetValue(booksList[i])?.ToString(); sheet.Cells[i+1, j + 1] = strValue; } } } string fileName = System.IO.Path.Combine(System.IO.Directory.GetCurrentDirectory(), $"Excel_{DateTime.Now.ToString("yyyyMMddHHmmffff")}.xlsx"); book.SaveAs2(fileName); Console.WriteLine(fileName); } } Console.WriteLine("Finished"); } } public class Book { public int Id { get; set; } public string Author { get; set; } public string ISBN { get; set; } public string Name { get; set; } public string Summary { get; set; } public string Title { get; set; } public string Topic { get; set; } } }
标签:via,Office,Interop,Excel,System,content,using,Microsoft From: https://www.cnblogs.com/Fred1987/p/18382971