Datagridview export to excel with formatting

Hello Experts,

I have a question regarding the export of data on a DataGridView onto an excel file with the formatting.

Basically I am a beginner at VB.net (visual studio 2005) and have been assigned to make an enhancement to an existing tool that has a datagridview on a form which has about 15 columns of info and certain rows and columns are coloured differently as per relevant criteria specified by the client.

I want to export the information displayed on the datagrid to excel ensuring that the formatting is also the same(or as close as possible) to the datagridview formatting. I.e the different colours on the rows/cells as well as ensuring that the cell sizes in excel automatically resize in the same way as the colunns in the datagridview.

I know i can design an excel template with macros etc that can do this but the requirement is that the tool has to be able to export the data to excel along with the same formatting. I have also found a solution here (http://www.timvw.be/datagridview-to-excel/ )but this would require using the dll file that the creator of this excel generator has built. I can't go via that route due to company policy etc etc...

Any help would be highly appreciated. Thanks.

DStart Free Trial