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