[Date Prev][Date
Next][Thread Prev][Thread Next][Date
Index][Thread Index]
RE: UKHA Classified update
- To: <ukha_d@xxxxxxx>
- Subject: RE: UKHA Classified update
- From: "Jon Whiten" <jon@xxxxxxx>
- Date: Mon, 25 Mar 2002 18:28:57 -0000
- Delivered-to: mailing list ukha_d@xxxxxxx
- Mailing-list: list ukha_d@xxxxxxx; contact
ukha_d-owner@xxxxxxx
- Reply-to: ukha_d@xxxxxxx
I _hate_ having to cut paste data from a web browser to excel - in fact one
of our customers attempted to convince us that this is a viable way of
receiving orders. It is quite simple to send (using asp) a page to excel
assuming the client has both Excel and IE.
Insert response.ContentType="application/vnd.ms-excel" into the
top of the
asp then just write a table. The table can use excel formula if required.
e.g.
<%@ LANGUAGE="VBSCRIPT" %>
<% response.ContentType="application/vnd.ms-excel" %>
<table>
<tr>
<td>Fruit</td>
<td>Quantity</td>
</tr>
<tr>
<td>Apples</td>
<td>6</td>
</tr>
<tr>
<td>Pears</td>
<td>3</td>
</tr>
<tr>
<td>Oranges</td>
<td>20</td>
</tr>
<tr>
<td>Total</td>
<td>=sum(b2:b4)</td>
</tr>
</table>
Regards,
Jon
http://www.whiten.co.uk/
> -----Original Message-----
> From: graham@xxxxxxx [mailto:graham@xxxxxxx]
> Sent: 25 March 2002 14:06
> To: ukha_d@xxxxxxx
> Subject: [ukha_d] UKHA Classified update
> Q: Would be nice to see latest additions/filter items by
price/download a
> cvs/xls of all (current) items?
>
> A: Well I may provide a search screen at some point, but until we have
> loads of items on here, then I think a full current item list as
requested
> above will suffice. As for download, a cut and paste of the full list
will
> be fine I'm sure ;-)
>
>
Home |
Main Index |
Thread Index
|