Excel file linking

Started by cibret24, February 23, 2021, 13:12:37 PM

Previous topic - Next topic

cibret24

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

Thank you.

Best regards,
Ana

Phil Beauvoir

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"
If you value and use Archi, please consider making a donation!
Ask your ArchiMate related questions to the ArchiMate Community's Discussion Board.

cibret24

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

cibret24

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


Thanks!

Phil Beauvoir

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.
If you value and use Archi, please consider making a donation!
Ask your ArchiMate related questions to the ArchiMate Community's Discussion Board.

steen.jensen@sll.se

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