|
I writing an ASP page to receive data from user, then save as Excel file and send back that Excel file to client.
Please show me the way to solve that problem.
(I intend to use the CGI technique but I start with nothing).
|
|
|
|
|
You have a few choices for this one:
1) Write the data as a .csv text file and stream that back using an Excel mime type. No formatting available this way. This is easy but not very pretty.
2) Automate Excel using Excel on the server. MS does not recommend this as Excel is single threaded and you could have scaling problems with many requests (each request would spawn its own copy of Excel on the server). This works but proceed at your own risk.
3) Use a third party component like SoftArtisans ExcelWriter.
I have done all three and think .csv or ExcelWriter are the best options.
|
|
|
|
|
Actually another sub-option to number 1 is to write an HTML table and stream that back using Excel mime type. Then you can do whatever formatting you like.
Jeremy
Jeremy Oldham
|
|
|
|
|
I have tried to use the option number 2 for a single request (not many requests at a time which cause many copys of Excel Server).
For example : Server.CreateObject("Excel.Application")
But I can handle that object (?) After having been created, it was closed immediately.
Another automation - Lotus123.Workbook.98 - the problem is I can not close the object once it is created (by all ways... but failed). The IIS will be down if you re-create that object at another time.
Many big problems to me. May you help me ?!
|
|
|
|
|
Hi, everyone!
I want to draw a curve like CPU/MEM monitor in
Windows in an Applet. Where can I find some sample
codes?
Cheers,
George
|
|
|
|
|
|
Thanks, Boctor pal!
Your PHP script gives me a lot of help!
Cheers,
George
|
|
|
|
|
|
Hi,
Anyone have webportal like Codeproject in ASP?
If you have, would you please share it with me?
Many thanks,
-BHKien
|
|
|
|
|
|
How can I get it?
-BHKien
|
|
|
|
|
|
That's a forum only!
-BHKien
|
|
|
|
|
you can try with http://coveryourasp.com/CYA.asp or http://www.2enetworx.com/dev/index.asp , you can download the entire site.
The first one is ASP+javascript, the second ASP+VBscript
Michela
|
|
|
|
|
Very cool! Thank you very much!
-BHKien
|
|
|
|
|
I would like to use a combo drop down, on a HTML created page, to populate a Listbox,from a CSV file. The Aim is that each time an item (categories of articles) is selected from the combo, it causes a listbox to fill with a selection of articles obtained from a file, of which each listbox item (article) once selected opens up a Adobe pdf file.
I have little html probramming experience. Any help is appreciated.
Thanks,
Colin.
|
|
|
|
|
Hi,
I created a word document from my asp Page and it works fine on my evelopment environment but doesn't on production site.
It was quite simple ..just giving the Response.ContentType = "application/vnd.ms-word".
Does it require a Word on server.
and secondly can I create header and footer for the word page from ASP.
Thanks a lot,
Anil
|
|
|
|
|
It should not require Word on the server, but rather on each client machine.
Shameless Plug [^]
I knew it would end badly when I first met Chris in a Canberra alleyway and he said 'try some - it won't hurt you'..... - Christian Graus on Code Project outages
Religion without Science is blind, Science without Religion is lame -Albert Einstein
|
|
|
|
|
Hi Megan,
I too thought so but it works on my development web server byt not on producttion web server.Any idea why it happens so ?
And did you by chance created a footer for each page on word document created in ASP ? If yes please let me know.
Thanks
|
|
|
|
|
Anyone know how to change the font styles in the IDE. I can't find a style gallery... dialog like Word. It seems that this should be very simple but I looked everywhere and I can't seem to find out how to change the fonts.
Sorry, I also did not see a VS.NET forum for the IDE.
thanks
Marty
|
|
|
|
|
Marty Spallone wrote:
I also did not see a VS.NET forum for the IDE.
I think there is a .NET also VS .NET IDE... stuff forum
|
|
|
|
|
I've been writting ASp for quite some time now, and over and over again, I've thought about this:
Is there a way to immitate the "require once" feature of other scripting languages ? So that no matter how many of your include files contain, say [ which in my case contains a VBScript Class ] the context only loads it once ?
I could get over this ahortcoming of ASP by using a COM DLL, but not everything should require a DLL to do properly, right ?!?!?
Cheers,
Angel
O:]
|
|
|
|
|
I wrote (in ASP page):
<%Set obj = Server.CreateObject("Lotus123.Workbook.98")%>
Once the object is created, I can not close it. (I can see that by using Window Task Manager in Window2K - the process is 123w.exe)
I must close it manually by 'End process' function. If I don't close it and run that command again, the web server is down. (I mean that the command can create the object the at first time - when no 123w.exe process in memory - and fail to create the object if the process 123w.exe still remain in memory).
Another problem is when I create Excel.Application instead of Lotus123.Workbook.98 object, that Excel object is closed immediately and I can not handle it.
Please help me to solve that problems.
Thanks a lot.
TPN
Vietnam
nptrinh@hotmail.com
|
|
|
|
|
You need to set obj = Nothing before the page ends.
Note that initiating a .EXE from an ASP page is not scalable, nor fast, nor secure.
I see dumb people
|
|
|
|
|
I have already tried all things like : set obj = nothing,...
but no effect.
I note that .EXE is executed on server to do some thing like Export to a specific file format and turn back the result to client.
|
|
|
|