How to display each datagridview line in excel ?

Question

Good evening, I want that in every row in datagridview have a link that contains the information of the row by displaying them in excel how to do And thanks in advance

Ramesh Palanivel · 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.

Ramesh Palanivel · Answer

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 { worksheet.Cells[1, i] = myDataGridView.Columns[i - 1].HeaderText; } // storing Each row and column value to excel sheet for ( int j = 0; 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,

Ramesh Palanivel · Answer

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/

ma ouml · Answer

here it is

Ramesh Palanivel · Answer

HI ma, Can you post your solution file?

ma ouml · Answer

I have already added the reference of microsoft .office.interop.excel but it shows me the error that I sent you

Ramesh Palanivel · Answer

Hi Ma, Have you added Microsoft.Interop.Excel? If you didn't add this file, add this file in your reference folder

ma ouml · Answer

I tested the code you sent me but when I run it shows me this error

ma ouml · Answer

thank you very much for your help

ma ouml · Answer

No I do not create the link and I do not know how to write the method to export each link in excel

How to display each datagridview line in excel ?

Answers (10)