8000 is it possible to check if cell has hyperlink? · Issue #98 · qax-os/excelize · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

is it possible to check if cell has hyperlink? #98

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
plandem opened this issue Aug 8, 2017 · 6 comments
Closed

is it possible to check if cell has hyperlink? #98

plandem opened this issue Aug 8, 2017 · 6 comments

Comments

@plandem
Copy link
plandem commented Aug 8, 2017 •
edited
Loading

Can't get a way to check if cell has any hyperlink
@xuri xuri added enhancement New feature or request in progress Working in progress labels Aug 8, 2017
xuri added a commit that referenced this issue Aug 8, 2017
@xuri
- New function GetCellHyperLink() added, relate issue #98;
a8cf38e 
- go test added
@xuri xuri removed enhancement New feature or request in progress Working in progress labels Aug 8, 2017
@xuri
Copy link
Member
xuri commented Aug 8, 2017

Thanks for your issue. I have added a function GetCellHyperLink().

@plandem
Copy link
Author
plandem commented Aug 8, 2017

thanks! will check later and write feedback

@plandem
Copy link
Author
plandem commented Aug 9, 2017 •
edited
Loading

Hmm, I'm getting nil here :(

func (f *File) GetCellHyperLink(sheet, axis string) (bool, string) {
	var link bool
	var target string
	xlsx := f.workSheetReader(sheet)
	axis = f.mergeCellsParser(xlsx, axis)
	if xlsx.Hyperlinks == nil || axis == "" {
		log.Println("empty hyper", xlsx.Hyperlinks, axis)
		return link, target
	}
....

Document has hyperlinks that must be "fixed" - i.e. to external non-existing file, I can see them at Excel, but I can't get it via library :( Any ideas?

P.S.: I need to check my file and write at log, that there some external links.

@xuri
Copy link
Member
xuri commented Aug 9, 2017

The function GetCellHyperLink() just support get two types of hyperlink External for web site or Location.

@plandem
Copy link
Author
plandem commented Aug 9, 2017 •
edited
Loading

ok, "external" can point to file also, I mean at Excel I see next link:

='/Debian/public/xxxx/yyy/xxxx/[FILE_NAME.xls]SHEET_NAME'!H25

this file doesn't exist (link is broken) and I'm trying to log such kind of broken links, but I can't get hyperlink for this cell - xlsx.Hyperlinks is nil :(

@xuri
Copy link
Member
xuri commented Aug 9, 2017

Please provide file attachments If you can.

@plandem plandem closed this as completed Aug 21, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@plandem @xuri
0