Currently I take an excel file and extract the data from a sheet with openpyxl, which gives me an object with several tuples from each excel row, these rows I save in an array (baseBitacora) to then take each "line" or tuple and add the date, then save it in another excel.
This is my code.
l_Alerta = openpyxl.load_workbook("D:/Plantilla.xlsm",read_only = False, keep_vba = True)
h_Alerta = l_Alerta.worksheets[0]
lBitacora = openpyxl.load_workbook("D:/Bitacora.xlsm",read_only = False, keep_vba = True)
hBitacora = lBitacora.worksheets[0]
baseBitacora = []
baseBitacora2 = []
a = []
h_bitacora = hora_Ejecucion.strftime("%d-%m-%Y %H-%M")
print("AGREGANDO DATOS a baseBitacora ")
for row in h_Alerta.values:
baseBitacora.append(row)
print("AGREGANDO HORA EN LA BITACORA") #Aca es donde me da error y no logro unir los datos del excel con la hora
for row in baseBitacora:
a = row
baseBitacora2 = a.append(h_bitacora)
print("baseBitacora2 ",baseBitacora2)
print("AGREGANDO DATOS EN LA HOJA BITACORA")
for row in baseBitacora2:
print(row)
hBitacora.append(row)
lBitacora.save("D:/bitacora.xlsm")
lBitacora.close()
l_Alerta.close()