You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
currently, we can only get hyperlink cell by cell which is inefficient
rows, _:=e.GetRows(sheetName)
forrowNumber, row:=rangerows{
forcellNumber, cell:=rangecols {
cellRef:=toCellRef(rowNumber, cellNumber+1)
ifok, link, _:=e.GetCellHyperLink(sheetName, cellRef); ok {
// do something to the link
}
}
}
provide a function to get all external hyperlinks will enable a more flexible way to deal with hyperlinks
rows, _:=e.GetRows(sheetName)
links, _:=e.Hyperlinks(sheetName)
// k is a cellRef like 'A1' vfork, v:=rangelinks {
rowNumber, cellNumber:=toCellPosition(k)
fmt.Printf("cell %s : value is %s and has link to %s\n ", k, rows[rowNumber][cellNumber-1], v)
}
please comments on this and I am glad to open a pull request to implement it.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
currently, we can only get hyperlink cell by cell which is inefficient
provide a function to get all external hyperlinks will enable a more flexible way to deal with hyperlinks
please comments on this and I am glad to open a pull request to implement it.
Beta Was this translation helpful? Give feedback.
All reactions