How to display each datagridview line in excel ?

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace CSharpCornerDemo
{
public partial class Form3 : Form
{
public Form3()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
myDataGridView.Columns.Clear();
myDataGridView.ColumnCount = 2;
myDataGridView.Columns[0].Name = "User ID";
myDataGridView.Columns[1].Name = "Password";
string[] row = new string[] { "abc", "abc" };
myDataGridView.Rows.Add(row);
row = new string[] { "pqr", "pqr" };
myDataGridView.Rows.Add(row);
row = new string[] { "ghanashyam", "ghanashyam" };
myDataGridView.Rows.Add(row);
row = new string[] { "jignesh", "jignesh" };
myDataGridView.Rows.Add(row);
DataGridViewLinkColumn dgvLink = new DataGridViewLinkColumn();
dgvLink.UseColumnTextForLinkValue = true;
dgvLink.LinkBehavior = LinkBehavior.SystemDefault;
dgvLink.HeaderText = "Link Data";
dgvLink.Name = "SiteName";
dgvLink.LinkColor = Color.Blue;
dgvLink.TrackVisitedState = true;
dgvLink.Text = "http://www.c-sharpcorner.com";
dgvLink.UseColumnTextForLinkValue = true;
myDataGridView.Columns.Add(dgvLink);
}
private void myDataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
string UserId = myDataGridView.Rows[e.RowIndex].Cells[0].Value.ToString();
string Password = myDataGridView.Rows[e.RowIndex].Cells[1].Value.ToString();
// creating Excel Application
Microsoft.Office.Interop.Excel._Application app = new Microsoft.Office.Interop.Excel.Application();
// creating new WorkBook within Excel application
Microsoft.Office.Interop.Excel._Workbook workbook = app.Workbooks.Add(Type.Missing);
// creating new Excelsheet in workbook
Microsoft.Office.Interop.Excel._Worksheet worksheet = null;
// see the excel sheet behind the program
app.Visible = true;
// get the reference of first sheet. By default its name is Sheet1.
// store its reference to worksheet
worksheet = workbook.Sheets["Sheet1"];
worksheet = workbook.ActiveSheet;
// changing the name of active sheet
worksheet.Name = "Exported from gridview";
// storing header part in Excel
for (int i = 1; i < myDataGridView.Columns.Count + 1; i++)
{
worksheet.Cells[1, i] = myDataGridView.Columns[i - 1].HeaderText;
}
// storing Each row and column value to excel sheet
for (int j = 0; j < myDataGridView.Columns.Count; j++)
{
worksheet.Cells[0, j + 1] = myDataGridView.Rows[0].Cells[j].Value.ToString();
}
// save the application
workbook.SaveAs("c:\\output.xls", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
// Exit from the application
app.Quit();
}
}
}

Hi Ma,

It's very simple,

Try this code,

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Palanivel9y ago
Accepted answer
Hi ma,

have you created link in datagrid view cell?

If you done it,

Create a new method to export excel data and pass the selected grid view data into that method to export.
+1
ma ouml9y ago
here it is
0
Ramesh Palanivel9y ago
HI ma,

Can you post your solution file?
0
ma ouml9y ago
I have already added the reference of microsoft .office.interop.excel but it shows me the error that I sent you
0
Ramesh Palanivel9y ago
Hi Ma,

Have you added Microsoft.Interop.Excel? If you didn't add this file, add this file in your reference folder
0
ma ouml9y ago
I tested the code you sent me but when I run it shows me this error

0
Ramesh Palanivel9y ago
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace CSharpCornerDemo
{
    public partial class Form3 : Form
    {
        public Form3()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            myDataGridView.Columns.Clear();

            myDataGridView.ColumnCount = 2;
            myDataGridView.Columns[0].Name = "User ID";
            myDataGridView.Columns[1].Name = "Password";

            string[] row = new string[] { "abc", "abc" };
            myDataGridView.Rows.Add(row);
            row = new string[] { "pqr", "pqr" };
            myDataGridView.Rows.Add(row);
            row = new string[] { "ghanashyam", "ghanashyam" };
            myDataGridView.Rows.Add(row);
            row = new string[] { "jignesh", "jignesh" };
            myDataGridView.Rows.Add(row);

            DataGridViewLinkColumn dgvLink = new DataGridViewLinkColumn();
            dgvLink.UseColumnTextForLinkValue = true;
            dgvLink.LinkBehavior = LinkBehavior.SystemDefault;
            dgvLink.HeaderText = "Link Data";
            dgvLink.Name = "SiteName";
            dgvLink.LinkColor = Color.Blue;
            dgvLink.TrackVisitedState = true;
            dgvLink.Text = "http://www.c-sharpcorner.com";
            dgvLink.UseColumnTextForLinkValue = true;

            myDataGridView.Columns.Add(dgvLink);
        }

        private void myDataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

            string UserId = myDataGridView.Rows[e.RowIndex].Cells[0].Value.ToString();
            string Password = myDataGridView.Rows[e.RowIndex].Cells[1].Value.ToString();
            // creating Excel Application

            Microsoft.Office.Interop.Excel._Application app = new Microsoft.Office.Interop.Excel.Application();
            // creating new WorkBook within Excel application

            Microsoft.Office.Interop.Excel._Workbook workbook = app.Workbooks.Add(Type.Missing);

            // creating new Excelsheet in workbook

            Microsoft.Office.Interop.Excel._Worksheet worksheet = null;

            // see the excel sheet behind the program

            app.Visible = true;

            // get the reference of first sheet. By default its name is Sheet1.

            // store its reference to worksheet

            worksheet = workbook.Sheets["Sheet1"];

            worksheet = workbook.ActiveSheet;

            // changing the name of active sheet

            worksheet.Name = "Exported from gridview";

            // storing header part in Excel

            for (int i = 1; i < myDataGridView.Columns.Count + 1; i++)
            {

                worksheet.Cells[1, i] = myDataGridView.Columns[i - 1].HeaderText;

            }


            // storing Each row and column value to excel sheet


                for (int j = 0; j < myDataGridView.Columns.Count; j++)
                {

                    worksheet.Cells[0, j + 1] = myDataGridView.Rows[0].Cells[j].Value.ToString();

                }



            // save the application

            workbook.SaveAs("c:\\output.xls", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing);



            // Exit from the application

            app.Quit();

        }
    }
}
Hi Ma,

It's very simple,

Try this code,
+1
ma ouml9y ago
thank you very much for your help
0
ma ouml9y ago
No I do not create the link and I do not know how to write the method to export each link in excel
0
Ramesh Palanivel9y ago
Hi Ma,

Try this URL, It may help you,

http://www.c-sharpcorner.com/UploadFile/c5c6e2/export-datagridview-data-to-excel-in-C-Sharp-without-saving-to-fi/
+1