Hi,
I'm actually trying to export a repeater to excel, everything seems ok
but the problem is that the cells are not validated
This means that for example date, it is left-centered instead of been
right-centered when it is correctly validated, apprently excel doesnt
recognize the numbers with coma and it is not possible to calculate
formulas with this numbers.
Does anybody know how to do that? Is it possible to use
mso-number-format to do that?
<td style='mso-number-format:"Short Date";'>
<%#DataBinder.Eval(Container.dataitem,"date", "{0:d}")%>
</td>
Thanks
Julien
Steve C. Orr [MVP, MCSD] - 28 Feb 2005 21:11 GMT
What technique are you using to export to Excel? There are a variety of
ways to do this, perhaps you should try one of the others. Here's a good
description of most of the techniques you could use:
http://SteveOrr.net/Articles/ExcelExport.aspx
Finally, if you find your needs become advanced, you could use a 3rd part
component:
http://www.SteveOrr.net/Reviews/AsposeExcel.aspx
http://officewriter.softartisans.com/officewriter-37.aspx

Signature
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
> Hi,
> I'm actually trying to export a repeater to excel, everything seems ok
[quoted text clipped - 14 lines]
>
> Julien