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
