how add connection &webpr

[Explorer1092]

Description

connections.xml

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<connections xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
    <connection id="1" name="connection" type="4" refreshedVersion="6" background="1" refreshOnLoad="1">
        <webPr sourceData="1" parsePre="1" consecutive="1" xl2000="1"
            url="http://www.google.com"/>
    </connection>
</connections>

Expected Behavior

Actual Behavior

Please include a reproducible code snippet or document attachment that
demonstrates the issue.

[github-actions]

Welcome! Thanks for posting your first issue. The way things work here is that while customer issues are prioritized,
other issues go into our backlog where they are assessed and fitted into the roadmap when suitable.
If you need to get this done, consider buying a license which also enables you to use it in your commercial products.
More information can be found on https://unidoc.io/

[gunnsth]

@Explorer1092 Why would you want to read / edit those connections with unioffice? Would be nice to have the story so we can assess the feasibility and better understand.

[anovik]

@Explorer1092 Web connections, as shown in this issue, are considered legacy in MS Excel — they live under Legacy Wizards, are off by default in modern Excel for Windows, and aren't available at all in Excel for Mac or Excel for the Web. They may also trigger security prompts.

The modern replacement is Power Query (Data → Get Data → From Web). Implementing it in UniOffice is non-trivial because the M-code payload is stored as a proprietary DataMashup binary blob in customXml/item1.xml, which is not documented by Microsoft and would have to be built against reverse-engineered references.

That's why closing this.