Glen Lipka wrote on 8/10/2007 10:34 AM:
Yes. Specifically a table. You can even add CSS backgrounds, and borders
which Excel picks up too.
(Assuming the headers say its excel)
And you can tell Excel how to format the data, for example to display a US zip
code:
<td style="font-align: right; color: red;
mso-number-format:00000;">07643</td>
Or a date:
<td style="font-align: right; color: red; mso-number-format:yyyy\\\\-mm\\\\-dd;">2006-12-20</td>
The other option that has been offered on the LassoTalk list is creating an Excel file
that has the format you want, save it as XML, then replace the dummy placeholder text
with the real values. The downside to the XML method is XML is only supported by newer
versions of Excel (not sure how "new" Excel has to be).
- Bil
