How to automatically adapt column width with XML format?
 

Hi.
I'm developing an application that outputs its results to an XML file (with
Excel XP's DTD). The trouble is the column width, which is set at default.
Is there an XML tag which allow to adapt width automatically?

I thought about a VBA macro, but I noticed that VBA code isn't stored in XML
Excel's files.

Thanks in advance,
Francesco.

How to automatically adapt column width with XML format?
 

Is there an XML tag which allow to adapt width automatically?

Yes but only for number and dates:

<Column ss:AutoFitWidth="1"/

You might want to get the Office 2003 XML Reference Schemas for more on
this:

http://www.microsoft.com/downloads/d...displaylang=en

--
Jim Rech
Excel MVP

How to automatically adapt column width with XML format?
 

Yes but only for number and dates:

Why? How can I adapt a string field?