want AutoFilter to default "on" for all columns

From ASP.NET I set Response.ContentType = "application/vnd.ms-excel" then
Response.Write (some_excel_data). Excel opens in a new IE window. Is there
some way for AutoFilter to automatically default "on" first thing when excel
opens?

It should be in the same state as when the file was saved.

--
Regards,
Tom Ogilvy


"John Jones" <john.jones@discussions.microsoft.com> wrote in message
news:06D59EA4-7A4B-4499-B8A5-B1901EFD81C9@microsoft.com...
> From ASP.NET I set Response.ContentType = "application/vnd.ms-excel" then
> Response.Write (some_excel_data). Excel opens in a new IE window. Is
there
> some way for AutoFilter to automatically default "on" first thing when
excel
> opens?

Thanks for the reply. There never is a previous excel file. The results of
a DB query are processed on the server then Response.Write is used to stream
this data back to a client browser where IE brings it up in Excel since the
ContentType was set to "application/vnd.ms-excel".

I did read http://support.microsoft.com/default...b;en-us;271572
and tried using <x:FilterOn/> from within <x:WorksheetOptions> as documented
in the "Microsoft® Office HTML and XML Reference" but was unsuccessful.
Perhaps I wasn't trying it correctly ...

Does someone have further information on how to correctly use the
functionality documented in "Microsoft® Office HTML and XML Reference" or
another idea on how to default "AutoFilter" on when presenting data using
Excel in the way I describe. Thanks!


"Tom Ogilvy" wrote:

> It should be in the same state as when the file was saved.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "John Jones" <john.jones@discussions.microsoft.com> wrote in message
> news:06D59EA4-7A4B-4499-B8A5-B1901EFD81C9@microsoft.com...
> > From ASP.NET I set Response.ContentType = "application/vnd.ms-excel" then
> > Response.Write (some_excel_data). Excel opens in a new IE window. Is
> there
> > some way for AutoFilter to automatically default "on" first thing when
> excel
> > opens?
>
>
>