«

i need to export the data set to excel in asp.net, but my requirement is
need to use the template, i.e. some column should be lock as read-only and
some column should be highlighted. the format cells are fixed. is there any
way to excel the data set to pre-defined excel sheet.

Export to excel doesn't expose that type of functionality programmatically.
You may want to look at a 3rd party or Excel library.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless Author Plug
OWC Black Book 2nd Edition
Exclusively on www.lulu.com/owc
$24.99


"Grey" <> wrote in message
news:...
>i need to export the data set to excel in asp.net, but my requirement is
>need to use the template, i.e. some column should be lock as read-only and
>some column should be highlighted. the format cells are fixed. is there any
>way to excel the data set to pre-defined excel sheet.
>

"Grey" <> wrote in message
news:...

> i need to export the data set to excel in asp.net, but my requirement is
> need to use the template, i.e. some column should be lock as read-only and
> some column should be highlighted. the format cells are fixed. is there
> any way to excel the data set to pre-defined excel sheet.

http://www.aspose.com/Products/Aspos...s/Default.aspx


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

http://www.microsoft.com/downloads/d...displaylang=en

On Oct 16, 10:23 am, "Grey" <k...@jk.com> wrote:
> i need to export the data set to excel in asp.net, but my requirement is
> need to use the template, i.e. some column should be lock as read-only and
> some column should be highlighted. the format cells are fixed. is there any
> way to excel the data set to pre-defined excel sheet.

"carion1" <> wrote in message
news: oups.com...

> http://www.microsoft.com/downloads/d...displaylang=en
>
> On Oct 16, 10:23 am, "Grey" <k...@jk.com> wrote:
>> i need to export the data set to excel in asp.net, but my requirement is
>> need to use the template, i.e. some column should be lock as read-only
>> and
>> some column should be highlighted. the format cells are fixed. is there
>> any
>> way to excel the data set to pre-defined excel sheet.

Ignore this - it is for WinForms.

Server-side Office automation is not supported by Microsoft because it
doesn't work:
http://support.microsoft.com/default...US;q257757#kb2


--
Mark Rae
ASP.NET MVP
http://www.markrae.net