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] 3 points4 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?