Hi,
thanks for your post, and sorry for the trouble.
Unfortunately, I’ll have to disappoint you here. TablePress can not directly import links from an Excel file, as those use a different technical structure. TablePress however requires links to be HTML code :-/
Making those clickable would have to be done in Excel, e.g. by using a macro to convert them to HTML code there. A user has shared his solution at http://wordpress.org/support/topic/hyperlinks-in-cells?replies=6#post-4710730 Maybe that’s helpful here as well.
Regards,
Tobias
Cheers was a big help, I altered the macro to take a link from column A, the title from column B, and produce html code in column C
ColumnB
Sub links()
LastRow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
For I = 2 To LastRow
Cells(I, 2).Value = “” & Cells(I, 3).Value & ““
Next I
End Sub
Hope this helps anyone else
Hi,
awesome! Good to hear that this helped! Thanks for sharing your solution!
Best wishes,
Tobias
sorry didnt display correctly
Sub links()
LastRow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
For I = 2 To LastRow
Cells(I, 2).Value = "<a href=" & Chr(34) & "" & Cells(I, 1).Value & Chr(34) & ">" & Cells(I, 3).Value & "</a>"
Next I
End Sub
cheers no problem
Hi,
ah, yes, now the formatting is better.
Best wishes,
Tobias
