Forum Discussion

Julie Carson's avatar
Julie Carson
Copper Contributor
Mar 26, 2018

Hyperlinks - how much do they change the size of a file

Hi, I am new to the community but have been working with Excel for a long time.  The one thing that I am not sure of is if I am using hyperlinks just how much they add to the size of the file.  I hav...
Excel File Size with Hyperlinks
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Mar 26, 2018

Hi Sergei,

 

In XML each cell has an independent tag since it has an independent entity!

 

I've converted the workbook to an XML file, and get access to its source code, and the below code is a part of it.

 

Please take a deep look at this code and you'll see how each cell has an independent tag that includes all its contents!

 

You will notice how href="https://techcommunity.microsoft.com/" will repeat in each tag.

 

 

<table:table table:name="Sheet1" table:style-name="ta1">
    <office:forms form:automatic-focus="false" form:apply-design-mode="false"/>
    <table:table-column table:style-name="co1" table:default-cell-style-name="Default"/>
    <table:table-column table:style-name="co2" table:number-columns-repeated="1023" table:default-cell-style-name="Default"/>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>

 

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Mar 26, 2018

I mean not conversion to XML but internal Excel file structure if you unzip it. Here each resource (URL text) is defined only once and cell value is referencing on it. Text of the URL is not repeated for each cell definition.

 

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Mar 26, 2018

    Sergei,

     

    Please note that the Excel file in XLSX extension is an XML-based format.

    XML is a markup language and it's responsible for the Excel file structure.

     

    The code that you saw before is really what is going on inside the Excel file!

    Even with other extensions, you'll see the same thing but in a different syntax!

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Mar 26, 2018

      Haytham,

       

      In which exactly XML file is the above code? The biggest one is sheet1.xml and it looks differently.

      • Haytham Amairah's avatar
        Haytham Amairah
        Silver Contributor
        Mar 27, 2018
        Sergei,
         
        Your last reply is unclear or vague!

         

        Again, the code above is part of the structure of the workbook "before" that I previously attached!

        It's what's going on behind the scenes!

         

        You said before: "If you have only one URL, doesn't matter how many time you use it, it'll be only one description. If 10 thousand different URL:s - ten thousand such descriptions and ID:s."

         

        The code proved that this is wrong!

         

        I will not discuss more because it has become useless.

Resources