I am trying to open a large excel file (.xlsx) to ad some rows of data from another excel file. However, due to the size of the destination file i am getting the memory error. I tried the below, however when i create the worksheet object it is creating a readonly worksheet and i am unable to add data.
Can someone tell me how to open the large excel file using openpyxl load_workbook method in write only mode?
Dinil Karun E