如何将大数据保存到文件

发布于 2024-10-25 13:58:47 字数 844 浏览 8 评论 0原文

我有大约 50,000 个条目的列表，这些条目填充在 wpf 的数据网格中。现在我想将列表中的数据保存到一个文件中，该文件可以是文本，或者最好是 CSV。由于列表太大。我实现的方法有一个问题，可能是简单的文本文件写入，或者是将内容从数据网格复制到剪贴板，然后返回字符串，然后使用 StreamReader 将该字符串复制到文件的方法。即使在后台工作，也需要大约 4-5 分钟。

有什么方法可以快速保存大量列表到文件中吗？

我在 WPF

代码中使用 DataGrid

 dataGrid1.SelectAllCells();
            dataGrid1.ClipboardCopyMode = DataGridClipboardCopyMode.IncludeHeader;
            ApplicationCommands.Copy.Execute(null, dataGrid1);
   String result = (string)Clipboard.GetData(DataFormats.CommaSeparatedValue);


///Never reach to step Below thread stays on above line
                dataGrid1.UnselectAllCells();
                Clipboard.Clear();
                StreamWriter file = new System.IO.StreamWriter(SavePageRankToPDF.FileName);
                file.WriteLine(result);
                file.Close();

原文

I have list of maybe 50,000 entries that are populated in datagrid in wpf. Now I want to save the data in the list to a file that may be text, or preferably CSV. As list is too big. There is a problem that my implemented method that may be simple text file writing or the method to copy the contents from the datagrid to clipboard and then back to string, and then that string to file using StreamReader. It consumes approx 4-5 minutes even it is in background worker.

Is there any way that I can save huge list to file quickly?

I am using DataGrid in WPF

CODE

 dataGrid1.SelectAllCells();
            dataGrid1.ClipboardCopyMode = DataGridClipboardCopyMode.IncludeHeader;
            ApplicationCommands.Copy.Execute(null, dataGrid1);
   String result = (string)Clipboard.GetData(DataFormats.CommaSeparatedValue);


///Never reach to step Below thread stays on above line
                dataGrid1.UnselectAllCells();
                Clipboard.Clear();
                StreamWriter file = new System.IO.StreamWriter(SavePageRankToPDF.FileName);
                file.WriteLine(result);
                file.Close();

分享到QQ

分享到微博