J
jb007
Hi all,
i have the following xmlss-File:
=================================================================================
<?xml version="1.0" encoding="UTF-8"?>
<Workbook xmlns="urn:schemas-microsoft-comffice:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40"
xmlns="urn:schemas-microsoft-comfficeffice"
xmlns:ss="urn:schemas-microsoft-comffice:spreadsheet"
xmlns:x="urn:schemas-microsoft-comffice:excel">
<DocumentProperties xmlns="urn:schemas-microsoft-comfficeffice">
<Author xmlns="urn:schemas-microsoft-comfficeffice">Test</Author>
<Company xmlns="urn:schemas-microsoft-comfficeffice">Private</
Company>
<Version xmlns="urn:schemas-microsoft-comfficeffice">10.4219</
Version>
</DocumentProperties>
<OfficeDocumentSettings xmlns="urn:schemas-microsoft-
comfficeffice">
<DownloadComponents xmlns="urn:schemas-microsoft-comfficeffice" />
<LocationOfComponents xmlns="urn:schemas-microsoft-comfficeffice"
HRef="file:///\\phlfsnt01\DOWNLOAD\OfficeXPSrc\" />
</OfficeDocumentSettings>
<ExcelWorkbook xmlns="urn:schemas-microsoft-comffice:excel">
<WindowHeight xmlns="urn:schemas-microsoft-comffice:excel">9210</
WindowHeight>
<WindowWidth xmlns="urn:schemas-microsoft-comffice:excel">15195</
WindowWidth>
<WindowTopX xmlns="urn:schemas-microsoft-comffice:excel">0</
WindowTopX>
<WindowTopY xmlns="urn:schemas-microsoft-comffice:excel">60</
WindowTopY>
<ProtectStructure xmlns="urn:schemas-microsoft-
comffice:excel">False</ProtectStructure>
<ProtectWindows xmlns="urn:schemas-microsoft-comffice: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-comffice:excel">
<Print xmlns="urn:schemas-microsoft-comffice:excel">
<ValidPrinterInfo xmlns="urn:schemas-microsoft-comffice:excel" />
<HorizontalResolution xmlns="urn:schemas-microsoft-
comffice:excel">1200</HorizontalResolution>
<VerticalResolution xmlns="urn:schemas-microsoft-
comffice:excel">1200</VerticalResolution>
</Print>
<ProtectObjects xmlns="urn:schemas-microsoft-comffice:excel">False</
ProtectObjects>
<ProtectScenarios xmlns="urn:schemas-microsoft-
comffice: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:
i have the following xmlss-File:
=================================================================================
<?xml version="1.0" encoding="UTF-8"?>
<Workbook xmlns="urn:schemas-microsoft-comffice:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40"
xmlns="urn:schemas-microsoft-comfficeffice"
xmlns:ss="urn:schemas-microsoft-comffice:spreadsheet"
xmlns:x="urn:schemas-microsoft-comffice:excel">
<DocumentProperties xmlns="urn:schemas-microsoft-comfficeffice">
<Author xmlns="urn:schemas-microsoft-comfficeffice">Test</Author>
<Company xmlns="urn:schemas-microsoft-comfficeffice">Private</
Company>
<Version xmlns="urn:schemas-microsoft-comfficeffice">10.4219</
Version>
</DocumentProperties>
<OfficeDocumentSettings xmlns="urn:schemas-microsoft-
comfficeffice">
<DownloadComponents xmlns="urn:schemas-microsoft-comfficeffice" />
<LocationOfComponents xmlns="urn:schemas-microsoft-comfficeffice"
HRef="file:///\\phlfsnt01\DOWNLOAD\OfficeXPSrc\" />
</OfficeDocumentSettings>
<ExcelWorkbook xmlns="urn:schemas-microsoft-comffice:excel">
<WindowHeight xmlns="urn:schemas-microsoft-comffice:excel">9210</
WindowHeight>
<WindowWidth xmlns="urn:schemas-microsoft-comffice:excel">15195</
WindowWidth>
<WindowTopX xmlns="urn:schemas-microsoft-comffice:excel">0</
WindowTopX>
<WindowTopY xmlns="urn:schemas-microsoft-comffice:excel">60</
WindowTopY>
<ProtectStructure xmlns="urn:schemas-microsoft-
comffice:excel">False</ProtectStructure>
<ProtectWindows xmlns="urn:schemas-microsoft-comffice: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-comffice:excel">
<Print xmlns="urn:schemas-microsoft-comffice:excel">
<ValidPrinterInfo xmlns="urn:schemas-microsoft-comffice:excel" />
<HorizontalResolution xmlns="urn:schemas-microsoft-
comffice:excel">1200</HorizontalResolution>
<VerticalResolution xmlns="urn:schemas-microsoft-
comffice:excel">1200</VerticalResolution>
</Print>
<ProtectObjects xmlns="urn:schemas-microsoft-comffice:excel">False</
ProtectObjects>
<ProtectScenarios xmlns="urn:schemas-microsoft-
comffice: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: