|
 |
asp_web_howto thread: How to create an Excel file by using ASP
Message #1 by Flavio de Souza <flaviosouza@s...> on Mon, 23 Apr 2001 10:20:57 -0700
|
|
Hey Listers:
I am working on a Intranet tool that calculates product prices based on
Access Database.
After user selects the product options, a page is generated with
description and price. Then, the person does copy and paste to Excel file
(which is our standard format for quotation files). I would like to
generate (or insert) price and description directly to an Excel file.
How can I do that by using ASP? Is it possible?
The solution has to be with ASP, I wouldn't like a customized applications
running on the server.
If possible, I'd appreciate some source code examples (just to rush the
learning process).
Thanks everybody,
Flavio de Souza
flavionews@o...
ICQ:78458203
Message #2 by Craig Flannigan <ckf@k...> on Tue, 24 Apr 01 12:26:15 BST
|
|
I've done this with success.
Place this line of code on the page you want to generate an Excel
file from.
Response.ContentType = "application/vnd.Excel"
This will force any following page content into Excel.
Hope this helps,
Craig.
_____________________________________________________
Craig Flannigan
Development Supervisor - Business Systems
Kaye House
Tel: 0114 256 6070
Email: ckf@k...
----------
>Hey Listers:
>
>I am working on a Intranet tool that calculates product prices
>based on
>Access Database.
>After user selects the product options, a page is generated with
>description and price. Then, the person does copy and paste to
>Excel file
>(which is our standard format for quotation files). I would like
>to
>generate (or insert) price and description directly to an Excel
>file.
>How can I do that by using ASP? Is it possible?
>
>The solution has to be with ASP, I wouldn't like a customized
>applications
>running on the server.
>
>If possible, I'd appreciate some source code examples (just to
>rush the
>learning process).
>
>Thanks everybody,
>
>
>Flavio de Souza
>flavionews@o...
>ICQ:78458203
>
>
Message #3 by Flavio de Souza <flavionews@o...> on Tue, 24 Apr 2001 10:05:10 -0700
|
|
Thank you for your quick answer.
I tried that command, but it seems that it is not the kind of functionality
I want.
The Response.ContentType makes my broswer downloads the page.
I wrote:
<%
Response.ContentType = "application/vnd.Excel"
Response.Write "Hello"
%>
Then my browser downloads the .asp page.
What I want to is to "translante": HTML -> .XLS.
I am not sure but I think I have to go for XML stuff or something like that.
Thanks anyway.
Flavio.
At 12:26 PM 4/24/01 +0100, you wrote:
>I've done this with success.
>
>Place this line of code on the page you want to generate an Excel
>file from.
>
> Response.ContentType = "application/vnd.Excel"
>
>This will force any following page content into Excel.
>
>Hope this helps,
>Craig.
>
>
>
>_____________________________________________________
>Craig Flannigan
>Development Supervisor - Business Systems
>
>Kaye House
>Tel: 0114 256 6070
>Email: ckf@k...
>
>----------
> >Hey Listers:
> >
> >I am working on a Intranet tool that calculates product prices
> >based on
> >Access Database.
> >After user selects the product options, a page is generated with
> >description and price. Then, the person does copy and paste to
> >Excel file
> >(which is our standard format for quotation files). I would like
> >to
> >generate (or insert) price and description directly to an Excel
> >file.
> >How can I do that by using ASP? Is it possible?
> >
> >The solution has to be with ASP, I wouldn't like a customized
> >applications
> >running on the server.
> >
> >If possible, I'd appreciate some source code examples (just to
> >rush the
> >learning process).
> >
> >Thanks everybody,
> >
> >
> >Flavio de Souza
> >flavionews@o...
> >ICQ:78458203
> >
> >
Flavio de Souza
flavionews@o...
ICQ:78458203
Message #4 by Hugh McLaughlin <Hugh@k...> on Tue, 24 Apr 2001 17:25:03 -0400
|
|
I am not sure if this is what you are looking for, but check out:
http://support.microsoft.com/support/kb/articles/Q278/9/73.asp
Hope it helps.
Hugh McLaughlin.
-----Original Message-----
From: Flavio de Souza [mailto:flavionews@o...]
Sent: Tuesday, April 24, 2001 1:05 PM
To: ASP Web HowTo
Subject: [asp_web_howto] Re:How to create an Excel file by using ASP
Thank you for your quick answer.
I tried that command, but it seems that it is not the kind of functionality
I want.
The Response.ContentType makes my broswer downloads the page.
I wrote:
<%
Response.ContentType = "application/vnd.Excel"
Response.Write "Hello"
%>
Then my browser downloads the .asp page.
What I want to is to "translante": HTML -> .XLS.
I am not sure but I think I have to go for XML stuff or something like that.
Thanks anyway.
Flavio.
At 12:26 PM 4/24/01 +0100, you wrote:
>I've done this with success.
>
>Place this line of code on the page you want to generate an Excel
>file from.
>
> Response.ContentType = "application/vnd.Excel"
>
>This will force any following page content into Excel.
>
>Hope this helps,
>Craig.
>
>
>
>_____________________________________________________
>Craig Flannigan
>Development Supervisor - Business Systems
>
>Kaye House
>Tel: 0114 256 6070
>Email: ckf@k...
>
>----------
> >Hey Listers:
> >
> >I am working on a Intranet tool that calculates product prices
> >based on
> >Access Database.
> >After user selects the product options, a page is generated with
> >description and price. Then, the person does copy and paste to
> >Excel file
> >(which is our standard format for quotation files). I would like
> >to
> >generate (or insert) price and description directly to an Excel
> >file.
> >How can I do that by using ASP? Is it possible?
> >
> >The solution has to be with ASP, I wouldn't like a customized
> >applications
> >running on the server.
> >
> >If possible, I'd appreciate some source code examples (just to
> >rush the
> >learning process).
> >
> >Thanks everybody,
> >
> >
> >Flavio de Souza
> >flavionews@o...
> >ICQ:78458203
> >
> >
Flavio de Souza
flavionews@o...
ICQ:78458203
Message #5 by Flavio de Souza <flavionews@o...> on Wed, 25 Apr 2001 09:14:59 -0700
|
|
Thanks a lot!
This is what I need. I'll start learning these techniques right away.
Thanks again! Thanks everybody who helped me!
Flavio de Souza
flavionews@o...
ICQ:78458203
At 12:00 AM 4/25/01 +0100, you wrote:
>----------------------------------------------------------------------
>
>Subject: Re:How to create an Excel file by using ASP
>From: Hugh McLaughlin <Hugh@k...>
>Date: Tue, 24 Apr 2001 17:25:03 -0400
>X-Message-Number: 32
>
>I am not sure if this is what you are looking for, but check out:
>
>http://support.microsoft.com/support/kb/articles/Q278/9/73.asp
>
>Hope it helps.
>
>Hugh McLaughlin.
Message #6 by Hugh McLaughlin <Hugh@k...> on Wed, 25 Apr 2001 14:17:59 -0400
|
|
Glad it helped. I have a number of applications working with Excel and this
tutorial has been great. Good Luck.
Hugh McLaughlin
-----Original Message-----
From: Flavio de Souza [mailto:flavionews@o...]
Sent: Wednesday, April 25, 2001 12:15 PM
To: ASP Web HowTo
Subject: [asp_web_howto] Re:How to create an Excel file by using ASP
Thanks a lot!
This is what I need. I'll start learning these techniques right away.
Thanks again! Thanks everybody who helped me!
Flavio de Souza
flavionews@o...
ICQ:78458203
At 12:00 AM 4/25/01 +0100, you wrote:
>----------------------------------------------------------------------
>
>Subject: Re:How to create an Excel file by using ASP
>From: Hugh McLaughlin <Hugh@k...>
>Date: Tue, 24 Apr 2001 17:25:03 -0400
>X-Message-Number: 32
>
>I am not sure if this is what you are looking for, but check out:
>
>http://support.microsoft.com/support/kb/articles/Q278/9/73.asp
>
>Hope it helps.
>
>Hugh McLaughlin.
|
|
|
View Cart
