以文本方式查看主题

-  Foxtable(狐表)  (http://www.foxtable.com/bbs/index.asp)
--  专家坐堂  (http://www.foxtable.com/bbs/list.asp?boardid=2)
----  如何设置超链接(链接到同一个excel工作簿的其他工作表)  (http://www.foxtable.com/bbs/dispbbs.asp?boardid=2&id=145281)

--  作者:季朝龙
--  发布时间:2020/1/14 17:32:00
--  如何设置超链接(链接到同一个excel工作簿的其他工作表)
如何设置超链接(链接到同一个excel工作簿的其他工作表),希望单机“项目总表”的每个项目,可以打开对应的项目明细,工作簿定义代码如下:


Dim dt As Table = Tables("项目总表")
Dim dt1 As Table = Tables("项目总表.AA")
Dim Book As New XLS.Book \'定义一个Excel工作簿
Dim Sheet As XLS.Sheet = Book.Sheets(0) \'引用工作簿的第一个工作表
Dim Style As Xls.Style = Book.NewStyle \'新建一个样式
Style.BackColor = Color.Red \'样式的背景颜色设为红色
For c As Integer = 0 To dt.Cols.Count -1 \'添加列标题
    Sheet(0, c).Value = dt.Cols(c).Name
Next
For r As Integer = 0 To dt.Rows.Count - 1 \'填入数据
CurrentTable.Position = r
    book.Sheets.Add(dt.rows(r)(0))
    Dim Sheet1 As XLS.Sheet = Book.Sheets(r+1) \'循环引用工作簿的工作表
    For c1 As Integer = 0 To dt1.Cols.Count -1
        Sheet1(0, c1).Value = dt1.Cols(c1).Name
    Next
    For r1 As Integer = 0 To dt1.Rows.Count - 1
        For c0 As Integer = 0 To dt1.Cols.Count -1
            Sheet1(r1 +1, c0).Value = dt1.rows(r1)(c0)
        Next
        
    Next
    For c As Integer = 0 To dt.Cols.Count -1
        Sheet(r +1, c).Value = dt.rows(r)(c)
    Next
Sheet(r+1,0).Hyperlink = Book.Sheets(r+1)(狐狸爸爸帮我看看这句代码该怎么改)
Next
\'打开工作簿
Book.Save("c:\\reports\\test.xls")
Dim Proc As New Process
Proc.File = "c:\\reports\\test.xls"
Proc.Start()



--  作者:有点蓝
--  发布时间:2020/1/14 20:23:00
--  
上面这种用不了,需要使用vba:http://www.foxtable.com/webhelp/topics/2121.htm

Dim App As New MSExcel.Application

Dim Wb As MSExcel.Workbook = App.WorkBooks.Open("D:\\123.xls")
Dim Ws As MSExcel.WorkSheet = Wb.WorkSheets(1)
Dim range  = Ws.Range("A1")
Ws.HyperLinks .Add (range,"#Sheet2!B3" ,"","提示文字","链接文字")
Wb.Save
App.Visible = True