Create Excel files on .NET

CarlosAg Excel Xml Writer Library seems to be a great option on creating Excel files in .NET.
Seems easy and effective, no more CSV formatting problems and create several sheets in excel in an easy way!
Unfortunately it doesn't seem to be open source, but it's still free!

Using both MaskedEditExtender and calendarextender

It's not easy to use the Ajax Toolkit controls like the example in here for editing a date. Well, at least not easy if you want it to be multicultural. I used the following: //Set the culture settings CultureInfo oCulture = CultureInfo.CurrentCulture; CalendarMaskExtender1.CultureName = oCulture.Name; CalendarExtender1.Format = oCulture.DateTimeFormat.ShortDatePattern; //CalendarMaskExtender expects something like "99/99/9999" CalendarMaskExtender1.Mask = CalendarExtender1.Format.Replace( oCulture.DateTimeFormat.DateSeparator, "/").Replace( "d", "9").Replace( "M", "9").Replace( "y", "9"); And don't forge tot set the <asp:ScriptManager EnableScriptGlobalization="true">

Argh, how do you set the format on this blogger.....aahh, just view source of this page if you need to check the code..