Forums

This topic is locked

sending form to a speadsheet?

Posted 30 May 2005 05:28:53
1
has voted
30 May 2005 05:28:53 matt trihey posted:
Hello

I have done a form in Dreamweaver UltraDev4 and need the information sent to a speadsheet. How do I go about this, do I need to download a script (CGI or ASP??) or is there an easy way.

I am not very computer litterate.

Any help would be much appreciated.

Matt

Replies

Replied 03 Jun 2005 11:03:16
03 Jun 2005 11:03:16 Lee Diggins replied:
Welcome Matt <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Sending data to a spreadsheet .xls can be a real pain as it has to be done on the server and you need to have the application installed for this to work and as we no applications can fail or need user interaction at times so not recommended. The best way to do this is to create a CSV file which any spreadsheet programme can open, you would create this using FSO - FileSystemObject. Search for writing text files to your particular system type (CGI/ASP) as the approach would be slightly different, well the code would be very different.

Post back if you need any further information.

Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>
Replied 06 Jun 2005 01:49:12
06 Jun 2005 01:49:12 matt trihey replied:
Thanks Leo

I will do some research on CSV & FSO, and work with my server provider and see if I can get this working!

Thanks again
Matt
Replied 06 Jun 2005 15:35:47
06 Jun 2005 15:35:47 Jeremy Conn replied:
Try placing this code at the top of your page... the result for me is is requesting that you save that page as a .XLS file... seems to me that any Spreadsheet app would be able to open a simple XLS doc, but I could be wrong.

&lt;%
Response.Buffer = TRUE
Response.ContentType = "application/vnd.ms-excel"
%&gt;

<b>Connman21</b>

www.conncreativemedia.com
DWMX2004 | ASP/VB | IIS5 | Access/SQL2000

Edited by - connman21 on 06 Jun 2005 15:37:48

Reply to this topic