exporting visible columns of datagridview to csv

Question

0.00/5 (No votes)

See more:

I have this code to export datagridview rows to csv and it works fine, but when i make some columns of datagridview invisible I dont want them in exported csv file. but I cant get it to work

C#

StreamWriter sw = new StreamWriter("d://gridview.csv");

for (int i = 0; i < dg1.Columns.Count; i++)
{
    sw.Write(dg1.Columns[i].HeaderText);
    if (i != dg1.Columns.Count)
    {
        sw.Write(",");
    }
}

sw.Write(sw.NewLine);

foreach (DataGridViewRow dr in dg1.Rows)
{

    for (int i = 0; i < dg1.Columns.Count; i++)
    {

        sw.Write(dr.Cells[i].Value);
        if (i != dg1.Columns.Count)
        {
            sw.Write(",");
        }
    }

    sw.Write(sw.NewLine);
}

sw.Flush();

sw.Close();

datagridview isn't bound because its data is cloned from another datagridview

Posted 19-Nov-12 21:10pm

shonezi

Updated 14-Jun-16 9:04am

Add a Solution

2 solutions

Solution 2

A simple way to save also is to use the clipboard and in 3 lines

VB

Clipboard.SetDataObject(DataFormats.Text)
DataGridView.SelectAll()
IO.File.WriteAllText(Filename,DataGridView.GetClipBoardContent().GetText.Replace(vbTab, ","), System.Text.Encoding.ASCII)

sets the clipboard content to your desired DataFormat (Text)
select what you want to copy
(note:if you have filtered (invisible?) elements in your DGV they won't be copied)
Write the Clipboard content to the file
(note:here I have replaced the 'Tab' delimiter with a comma to get a CSV file)

Posted 14-Jun-16 9:04am

Georg_S

Updated 14-Jun-16 9:13am

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Rob Branaghan · Accepted Answer · 2012-11-20T01:41:00

Just look for if the column is visible or not, (this should work)
http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridviewcolumn.aspx[^]

if(dg1.Colums[i].Visible)
              {}

C#

StreamWriter sw = new StreamWriter("d://gridview.csv");

            for (int i = 0; i < dg1.Columns.Count; i++)
            {
              if(dg1.Colums[i].Visible)
              {
                sw.Write(dg1.Columns[i].HeaderText);
                if (i != dg1.Columns.Count)
                {
                    sw.Write(",");
                }
              }
            }

            sw.Write(sw.NewLine);

            foreach (DataGridViewRow dr in dg1.Rows)
            {

                for (int i = 0; i < dg1.Columns.Count; i++)
                {

                    sw.Write(dr.Cells[i].Value);
                    if (i != dg1.Columns.Count)
                    {
                        sw.Write",");
                    }
                }

                sw.Write(sw.NewLine);
            }

            sw.Flush();

            sw.Close()

exporting visible columns of datagridview to csv

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

exporting visible columns of datagridview to csv

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us