python with link or location /anchor > 255 characters since it exceeds excel's limit for URLs force_unicode(urls)) code example
Example: pandas dataframe to excel hyperlink length limit
writer = pandas.ExcelWriter(r'file.xlsx', engine='xlsxwriter',options={'strings_to_urls': False})
df.to_excel(writer)
writer.close()