指向存储在Sharepoint数据库中的特定Excel工作表的超链接 [英] Hyperlink to a specific Excel worksheet that is stored in a Sharepoint Data Library

问题描述

我正在尝试在word文档中创建一个超链接，该超链接将用户带到存储在SharePoint数据库中的Excel电子表格的特定工作表。我试过这些东西...... 要么它出错了，要么把我带到最后保存到
的工作表上。

• < a href ="http：//xxx/collab/xx/metrics/Data%20Library/3Q%202018%20%20Reporting.xlsx#'WorksheetName'"> http：// xxx / collab / xx / metrics / Data％20Library /3Q%202018%20%20Reporting.xlsx#'WorksheetName'
• HTTP：！//xxx/collab/xx/metrics/Data%20Library/3Q%202018%20%20Reporting.xlsx#'WorksheetName'A1
• HTTP： '？幅= 1范围=' //xxx/collab/xx/metrics/Data%20Library/3Q%202018%20%20Reporting.xlsx#'WorksheetName TAsTCsTimeInPhase'
• http：// xxx / collab中/ XX /度量/数据％20Librar y / 3Q％202018％20％20Reporting.xlsx＃'WorksheetName'？web = 1& range ='TAsTCsTimeInPhase'
• http://xxx/collab/xx/metrics/Data%20Library/3Q%202018 ％20％20Reporting.xlsx＃'WorksheetName'？web = 1？（'TAsTCsTimeInPhase'）
• HTTP：//xxx/collab/xx/metrics/Data%20Library/3Q%202018%20%20Reporting.xlsx ＃'WorksheetName'？web = 1&（'TAsTCsTimeInPhase'）

解决方案

您好VLC65，

存储在SharePoint库中的Excel文件仅支持文件的链接而不支持Excel中的工作表。

请使用嵌入Word中的此链接，它将打开Excel，然后您可以在Excel应用程序中处理特定的工作表：

谢谢

最佳此致

I'm trying to create a hyperlink in a word document that will take the user to a specific worksheet of an Excel spreadsheet that is stored in a SharePoint Data Library. I have tried these things...  Either it errors out or takes me to the sheet it was last saved to.

• http://xxx/collab/xx/metrics/Data%20Library/3Q%202018%20%20Reporting.xlsx#'WorksheetName'
• http://xxx/collab/xx/metrics/Data%20Library/3Q%202018%20%20Reporting.xlsx#'WorksheetName'!A1
• http://xxx/collab/xx/metrics/Data%20Library/3Q%202018%20%20Reporting.xlsx#'WorksheetName'?web=1?range='TAsTCsTimeInPhase'
• http://xxx/collab/xx/metrics/Data%20Library/3Q%202018%20%20Reporting.xlsx#'WorksheetName'?web=1&range='TAsTCsTimeInPhase'
• http://xxx/collab/xx/metrics/Data%20Library/3Q%202018%20%20Reporting.xlsx#'WorksheetName'?web=1?('TAsTCsTimeInPhase')
• http://xxx/collab/xx/metrics/Data%20Library/3Q%202018%20%20Reporting.xlsx#'WorksheetName'?web=1&('TAsTCsTimeInPhase')

解决方案

Hi VLC65,

The Excel file stored in SharePoint library only supported the link to the file not the worksheet within the Excel.

Please use this link embed in Word, it will open the Excel and then you can handle specific worksheet in Excel application:

Thanks

Best Regards

这篇关于指向存储在Sharepoint数据库中的特定Excel工作表的超链接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！