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