XMLSS - SpreadsheetML Styles for dynamic Cell width

J

jb007

Hi all,

i have the following xmlss-File:
=================================================================================
<?xml version="1.0" encoding="UTF-8"?>
<Workbook xmlns="urn:schemas-microsoft-com:eek:ffice:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40"
xmlns:eek:="urn:schemas-microsoft-com:eek:ffice:eek:ffice"
xmlns:ss="urn:schemas-microsoft-com:eek:ffice:spreadsheet"
xmlns:x="urn:schemas-microsoft-com:eek:ffice:excel">
<DocumentProperties xmlns="urn:schemas-microsoft-com:eek:ffice:eek:ffice">
<Author xmlns="urn:schemas-microsoft-com:eek:ffice:eek:ffice">Test</Author>
<Company xmlns="urn:schemas-microsoft-com:eek:ffice:eek:ffice">Private</
Company>
<Version xmlns="urn:schemas-microsoft-com:eek:ffice:eek:ffice">10.4219</
Version>
</DocumentProperties>
<OfficeDocumentSettings xmlns="urn:schemas-microsoft-
com:eek:ffice:eek:ffice">
<DownloadComponents xmlns="urn:schemas-microsoft-com:eek:ffice:eek:ffice" />
<LocationOfComponents xmlns="urn:schemas-microsoft-com:eek:ffice:eek:ffice"
HRef="file:///\\phlfsnt01\DOWNLOAD\OfficeXPSrc\" />
</OfficeDocumentSettings>
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:eek:ffice:excel">
<WindowHeight xmlns="urn:schemas-microsoft-com:eek:ffice:excel">9210</
WindowHeight>
<WindowWidth xmlns="urn:schemas-microsoft-com:eek:ffice:excel">15195</
WindowWidth>
<WindowTopX xmlns="urn:schemas-microsoft-com:eek:ffice:excel">0</
WindowTopX>
<WindowTopY xmlns="urn:schemas-microsoft-com:eek:ffice:excel">60</
WindowTopY>
<ProtectStructure xmlns="urn:schemas-microsoft-
com:eek:ffice:excel">False</ProtectStructure>
<ProtectWindows xmlns="urn:schemas-microsoft-com:eek:ffice:excel">False</
ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Bottom"/>
<Borders/>
<Font />
<Interior />
<NumberFormat />
<Protection />
</Style>
</Styles>
<Worksheet ss:Name="Sheet1">

<Table ss:ExpandedColumnCount="3" ss:ExpandedRowCount="6"
x:FullColumns="1" x:FullRows="1">
<Row>
<Cell>
<Data ss:Type="String">sdsdf</Data>
</Cell>
<Cell>
<Data ss:Type="String">ssfdsdfsdfsdfsdfsdfsdfsdf</Data>
</Cell>
<Cell>
<Data
ss:Type="String">ssfdsdfsdfsdfsdfsdfsdfsdfssfdsdfsdfsdfsdfsdfsdfsdfssfdsdfsdfsdfsdfsdfsdfsdf</
Data>
</Cell>
</Row>
</Table>

<WorksheetOptions xmlns="urn:schemas-microsoft-com:eek:ffice:excel">
<Print xmlns="urn:schemas-microsoft-com:eek:ffice:excel">
<ValidPrinterInfo xmlns="urn:schemas-microsoft-com:eek:ffice:excel" />
<HorizontalResolution xmlns="urn:schemas-microsoft-
com:eek:ffice:excel">1200</HorizontalResolution>
<VerticalResolution xmlns="urn:schemas-microsoft-
com:eek:ffice:excel">1200</VerticalResolution>
</Print>
<ProtectObjects xmlns="urn:schemas-microsoft-com:eek:ffice:excel">False</
ProtectObjects>
<ProtectScenarios xmlns="urn:schemas-microsoft-
com:eek:ffice:excel">False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
</Workbook>

=================================================================================

The Data of this Spreadsheet is in the Table:

==================
<Table ss:ExpandedColumnCount="3" ss:ExpandedRowCount="6"
x:FullColumns="1" x:FullRows="1">
<Row>
<Cell>
<Data ss:Type="String">sdsdf</Data>
</Cell>
<Cell>
<Data ss:Type="String">ssfdsdfsdfsdfsdfsdfsdfsdf</Data>
</Cell>
<Cell>
<Data
ss:Type="String">ssfdsdfsdfsdfsdfsdfsdfsdfssfdsdfsdfsdfsdfsdfsdfsdfssfdsdfsdfsdfsdfsdfsdfsdf</
Data>
</Cell>
</Row>
</Table>
==================

It gives a Option to set the dynamic cell width?
It means for Example, not so:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top