EVRY is a leading Nordic tech and consulting company. Together with our customers and an ecosystem of the best global digital experts, we shape the future today by applying new technologies to improve end user experiences, and the performance of people, processes and systems. We are close to our customers and represent a Nordic mindset on responsibility, quality and security. We leverage our Nordicness to do business in more than 18 countries. EVRY is listed on Oslo Stock Exchange. Our 8 800 employees are passionate about creating digital advantage and shaping the future – today.

If there are hyperlinks in the excel cells, the regular Read Cell activity returns only the text to display and not the actual URL.This custom activity returns the hyperlink address from the cell. To do this you need to provide the following input details:<ul><li>cell address: e.g. A2</li><li>path of the Excel file</li><li>sheet name where the cell containing the URL is.</li></ul>

Reads any URL from Excel cells hidden by text alias

MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Great component - Great component. It doesn't even open Excel while running, unlike the custom VBA code.


 - Very nice component.  I am struggling to read hyperlinks in excel.  Your excel activity is really useful for me. 


 - Great idea to create this activity! It saves a lot of time during development!


 - good and well-working solution. Thanks a lot!


 - I liked this one a lot, very straight forward. I didn't know when there's a hyperlink or a string URL, and in my case this is happening sometime, to have a mixture of both - that is why I had to first read the actual cell value and search for URL specific elements - if one couldn't be found, I then used this component. Anyway, great thing, really helpful. Thanks!


 - It does what it promises with a major bug: It leaves the excel process running (Windows 10).
So, when you iterate and want to extract e.g. 10 links, it will leave 10 different excel processes running which drains the computer memory for no reason.


Evry - Read Excel Cell URL

Evry - Read Excel Cell URL

Help

How To