How to write each value of grid view to a text file?

Question

I want to write the grid values to each line of a text file.

The grid is as follows.

I want to write values of SensposX, SensPosY and SensPosZ with a white space tab in one line and like this it should follow for the remaining 12 rows.

May I know how to write this?

So the question is how to loop through the grid rows ? Or the question is how to write to a text file ? Both have answers here : http://stackoverflow.com/questions/19737436/looping-each-row-in-datagridview and here: http://stackoverflow.com/questions/7569904/easiest-way-to-read-from-and-write-to-files — Zein Makki, Aug 30 '16 at 09:54
How do you set the datasource? Use the same source to loop through values and write it to file. — Hari Prasad, Aug 30 '16 at 09:55

Reza Aghaei · Accepted Answer · 2016-08-30T11:48:04.967

Option 1

To export a DataGridView to file, as a simple option you can use GetClipboardContent methos:

grid.ClipboardCopyMode = DataGridViewClipboardCopyMode.EnableAlwaysIncludeHeaderText;
grid.SelectAll();
var text = grid.GetClipboardContent().GetText();

Then you can simply use File.WriteAllText method to save contents to file:

System.IO.File.WriteAllText(filePath, text);

Note

You can select only columns or rows which you want to export. I used SelectAll() to export the whole grid.
You can have more control on exported text using this signature of GetText method.

Option 2

You can use linq to select cell values which you want and join them to create the text representation of DataGridView:

var lines = new List<string>();
var headers = grid.Columns.Cast<DataGridViewColumn>()
                            .Where(c => c.Visible).Select(c => c.HeaderText);
lines.Add(string.Join("\t", headers));
var rows = grid.Rows.Cast<DataGridViewRow>()
                        .Select(r => string.Join("\t", r.Cells.Cast<DataGridViewCell>()
                        .Where(c => c.Visible).Select(c => c.FormattedValue)));
lines.AddRange(rows);
var text = string.Join(Environment.NewLine, lines);

How to write each value of grid view to a text file?

1 Answers1