excel using c#.net

Question

i have two excel file . file 1 : excel sheet i have 50 rows file 2 : excel sheet i have 50 rows same file row in any order i insert the hyperlink in file 2 sheet column when i click the hyperlink in second file sheet .it will open the first file corressponding row (only select) using C#.net

alice yang · Answer

Hi Kumar Yoga You can use free Spire.Xls to achieve this: http://www.e-iceblue.com/Introduce/free-xls-component.html And refer to following Tutorial : http://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Add-Excel-Hyperlinks-in-C-/VB.NETLinks-to-a-File.html

imran azam · Answer

To achieve this task use Microsoft docX.dll . You can search on Google.Hopes it will help you.