Hi Benj the above code gives the same result as my code.
it does not make an excel sheet having same color cells as datagridview. :( On Tue, Jul 19, 2011 at 5:28 PM, Benj Nunez <[email protected]> wrote: > > Try the code demonstrated here: > > http://stackoverflow.com/questions/6196770/datagridview-export-to-excel > > > Regards, > > > Benj > > > On Jul 14, 7:10 pm, Harish Kumar <[email protected]> wrote: > > Hi, > > With below code, i am able to transfer data from DataGridView to an > > Excel sheet. > > But it only transfer the text data. If DataGridView has some cells > > with different colour and font, it does not transfer the colour and > > font. > > > > so how can i transfer the data with the same colour and font. please > > reply if you know > > > > thanks in advance > > > > my code is:---- > > > > private void Excel_Click(object sender, EventArgs e) > > { > > if (dataGridView1.Rows.Count != 0) > > { > > SaveFileDialog sfd = new SaveFileDialog(); > > sfd.Filter = "Microsoft Excel 97/2000/XP(*.xls)| > > *.xls"; > > sfd.FileName = "Report.xls"; > > if (sfd.ShowDialog() == DialogResult.OK) > > { > > StreamWriter wr = new StreamWriter(sfd.FileName); > > > > int cols = dataGridView1.Columns.Count; > > for (int i = 0; i < cols; i++) > > { > > > > wr.Write(dataGridView1.Columns[i].Name.ToUpper() + "\t"); > > } > > > > wr.WriteLine(); > > > > for (int i = 0; i < (dataGridView1.Rows.Count - > > 1); i++) > > { > > for (int j = 0; j < cols; j++) > > { > > > > wr.Write(dataGridView1.Rows[i].Cells[j].Value + "\t"); > > } > > wr.WriteLine(); > > } > > wr.Close(); > > label9.Text = "Your file has been successfully > > saved !"; > > } > > } > > else > > { > > MessageBox.Show("Error"); > > } > > } > > -- > You received this message because you are subscribed to the Google > Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML > Web Services,.NET Remoting" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en > or visit the group website at http://megasolutions.net > -- Thank You *HARISH KUMAR* -- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net
