C# CsvExport

1.

Install-Package CsvExport

2.

复制代码
using Csv;
using System.Runtime.InteropServices;

namespace ConsoleApp8
{
    internal class Program
    {
        [DllImport("user32.dll", CharSet = CharSet.Unicode)]
        static extern int MessageBox(IntPtr hWnd, String text, String caption, uint type);

        static void Main(string[] args)
        {
            Task.Run(() =>
            {
                MonitorMemory();
            });
            CSVExportDemo();            
        }

        private static void MonitorMemory()
        {
            while (true)
            {
                var proc = System.Diagnostics.Process.GetCurrentProcess();
                Console.WriteLine($"proc.PrivateMemorySize64:{proc.PrivateMemorySize64}");
                Thread.Sleep(1000);
            }
        }

        static void CSVExportDemo()
        {
            List<Book> booksList = new List<Book>();
            for (int i = 0; i < 10000000; i++)
            {
                booksList.Add(new Book()
                {
                    Id = i + 1,
                    ISBN = $"ISBN_{i + 1},{Guid.NewGuid().ToString("N")}",
                    Name = $"Name_{i + 1}",
                    Title = $"Title_{i + 1}",
                    Topic = $"Topic_{i + 1}"
                });
            }

            string csvFile = "TestCsvExport.csv";
            var csvExport = new CsvExport(columnSeparator: ",", includeColumnSeparatorDefinitionPreamble: true, includeHeaderRow: true);
            csvExport.AddRows(booksList);
            string csvStr = csvExport.Export();
            csvExport.ExportToFile(csvFile);
            MessageBox(new IntPtr(0), $"Export list to {csvFile}", "CSVExport", 0);
            Console.WriteLine($"Export list to {csvFile}");
        }
    }

    public class Book
    {
        public int Id { get; set; }
        public string ISBN { get; set; }
        public string Name { get; set; }
        public string Title { get; set; }
        public string Topic { get; set; }
    }
}
复制代码

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

posted @   FredGrit  阅读(10)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 分享一个免费、快速、无限量使用的满血 DeepSeek R1 模型,支持深度思考和联网搜索!
· 基于 Docker 搭建 FRP 内网穿透开源项目(很简单哒)
· ollama系列01:轻松3步本地部署deepseek,普通电脑可用
· 25岁的心里话
· 按钮权限的设计及实现
历史上的今天:
2023-12-12 cmake
2023-12-12 mysql create store procedure for loops, and with parameters respectively
2021-12-12 C++ write and read file via fstream in ios::out,ios::in,ios::app mode
2021-12-12 C++ multi thread via pthread to retrieve returned result
2021-12-12 c++ multi pthread pass struct
2019-12-12 C# dictionary to bytes and bytes convert to dictionary
2019-12-12 C# get folder's Md5 generated by file's and filename's md5. get dictionary md5
点击右上角即可分享
微信分享提示