Hi Everyone,
I'm trying to copy one value from a worksheet to another, but I'm doing something wrong. Can someone help me understand how to do this.
I'm trying to copy a value from workbook(Weekly Data.xlsx) worksheet(DateData)Column H row 4 to workbook(Weekly-temp.xlsx) worksheet (Cutter A - Marker Report) Column C row 4.
Value in Workbook(Weekly Data.xlsx) is in a date format "MM/DD/YY".
Veronica
I'm trying to copy one value from a worksheet to another, but I'm doing something wrong. Can someone help me understand how to do this.
I'm trying to copy a value from workbook(Weekly Data.xlsx) worksheet(DateData)Column H row 4 to workbook(Weekly-temp.xlsx) worksheet (Cutter A - Marker Report) Column C row 4.
Value in Workbook(Weekly Data.xlsx) is in a date format "MM/DD/YY".
# Import 'load_workbok' module from 'openpyxl' from openpyxl import load_workbook # Load existing excel file into a workbook object wb=load_workbook('Weekly-temp.xlsx') wb1=load_workbook('Weekly Data.xlsx') ws=wb['Cutter A - Marker Report'] ws1=wb1['DateData'] ws.cell(row=4,column=3).value=ws1.cell(row=4,column=6) # Saving the excel file using "wb.save" method wb.save("C:/Users/vhubb/Documents/Python Scripts/Cutter Reports/2021/01 - January/Week 01.xlsx")When I run this project I get this error:
runfile('C:/Users/vhubb/Documents/Python Scripts/Cutter Reports/CutterReportSetup3.py', wdir='C:/Users/vhubb/Documents/Python Scripts/Cutter Reports') Traceback (most recent call last): File "C:\Users\vhubb\Documents\Python Scripts\Cutter Reports\CutterReportSetup3.py", line 22, in <module> ws.cell(row=4,column=3).value=ws1.cell(row=4,column=6) File "C:\Users\vhubb\anaconda3\lib\site-packages\openpyxl\cell\cell.py", line 216, in value self._bind_value(value) File "C:\Users\vhubb\anaconda3\lib\site-packages\openpyxl\cell\cell.py", line 199, in _bind_value raise ValueError("Cannot convert {0!r} to Excel".format(value)) ValueError: Cannot convert <Cell 'DateData'.F4> to ExcelThanks,
Veronica