source: Common/CsvExport.cs

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