source: Common/CsvExport.cs

Last change on this file was 15, checked in by chronos, 13 months ago
  • Modified: Updated files.
File size: 2.1 KB
Line 
1using System;
2using System.Text;
3using System.IO;
4using System.Windows.Forms;
5
6namespace Common
7{
8 public class CsvExport
9 {
10 public static void ListViewToCsv(ListView listView, string filePath, bool includeHidden)
11 {
12 // Make header string
13 StringBuilder result = new StringBuilder();
14 WriteCsvRow(result, listView.Columns.Count, i => includeHidden || listView.Columns[i].Width > 0, i => listView.Columns[i].Text);
15
16 // Export data rows
17 for (int j = 0; j < listView.Items.Count; j++)
18 {
19 WriteCsvRow(result, listView.Columns.Count, i => includeHidden || listView.Columns[i].Width > 0,
20 i => listView.Items[j].SubItems[i].Text);
21 }
22
23 File.WriteAllText(filePath, result.ToString());
24 }
25
26 public static void DataGridViewToCsv(DataGridView dataGridView, string filePath, bool includeHidden)
27 {
28 // Make header string
29 StringBuilder result = new StringBuilder();
30 WriteCsvRow(result, dataGridView.Columns.Count, i => includeHidden || dataGridView.Columns[i].Width > 0, i => dataGridView.Columns[i].HeaderText);
31
32 // Export data rows
33 foreach (DataGridViewRow row in dataGridView.Rows)
34 WriteCsvRow(result, row.Cells.Count, i => includeHidden || row.Cells[i].Size.Width > 0, i => row.Cells[i].Value.ToString());
35
36 File.WriteAllText(filePath, result.ToString());
37 }
38
39 private static void WriteCsvRow(StringBuilder result, int itemsCount, Func<int, bool> isColumnNeeded, Func<int, string> columnValue)
40 {
41 bool isFirstTime = true;
42 for (int i = 0; i < itemsCount; i++)
43 {
44 if (!isColumnNeeded(i))
45 continue;
46
47 if (!isFirstTime)
48 result.Append(",");
49 isFirstTime = false;
50
51 result.Append($"\"{columnValue(i).Replace("\"", "\"\"")}\"");
52 }
53 result.AppendLine();
54 }
55 }
56}
Note: See TracBrowser for help on using the repository browser.