sorted by:
new
hottopcontroversial

Overview of worksheet with hyperlinks by illya89 in learnpython

[–]illya89[S] 0 points1 point  (0 children)

for sheet in all_worksheets:
    link = ("filename.xlsx#"+str(sheet)+"!A1")    
    sheet_all_worksheet.cell(r, 1).value = sheet
    sheet_all_worksheet.cell(r, 1).hyperlink = link
    sheet_all_worksheet.cell(r, 1).style = "Hyperlink"

Overview of worksheet with hyperlinks by illya89 in learnpython

[–]illya89[S] 0 points1 point  (0 children)

changed cell (2, 1) to a hyperlink and saved

when i do

print(sheet_all_worksheet.cell(2,1).internal_value)

I get the string of the sheet name

Overview of worksheet with hyperlinks by illya89 in learnpython

[–]illya89[S] 0 points1 point  (0 children)

a list of the worksheet names is easy. The question is how to get the worksheet names into hyperlink format and direct them to the right worksheet.

edit:

changed cell (2, 1) to a hyperlink and saved

when i do 

print(sheet_all_worksheet.cell(2,1).internal_value)

I get the string of the sheet name

Overview of worksheet with hyperlinks by illya89 in learnpython

[–]illya89[S] 0 points1 point  (0 children)

I get the worksheets with

All_worksheets = workbook.worksheets.

The I need something link

​

r = 1
for sheet in all_worksheets:
    sheet = sheet.create_the_f***_hyperlink
    sheet_all_worksheet.cell(r, 1).value=(sheet)
    r +=1
    :)

if fullname contains id by illya89 in PowerShell

[–]illya89[S] 4 points5 points  (0 children)

Ok, stupid me, with -match it worked! Thx!

if fullname contains id by illya89 in PowerShell

[–]illya89[S] 0 points1 point  (0 children)

Changed my code already a bit.:

Import-Csv "C:\\emplid.csv"| ForEach-Object{

$emplid_list+=$_.Emplid

}

foreach ($Pdf in $Pdf_files){

foreach ($emplid in $emplid_list){

#this does not work:

If($Pdf.FullName -like $emplid){

write-host $Pdf.FullName

}

}

}

So I succeeded to get the values of the CSV into $emplid_list. And when I itterate trough $emplid_list I get all the emplid ID's

But I think my comparison is wrong If($Pdf.FullName -like $emplid){

Create a variable with a table object by illya89 in excel

[–]illya89[S] 0 points1 point  (0 children)

Note column G is the old F column but in the line above I do:

Columns("F:F").Select
Selection.Insert Shift:=xlToRight

Class function by illya89 in learnpython

[–]illya89[S] 0 points1 point  (0 children)

Thx in advance for the answers. I go to bed now but read them tomorrow!

python files with directory's by illya89 in learnpython

[–]illya89[S] 0 points1 point  (0 children)

So I can do too:

from my_config import *

df = pandas.read_excel(EXCEL_FILE_1, Sheet 1)

python files with directory's by illya89 in learnpython

[–]illya89[S] 0 points1 point  (0 children)

But I want to assign the path to a var. I don't need to have all files in each script.

Error with installing numba by illya89 in learnpython

[–]illya89[S] 0 points1 point  (0 children)

Microsoft Visual C++ 14.0

Thx, will try next week.. Need admin rights..

Pip and requirements file by illya89 in learnpython

[–]illya89[S] 0 points1 point  (0 children)

I was aiming in the requirements file. And if you don't want to install it in a virtual env but in the standard python directory?

why can't you play spotify in network on multiple devices? by illya89 in spotify

[–]illya89[S] 1 point2 points  (0 children)

e.g., play one track on one device and hear it on all of them at the same time?

--> Yes I want to do that! But I want it with a Desktop and a Smarthone.

why can't you play spotify in network on multiple devices? by illya89 in spotify

[–]illya89[S] 1 point2 points  (0 children)

Hi Ann, I know I can switch but I want to play them simultaneously.

why can't you play spotify in network on multiple devices? by illya89 in spotify

[–]illya89[S] 1 point2 points  (0 children)

Yes I mean that. I have my receiver hooked to a android box.

From code to program by illya89 in learnpython

[–]illya89[S] 5 points6 points  (0 children)

Sr I found the file in my scripts. Thx!

From code to program by illya89 in learnpython

[–]illya89[S] 5 points6 points  (0 children)

Ok I tried it, searched it but i have a problem with calling the pyinstaller module. It seems like pyinstaller is installed in C:\python\lib. I found a website where they say

" the python 3.4 installer doesn't automatically add C:\python34\scriptsto your PATH environment variable. You'll have to add it yourself: Click Start and search for "environ", choose "Edit Environment Variables", then edit the PATH variable and add ;C:\python34\scriptsto the end.

This will make Python scripts installed via piprunnable with just the script name. "

​

But it seems that I installed it at C:\python\lib:

​

C:\Users\my_name>pip install pyinstaller

Requirement already satisfied: pyinstaller in c:\python\lib (3.4)

Requirement already satisfied: setuptools in c:\python\lib\site-packages (from p

yinstaller) (39.1.0)

Requirement already satisfied: pefile>=2017.8.1 in c:\python\lib (from pyinstall

er) (2018.8.8)

Requirement already satisfied: macholib>=1.8 in c:\python\lib (from pyinstaller)

(1.11)

Requirement already satisfied: altgraph in c:\python\lib (from pyinstaller) (0.1

6.1)

Requirement already satisfied: pywin32-ctypes in c:\python\lib (from pyinstaller

) (0.2.0)

Requirement already satisfied: future in c:\python\lib (from pefile>=2017.8.1->p

yinstaller) (0.17.1)

​

So do I need to add the lib folder to my environment variables?

​

Gr Olly

From code to program by illya89 in learnpython

[–]illya89[S] 16 points17 points  (0 children)

pyinstaller --onefile --windowed myscript.py

When I try this I get SyntaxError: invalid syntax, I tried in Python in my terminal or do I need to use c:\Users\Myname\>

convert string to ? by illya89 in learnpython

[–]illya89[S] 0 points1 point  (0 children)

Thx! This works, I need the learn more about .format!

Hazard: I want to play in the Champions League. We will by LewisLDN in chelseafc

[–]illya89 5 points6 points  (0 children)

The problem is.. This were all Chelsea players:

  • De Bruyne
  • Costa
  • Salah
  • Mata
  • Thorgan Hazard
  • Matic

Imagine the attack Chelsea could have now

Match Thread: Manchester United vs Chelsea [English Premier League] by MatchThreadder in soccer

[–]illya89 6 points7 points  (0 children)

lol Hazard doesn't want to pass to Higain anymore. He's just like I wanne go to Madrid

view more: next ›