How to automatically adapt column width with XML format?

[Francesco Sblendorio]

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.

 

[Jim Rech]

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/...52-3547-420a-a412-00a2662442d9&displaylang=en

 

[Francesco Sblendorio]

Yes but only for number and dates:

Why? How can I adapt a string field?