<div>
Thnaks for your command<br />
<br />
cell_destination = '#' + Sheet_name + '!$C$30' &nbsp; # if it for C30 cell from sheet_name<br />
sheet.Hyperlinks.Add(Ancho<wbr />r=cell_loc<wbr />ation, Address=cell_destination)<br />
<br />
by updating this my issue was resolved.
</div>


Thnaks for your command

cell_destination = '#' + Sheet_name + '!$C$30'   # if it for C30 cell from sheet_name
sheet.Hyperlinks.Add(Anchor=cell_location, Address=cell_destination)

by updating this my issue was resolved.

<div>
Solution according to author's comment
</div>


<div>
<div class="content wysiwyg-content">
I am new to python, Now am trying to update a cell with hyperlink which refer to another cell sheet. i have tryed with below code but while click the cell its showing error with &quot;Cannot open the specified file&quot;. Could you any one can help on this ?<br />
<br />
from win32com.client import Dispatch<br />
excel = Dispatch('Excel.Applicatio<wbr />n')<br />
book = excel.Workbooks.Open(&quot;Loca<wbr />tion.xls&quot;)<wbr /><br />
sheet = book.Worksheets(1)<br />
cell_location = sheet.Cells(2,2)<br />
cell_destination = book.Worksheets(2).Cells(1<wbr />,3)<br />
sheet.Hyperlinks.Add(Ancho<wbr />r=cell_loc<wbr />ation, Address=cell_destination) <br />
book.Save()
</div>
</div>


I am new to python, Now am trying to update a cell with hyperlink which refer to another cell sheet. i have tryed with below code but while click the cell its showing error with "Cannot open the specified file". Could you any one can help on this ?

from win32com.client import Dispatch
excel = Dispatch('Excel.Application')
book = excel.Workbooks.Open("Location.xls")
sheet = book.Worksheets(1)
cell_location = sheet.Cells(2,2)
cell_destination = book.Worksheets(2).Cells(1,3)
sheet.Hyperlinks.Add(Anchor=cell_location, Address=cell_destination) 
book.Save()

How to Add Hyperlink to cell for link another sheet cell

Python is a widely used general-purpose, high-level programming language. Its design philosophy emphasizes code readability, and its syntax allows programmers to express concepts in fewer lines of code than would be possible in other languages. Python supports multiple programming paradigms, including object-oriented, imperative and functional programming or procedural styles. It features a dynamic type system and automatic memory management and has a large and comprehensive set of standard libraries, including NumPy, SciPy, Django, PyQuery, and PyLibrary.

Python

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.