BookmarkSubscribe
Choose Language Hide Translation Bar
Françoise
Community Trekker

excel + hypertext link

hi,

 

I have an excel file with a hypertext link to pictures inside cells

I have too many links.

 

is it possible to import the links in JMP file?

 

best regards

 

0 Kudos
3 REPLIES 3
Jeff_Perkinson
Community Manager Community Manager

Re: excel + hypertext link

Can you provide an example Excel file to help us understand what you're dealing with?

-Jeff
0 Kudos
Françoise
Community Trekker

Re: excel + hypertext link

hi,

 

excuse me to be late, but I did' nt see your question: I don't receive email when someones replies me (even this option is checked).

 

an image of the xls file is below: you can see the link in blue. When I click on this link, it opens a picture.

 

Since my message, I 've found a solution I want to share:

All the pictures are  in a single file. I use photofiltre to reduce the sizes of all pictures (*.jpg). It does it all at once, and after that, I use JMP with "import multiple files" which create a new file with all my pictures. After, I join this file .jmp with a data table file . jmp , and all is perfect !

 

best regardslink xls.jpg

 

Jeff_Perkinson
Community Manager Community Manager

Re: excel + hypertext link

Thanks for the additional information and details. It looks like the cells of the spreadsheet have the "link" attribute. 

 

JMP doesn't do anyhing with that at the moment. Add an entry to the JMP Wish List to let us know if you want that in the future.

-Jeff
0 Kudos