hi all
i have a ASP.NET 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
i have a ASP.NET 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