Hey guys again,
so lets say we have an excel workbook with 12 worksheets. Each worksheet has two tables in it as you can see in the image below
Question one: Is it possible to get a row from the UNPAID table and move it to the PAID table?
Question two: If the former is possible, is it also possible to move the row from worksheet to worksheet?
This is what I have right now to just save. But I can't seem to be able to find the answer.
so lets say we have an excel workbook with 12 worksheets. Each worksheet has two tables in it as you can see in the image below
Question one: Is it possible to get a row from the UNPAID table and move it to the PAID table?
Question two: If the former is possible, is it also possible to move the row from worksheet to worksheet?
This is what I have right now to just save. But I can't seem to be able to find the answer.
writer= pd.ExcelWriter('Some.xlsx',engine='openpyxl', index=False) writer.book = load_workbook('Some.xlsx') writer.sheets=dict((ws.title,ws) for ws in writer.book.worksheets) reader = pd.read_excel(r'Some.xlsx',sheet_name=minas) print_together.insert(0,len(reader)+1) data = pd.DataFrame(data =print_together) data=data.transpose() data.to_excel(writer,sheet_name=minas,header=False, index = None,startrow=len(reader)+1) writer.save()