Excel 2003 XML format - AutoFitWidth not working

xml excel openxml
Peter picture Peter · Oct 5, 2008 · Viewed 27.5k times · Source

I have a program that spits out an Excel workbook in Excel 2003 XML format. It works fine with one problem, I cannot get the column widths to set automatically.

A snippet of what I produce:

  <Table >
   <Column ss:AutoFitWidth="1" ss:Width="2"/>
   <Row ss:AutoFitHeight="0" ss:Height="14.55">
    <Cell ss:StyleID="s62"><Data ss:Type="String">Database</Data></Cell>

This does not set the column to autofit. I have tried not setting width, I have tried many things and I am stuck.

Thanks.

Answer

s&amp;#248;ren Jacobi picture s&#248;ren Jacobi · Oct 5, 2008

Only date and number values are autofitted :-( quote: "... We do not autofit textual values"

http://msdn.microsoft.com/en-us/library/aa140066.aspx#odc_xmlss_ss:column

Related questions

Repaired Records : Cell information from worksheet created from scratch

I'm receiving an error when opening my OpenXML created spreadsheet. The error is as follows. Repaired Records: Cell information from /xl/worksheets/sheet.xml part Repaired Records: Cell information from /xl/worksheets/sheet2.xml part Repaired Records: Cell information from /…

Read More
Open XML SDK 2.0 - how to update a cell in a spreadsheet?

I want to update a cell in a spreadsheet that is used by a chart, using the Open XML SDK 2.0 (CTP). All the code samples I have found insert new cells. I am struggling with retrieving the right worksheet. public …

Read More
xlsx error: "Removed Records: Named range from /xl/workbook.xml part" when tried to resolve errors

I have an xlsx file that I generate using SSIS. The data to this file is written through a data flow task where the xlsx file is the oledb destination. I have used the following connection string as an expression …

Read More