Print Page - Excel file linking

Title: Excel file linking
Post by: cibret24 on February 23, 2021, 13:12:37 PM

Hi! Is its possible to link an Excel file to a Business Object representation in the model?

Thank you.

Best regards,
Ana

Title: Re: Excel file linking
Post by: Phil Beauvoir on February 23, 2021, 13:22:59 PM

You can add links to local and online URLs as a Property value in the Properties tab.

Examples:

file:///c:/path_to/mysheet.xls
htps://www.someplace.net/files/mysheet.xls

The link can be opened by double-clicking on the icon in the Properties table, but not on the object in the View.

More details in the Archi User Guide page 67, section "User Properties"

Title: Re: Excel file linking
Post by: cibret24 on February 24, 2021, 10:38:31 AM

Thanks a lot for your reply. It helped me a lot!

Title: Re: Excel file linking
Post by: cibret24 on February 24, 2021, 12:32:06 PM

Follow up question: Can i add the path to a specific Excel Worksheet?

Thanks!

Title: Re: Excel file linking
Post by: Phil Beauvoir on February 24, 2021, 13:03:31 PM

Quote from: cibret24 on February 24, 2021, 12:32:06 PM
Follow up question: Can i add the path to a specific Excel Worksheet?

Thanks!

Not to a sheet. It is only a path to a file.

Title: Re: Excel file linking
Post by: steen.jensen@sll.se on February 25, 2021, 23:14:55 PM

Try this http://path/to/Workbook.xls#SheetName!a1

Archi Forum

Archi => General Archi Discussion => Topic started by: cibret24 on February 23, 2021, 13:12:37 PM