xml file styling when opening in Excel 2010

Question

How to make columns center or assign columns as string/integer/decimal when you open an xml file with excel 2010. or a font?

Here's an example of the xml file:

<?xml version="1.0"?>
<RecycleBin>
<Site Url="https://www.site.com" Size="16489369" />
</RecycleBin>

So I've read some blogs about different ways to do this.. when you open the xml file it asks you if you want to use a schema..

The different ways I've seen are a variety .. including something called DTD, CSS, Schema, xsl.

So what is currently the best practice.. This is for .net 3.5 ... possibly an example?

Sam Hobbs · Answer

I am not sure I understand what you are trying to do. Possibly one thing you can do is to create an Excel file the way you want it to look and then export that as XML. I think XML is not designed to provide formatting associated with the data. It is entirely possible but I think it is more work than you are hoping for. The practical solution is to create a macro or some other programming htat sets the formatting based on the data.

Abhimanyu K Vatsa · Answer

being as a web dev. for the web i recommend to use CSS.