Hi,

I am creating a Excel document dynamically using XML.

How can i set the columns so they are the size of the largest contents (i.e. same as double clicking on column edge to make it the correct size).

if i do it manually (open it in excel and double click it) i get:

<Column ss:Width="101.25"/>

Obviously if i am creating the document dynamically then the widths should change with the data.

Thanks