|
 |
asp_web_howto thread: CreateObject, Excel
Message #1 by "Hege Moberget" <hege.moberget@o...> on Tue, 20 Feb 2001 11:33:55
|
|
Hallo!
My problem are as follows:
I want to take information from a form, process the data a litte bit and
then put it into a Excel sheet on the server and then make it possible to
download this excel sheet to the client.
I have tried to use CreateObject("Excel.sheet") but I haven't been able to
get it to work.
Hege
Message #2 by "Krishnanand K, J16 Chennai" <krishnanandk@m...> on Tue, 20 Feb 2001 17:19:05 +0530
|
|
Use this command
<% Response.ContentType = "application/vnd.ms-excel" %>
and then u use the response.write method , the data will be displayed in
excel. It will prompt u whether to download the excel file or to open it
from current location. U choose the choice.
Eg.
<% Response.write ("hai") %>
will now be displayed in excel.
There is no need to put datas in the form to excel sheet . whatever u
typed in the form ,using the above said command will be displayed in excel.
krishna
Message #3 by "Hege Moberget" <hmoberge@o...> on Thu, 22 Feb 2001 12:53:19 +0100
|
|
Hallo!
Ypu are good. This was great. I tried it and it worked.
Thank you!
Hege
-----Original Message-----
From: Krishnanand K, J16 Chennai [mailto:krishnanandk@m...]
Sent: 20. februar 2001 12:49
To: ASP Web HowTo
Subject: [asp_web_howto] RE: CreateObject, Excel
Use this command
<% Response.ContentType = "application/vnd.ms-excel" %>
and then u use the response.write method , the data will be displayed in
excel. It will prompt u whether to download the excel file or to open it
from current location. U choose the choice.
Eg.
<% Response.write ("hai") %>
will now be displayed in excel.
There is no need to put datas in the form to excel sheet . whatever u
typed in the form ,using the above said command will be displayed in excel.
krishna
Message #4 by "Krishnanand K, J16 Chennai" <krishnanandk@m...> on Mon, 26 Feb 2001 12:56:10 +0530
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C09FC5.644DAE00
Content-Type: text/plain;
charset="iso-8859-1"
Happy to hear those happy words from hege.
krishna
-----Original Message-----
From: Hege Moberget [mailto:hmoberge@o...]
Sent: Thursday, February 22, 2001 5:23 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: CreateObject, Excel
Hallo!
Ypu are good. This was great. I tried it and it worked.
Thank you!
Hege
-----Original Message-----
From: Krishnanand K, J16 Chennai [mailto:krishnanandk@m...]
Sent: 20. februar 2001 12:49
To: ASP Web HowTo
Subject: [asp_web_howto] RE: CreateObject, Excel
Use this command
<% Response.ContentType = "application/vnd.ms-excel" %>
and then u use the response.write method , the data will be displayed in
excel. It will prompt u whether to download the excel file or to open it
from current location. U choose the choice.
Eg.
<% Response.write ("hai") %>
will now be displayed in excel.
There is no need to put datas in the form to excel sheet . whatever u
typed in the form ,using the above said command will be displayed in excel.
krishna
krishnanandk@m...
$subst('Email.Unsub')
|
|
|
View Cart
