Asp.net to excel export format cells

[Julien]

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]]

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