View State

[SA]

hi all

i have a grid that has some columns created dynamically and attached
to a datasource. Once the grid is displayed in the screen there is a
Export to excel button. On clicking this button i change the response
content type to excel and override the Load view state to recreate the
dynamically created columns for the grid . This way the view state is
maintained and data is displayed in Excel. Now there are some rows in
the grid which has a different style ( they are bold). These formats
are not appearing in excel. How do i get them to appear as it is in
the screen?. Also for all Hyperlink columns i don't want hyperlinks in
Excel. Can this be done?.


Thanks
SA

 

[Steve C. Orr [MVP, MCSD]]

This article may be able to give you some guidance:
http://www.aspnetpro.com/NewsletterArticle/2003/09/asp200309so_l/asp200309so_l.asp