I see there are five NPOI code set the URL, EMAIL, FILE and DOCUMENT, UNKNOWN,
I want to want to set up the hyperlink address is other a sheet of a cell in the excel file,
The above five I found that I can only use the UNKNOWN, but after set up,
When I open the excel will be set to open the address, but the file is hidden,
Another problem is the connection Settings directly click to open it, you need to edit the link to click,
Really don't know how to operate, and the great spirit guide,

CodePudding user response:

Similar this kind of question, don't rely too much on c # to do, try to use VBA to realize

CodePudding user response:

reference 1st floor nuclear2011 response:

across Excel, as if can only link to another Excel file, unable to link to the file in one specific cell, can do you in the Microsoft Excel?

can use Microsoft's DLL, depressed, not only with other

CodePudding user response:

refer to the second floor it_gz_xi response:

similar this kind of question, don't rely too much on the c # to do, try to use VBA to implement

VBA to realize there is no problem, but I want to ask to use nopi

CodePudding user response:

Since the VBA no problem, c # is also can perform the VBA

CodePudding user response:

references to slowly little better reply: 3/f

Quote: refer to 1st floor nuclear2011 response:

across Excel, as if can only link to another Excel file, unable to link to the file in one specific cell, can do you in the Microsoft Excel?

can use Microsoft's DLL, depressed, not only just the other

You see if you can use the HYPERLINK formula