Create multiple tabs on excel via classic asp -

Create multiple tabs on excel via classic asp -

i can export page excel file via code below:

response.contenttype = "application/vnd.ms-excel" response.addheader "content-disposition", "attachment; filename=test.xls"

but want create multiple tabs on same excel file, how can it?

thanks helps.

you cannot using response.contenttype directive. command transforms page excel not have ability create new page of html read 1 page.

the solution depends on requirements are.

free

the free solution know building page , pushing browser xml file. if create file want in excel , save in xml format, can open file , see how page should build in asp.

pros free. not need permission install server. passing xml file client.

cons excel not default viewer xml files, notepad is. people not understand how open file in excel. means method internal applications can alter everyone's computer open xml files in excel default.

3rd party program

when needed accomplish same task had entertained using 3rd party programs in classic asp. wish remember programme have cost around ~$1,000 use.

pros these programs feature rich , allow want in exporting excel. cleaner , bit simpler utilize on writing own xml file open in excel.

cons costs money. may require server permissions not have. programs require save file server before serving client

asp.net

you can take instead create new page in asp.net , utilize excel features create file need.

pros free. same extensive feature set available in 3rd programs classic asp available method.

cons classic asp , .net not able communicate straight things password protection on page become issue if needed. need know or larn .net framework. files saved server before beingness sent client.

excel asp-classic