python - add hyperlink to excel sheet created by pandas dataframe to_excel method -

-

i have converted pandas dataframe excel sheet using df.to_excel.

now, want add hyperlinks values in 1 column. in other words, when customer sees excel sheet, able click on cell , bring webpage (depending on value in cell).

you use hyperlink function 

import pandas pd df = pd.dataframe({'link':['=hyperlink("http://www.someurl.com", "some website")']}) df.to_excel('test.xlsx')

Comments

Post a Comment

Popular posts from this blog

amazon web services - S3 and apache mod_proxy with basic authentication -

-
i'd redirect s3 bucket in ssl basic authentication of files (apk files) apache mod_proxy. ssl , mod_proxy work, basic authentication ignored. <virtualhost *:443> servername resources.mydomain.jp <filesmatch "\.apk$"> order deny,allow setenvif user-agent ".*android.*" allow_ag options followsymlinks allow env=allow_ag deny authtype basic authname "secret zone" authuserfile /etc/httpd/.htpasswd require user xxx_customer </filesmatch> sslengine on sslproxyengine on sslprotocol -all +sslv3 +tlsv1 sslciphersuite all:!adh:rc4+rsa:+high:+medium:-low:-sslv2:-exp sslcertificatefile conf.d/xxx.cer sslcertificatekeyfile conf.d/xxx.key sslcacertificatefile conf.d/xxx.cer proxypass / http://resources.mydomain.jp.s3-website-ap-zone-1.amazonaws.com/ proxypa...
Read more

How to install ruby on rails -

-
i newbie ruby on rails, here trying install ruby on rails on windows 7 64 bit. installed ruby installer , installed rails. , created new app files. when start rails server showing following errors. how can rid of these errors , start developing ruby application? c:\users\walnut\desktop > bundle install fetching gem metadata https://rubygems.org/............ fetching version metadata https://rubygems.org/... fetching dependency metadata https://rubygems.org/.. resolving dependencies................. using rake 10.4.2 using i18n 0.7.0 installing json 1.8.3 native extensions gem::installerror: 'json' native gem requires installed build tools. please update path include build tools or download devkit 'http://rubyinstaller.org/downloads' , follow instructions @ 'http://github.com/oneclick/rubyinstaller/wiki/development-kit' error occurred while installing json (1.8.3), , bundler cannot continue. make sure `gem install json -v '1.8.3'` succeeds be...
Read more

powershell - This solution contains one or more assemblies targeted for the global assembly cache -

-
Image
i having sharepoint site deployed through sharepoint powershell. wsp build through visual studio 2013. all projects in solution not signed assemblies(project->right click->properties->signing->sign assemblies check box unchecked). taking wsp of solution publishing , deploying sharepoint using sharepoint powershell. when try this, getting following error: when googled solution. many of them suggesting check 'sign assemblies' check box. don't want do, because facing other issues packages install through nugget. sign libraries of solution go properties of project click signing tab , check sign libraries options , create new strong name file or without password , rebuild , deploy.
Read more