Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to automatically adapt column width with XML format?
Yes but only for number and dates:
Why? How can I adapt a string field? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column width format | Excel Discussion (Misc queries) | |||
how do I automatically adjust a column width | Excel Discussion (Misc queries) | |||
Format Painter Column Width | Excel Discussion (Misc queries) | |||
Column automatically adjusts width to fit text entries | New Users to Excel |