Exemplos de CurrencyRates.value em Python

Exemplo n.º 1

for i in invoices:
    SHIPLIST.append(SHIP)
    

ERpath = 'G:\\Supply Chain\\Data\\SHIPMENTS\\Electronic Register - SGS - Copy.xlsx'

EDR = openpyxl.load_workbook('
sheet = EDR.get_sheet_by_name('Register')

nextrow = int(sheet.max_row)+1

r=0
while r < len(invoices):
    for i in SHIPLIST:
        c = EDR['Register']['B'+str(nextrow)]
        c.value = int(i)
    for i in invoices:
        c = EDR['Register']['K'+str(nextrow)]
        c.value = int(i)
    for i in WH:
        c = EDR['Register']['G'+str(nextrow)]
        c.value = int(i)

        r=r+1
        nextrow = nextrow + 1
        
EDR.save('G:\\Supply Chain\\Data\\SHIPMENTS\\Electronic Register - SGS - Copy.xlsx')

Exemplo n.º 2

Arquivo: ConfirmShipment Sparex.py Projeto: lmichaele/Supply-Chain

AS = []
for i in invoices:
    AS.append(DMT)

EDR = openpyxl.load_workbook(
    'G:\\Supply Chain\\Data\\SHIPMENTS\\Electronic Register - SGS - Copy.xlsx')
sheet = EDR.get_sheet_by_name('Register')

nextrow = int(sheet.max_row) + 1

r = 0
while r < len(invoices):
    for i in WH:
        c = EDR['Register']['G' + str(nextrow)]
        c.value = int(i)
        r = r + 1
        nextrow = nextrow + 1

nextrow = nextrow - (len(invoices))

r = 0
while r < len(invoices):
    for i in SHIPLIST:
        c = EDR['Register']['B' + str(nextrow)]
        c.value = int(i)
        r = r + 1
        nextrow = nextrow + 1

nextrow = nextrow - (len(invoices))