1 | using System;
|
---|
2 | using System.Text;
|
---|
3 | using System.IO;
|
---|
4 | using System.Windows.Forms;
|
---|
5 |
|
---|
6 | namespace 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 | }
|
---|