Contents tagged with Office
-
Solution 4 : Export Silverlight DataGrid to Excel XML
While ASP.NET GridView control supports data export to Excel, Silverlight DataGrid control does not. To implement the data export, you need to retrieve data from the DataGrid and write the data to an Excel XML file (Office Open XML File Format).
-
Tip 4 : Microsoft Office Excel XML : Use the Correct DateTime Format to Avoid Error
The correct format for DateTime data type in an Excel XML cell is yyyy-MM-ddTHH:mm:ss.fff. Using other formats will give you an error of The file cannot be opened because of errors when you open the Excel xml file.