gpt4 book ai didi

Excel 超链接需要不必要的额外登录

转载 作者:行者123 更新时间:2023-12-02 09:37:52 25 4
gpt4 key购买 nike

我使用以下内容创建了一个 excel 超链接: =HYPERLINK("https://abc.com/ "&A1)

当我点击它时,它会在 Chrome 中打开一个新标签页,要求我登录(该页面包含敏感信息并需要用户身份验证),即使我之前已经登录过。

但是,如果我要从单元格中复制并将其直接粘贴到 Chrome 的 url 栏中,它会自动将我带到该页面而无需再次登录。

有没有办法回避这个问题?

最佳答案

Bharath在这里对类似问题的回答:
Excel Hyperlinks redirecting to login

  1. Create a redirect.html page in your public folder (public folder because you are using ROR)
  2. Copy this to your redirect.html

 <html>
<body>
Please wait, loading your page...
<script type="text/javascript">
function getQuerystring(key) {
key = key.replace(/[\[]/,"\\\[").replace(/ [\]]/,"\\\]");
var regex = new RegExp("[\\?&]"+key+"=([^&#]*)");
var query = regex.exec(window.location.href);
return query[1];
}
window.location = "http://" + window.location.host + "/" + getQuerystring('page');
</script>
</body>
</html>

The links you are constructing in excel should be modified

For e.g Old link - http://test.com/post/comments/1 New link should be - http://test.com/redirect.html?page=post/comments/1

You need to pass the part of URL (after base url) as a param How this works.

When user clicks a link in excel it points to redirect.html and the javascript constructs the actual URL and redirects again to proper page, user will be navigated to actual page if already logged in else redirected to Login/Home page.

关于Excel 超链接需要不必要的额外登录,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/24619778/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com