Search

Proxy support

Configure your Add-in settings file to connect via a proxy server.

Customize the example below as a template to make your configuration:

  1. <ProxySupport>
  2. <SelectedProxy>Override</SelectedProxy> <!-- Can be one of the following: None/Legacy/System/Override -->
  3. <SelectedOverrideProxyName>SmoothWall</SelectedOverrideProxyName>
  4. <OverrideProxies>
  5. <ProxySetting Name="SmoothWall" Address="http://192.168.0.1" Port="800" />
  6. </OverrideProxies>
  7. </ProxySupport>

Your selected proxy sets your configuration type. Choose from these four types of configurations:

  • None
    This is the default setting. Keep this setting if you do not require any proxy support.
    Edit Line 2 of the above template to the following:
    2 <SelectedProxy>None</SelectedProxy>
    Lines 4-6 aren't required for this setting.
  • Legacy
    Use this setting to enable the Excel Add-in version 2.6 to support your system's proxy server.
    The Excel Add-in reads Microsoft Internet Explorer (IE) proxy settings.
    Edit Line 2 of the above template to the following:
    2 <SelectedProxy>Legacy</SelectedProxy>

    Here is an example of the code the Excel Add-in applies to link to the proxy server:
    WebProxy defaultProxy = WebProxy.GetDefaultProxy();
  • System
    Use this setting to enable the Excel Add-in version 3.0 and above to support your system's proxy server.
    The Excel Add-in reads Microsoft Internet Explorer (IE) proxy settings.
    Edit Line 2 of the above template to the following:
    2 <SelectedProxy>System</SelectedProxy>

    Here is an example of the code the Excel Add-in applies to link to the proxy server:
    var systemWebProxy = new WebProxy(WebRequest.GetSystemWebProxy().GetProxy(uri));
  • Override
    Use this setting to enable the Excel Add-in to support a proxy server of your choice.
    You provide the details of the proxy server in the settings file. This setting bypasses your system's proxy server.
    Match the Override proxy with the name on the Override proxy list.
    Edit line 3 in the template by replacing SmoothWall with the name of the proxy server you want to connect to.
    Edit line 5 so:
    • SmoothWall is replaced with the name of your proxy server.
    • The http address is the same as that of your proxy server.
    • The port is the same number as your proxy server:
      2 <SelectedProxy>Override</SelectedProxy>
      3 <SelectedOverrideProxyName>SmoothWall</SelectedOverrideProxyName>

      4 <OverrideProxies>
      5 <ProxySetting Name="SmoothWall" Address="http://192.168.0.1" Port="800" />
      6 </OverrideProxies>