Converting Hyperlinks

SaveToDB products detect cell URLs and allow opening them using the context menu.

You can configure converting URLs to hyperlink objects to open them on click, using the AddHyperlinks event in the xls.handlers table.

You can use this feature also to make an interactive table of contents creating hyperlinks to connected database objects in an Excel or DBEdit workbook.

For example, here is a configuration:

ID	TABLE_SCHEMA	TABLE_NAME	COLUMN_NAME	EVENT_NAME	HANDLER_SCHEMA	HANDLER_NAME	HANDLER_TYPE	HANDLER_CODE
	dbo	view_index	object	AddHyperlinks			ATTRIBUTE

Here is a sample of a Microsoft SQL Server view used to create the table of contents:

CREATE VIEW [doc].[view_index]
AS

SELECT
    ROW_NUMBER() OVER(ORDER BY s.name, o.name) AS [#]
    , s.name + '.' + o.name AS [object]
FROM
    sys.objects o
    INNER JOIN sys.schemas s ON s.[schema_id] = o.[schema_id]
WHERE
    o.[type] IN ('U', 'V', 'P')
    AND s.name IN ('doc')
    AND NOT o.name LIKE 'xl_%'
    AND NOT o.name LIKE '%_change'