On 2011/07/14 13:10, Harish Kumar wrote:
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.
That code only gives you a tab-separated values file. Column headers + data values only.
so how can i transfer the data with the same colour and font. please reply if you know
To do what you want, you need to include the attributes of each cell. This might do what you want - or, at least, set you on the right track.
<http://www.codeproject.com/KB/grid/ExportDatagridviewToExcel.aspx> -- Regards, Mike Fry Johannesburg -- 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
