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,

 

Thanks for this good point!

 

But each hyperlink has an independent entity in an independent cell even if it is the same!

The process of directing you to the link address in the browser is only a functionality and does not affect the size.

 

In fact, when you remove the hyperlinks you actually remove the URL formats which is blue font color and underlined text!

 

Conclusion
The difference between the plain text and the hyperlink is just the format!

The specific format of the hyperlink is associated with an event to directing you the to link address in the browser, and this is just a functionality and does not affect the size.

 

With regards to HYPERLINK function, it increases the size by ~30 KB as the attached file, and this is not a big difference!

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Mar 26, 2018

Haytham,

 

For each unique URL into XML of Excel file will be added XML description of such with reference on ID for it.

 

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.

 

Anyway, that's not something what increases the size significantly.

  • 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!

Resources